Snowflake
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.
IP whitelisting
If your database has restrictions on incoming network connections, you'll need to ensure the
Airplane IP addresses are whitelisted:
- 34.121.89.145
- 34.68.100.27
- 34.72.182.225
Field reference
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. The available fields are documented below.idstring
The ID of the resource.
slugstring
The slug of the resource as defined in the resource settings page.
namestring
The name of the resource.
The kind of the resource.
accountstring
The Snowflake account.
warehousestring
The virtual warehouse name.
databasestring
The name of the database.
schemastring
The name of the schema.
rolestring
The role configured for the Snowflake resource.
usernamestring
The login username.
passwordstring
The login password.
dsnstring
The dsn of the server.