List all available external Snowflake scripts

Learn how to retrieve SQL script templates for Snowflake tasks, streams, views, and tables using the Scripts API.

Prerequisites:

The Snowflake internal staging adapter must be configured and enabled for your tenant.
You must be authenticated using the Secrets.
You need the adapter name used in your tenant configuration.

Send a POST request to the Scripts without a request body

To retrieve a script template with unresolved placeholders, send a POST request to the following endpoint:


POST {{hub-url}}/api/tenants/{{tenantID}}/adapters/{{adapterName}}/scripts?name=entities.stream

Leave the request body empty to receive the script as a template with placeholders:


CREATE STREAM <database>.<schema>."entitiesStream"
ON TABLE <database>.<schema>.<landingTableName>
APPEND_ONLY = true;

Replace the script name to explore other templates
To list other available scripts, change the name query parameter to match another supported script, such as:
- relations.views_all
- interactions.views_all
- db.tasks.create-task-entitiesTask
- db.streams.create-stream-entitiesstream
- db.tables.create-table-entities
Each script returns a template SQL statement that you can populate and run in Snowflake. For a complete list of supported scripts, see External script index for Snowflake.

You now have access to supported Snowflake script templates that you can use to automate the creation of views, tables, streams, and tasks in your Snowflake account.

Unify and manage your data

List all available external Snowflake scripts

Footer