Snowflake

The Snowflake resource allows tasks and runbooks to connect to a Snowflake database. For a high-level introduction to resources, see the resources page.

To create a new Snowflake resource, visit resources for your team, click the "New" button, and select the Snowflake resource type. Enter your connection details in the form:

Name should be a human-readable name for your resource.

Account should be the account identifier for your Snowflake account.

Enter a Warehouse, Role, and Database and Schema to complete your Snowflake resource.

If your database has restrictions on incoming network connections, you'll need to ensure the Airplane IP addresses are whitelisted:

You can issue SQL queries against your Snowflake resource from tasks by using the SQL SDK. See SQL SDK reference for more information.

When this resource is attached to a task, its fields are available in the JSON environment variable AIRPLANE_RESOURCES under the alias it was attached with. For more information, see the Snowflake field reference.