Connect to Snowflake warehouses from Airplane tasks and runbooks.
The Snowflake resource allows tasks and runbooks to connect to a Snowflake database. For a high-level introduction to resources, see the resources page.
Creating a Snowflake resource
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:
When this resource is attached to a task, its fields are available in the JSON environment variable
AIRPLANE_RESOURCESunder the alias it was attached with. The available fields are documented below.
The ID of the resource.
The slug of the resource as defined in the resource settings page.
The name of the resource.
The kind of the resource.
The Snowflake account.
The virtual warehouse name.
The name of the database.
The name of the schema.
The role configured for the Snowflake resource.
The login username.
The login password.
The dsn of the server.