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.
Enter a Warehouse, Role, and Database and Schema to complete your Snowflake resource.

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

Accessing from tasks

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

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. For more information, see the Snowflake field reference.