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.
Build a sample Snowflake app using OAuth
Learn how to build a sample Windmill App using Snowflake OAuth
Configure Snowflake OAuth
How to configure a Snowflake OAuth connection
To integrate Snowflake with Windmill, you can either create and OAuth connection or 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.