Snowflake integration

Snowflake is a cloud-based data warehousing platform.

Windmill natively supports Snowflake scripts:

SQL (PostgreSQL, MySQL, MS SQL, BigQuery, Snowflake) quickstart

Learn how to build your first script in PostgreSQL, MySQL, BigQuery, Snowflake.

To integrate Snowflake with Windmill, you need to gather the following information and save it as a resource.

Property	Type	Description	Default	Required	Where to Find
account_identifier	string	Snowflake account identifier		true	Snowflake Console > Account > Account Info > Account Identifier
private_key	string	Snowflake private key		true	Snowflake Console > Account > Security > RSA Key Pair
public_key	string	Snowflake public key		true	Snowflake Console > Account > Security > RSA Key Pair
warehouse	string	Snowflake warehouse name		true	Snowflake Console > Warehouses
username	string	Snowflake username for authentication		true	Snowflake Console > Users and Security > Users
database	string	Snowflake database name		true	Snowflake Console > Databases
schema	string	Snowflake schema name		true	Snowflake Console > Databases > [Your Database] > Schemas
role	string	Snowflake role for access control		true	Snowflake Console > Users and Security > Roles

Your resource can be used passed as parameters or directly fetched within scripts, flows and apps.

tip

Find some pre-set interactions with Snowflake on the Hub.