Skip to main content

Snowflake

ToolJet can connect to Snowflake databases to read and write data.

Connection​

To establish a connection with the Snowflake data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page from the ToolJet dashboard and choose Snowflake as the data source.

Basic Authentication​

Authenticates to Snowflake using a username and password to establish a direct connection with the specified account, role, and warehouse.

ToolJet - Snowflake connection
info

Please make sure the Host/IP of the database is accessible from your VPC if you have self-hosted ToolJet. If you are using ToolJet cloud, please whitelist our IP.

You can find snowflake docs on network policies here.

ToolJet requires the following to connect to Snowflake database.

  • Account
  • Username
  • Password
info

You can also configure for additional optional parameters.

You can enable Authentication required for all users in the configuration to enforce user-level authentication. When enabled, users are redirected to the OAuth 2.0 consent screen the first time a query from this data source is executed within an application, ensuring secure, user-specific authorization. ToolJet supports OAuth 2.0 authentication using both Custom App and ToolJet App configurations, allowing flexible integration based on your OAuth provider setup.

Note: After completing the OAuth flow, the query must be triggered again to load the data.

OAuth2.0 - Custom App​

Uses credentials from your own OAuth application to authenticate and authorize access via a custom OAuth provider configuration.

ToolJet - Snowflake connection

OAuth2.0 - ToolJet App​

Uses ToolJet’s preconfigured OAuth application to simplify authentication without requiring you to create and manage your own OAuth app.

ToolJet - Snowflake connection

Querying Snowflake​

  1. Click on + Add button of the query manager at the bottom panel of the editor.
  2. Select the Snowflake datasource added in previous step.
  3. Select the SQL Mode form the dropdown and enter the query.
  4. Click on the Preview button to preview the output or Click on the Run button to trigger the query.
ToolJet - Snowflake query 
select * from "SNOWFLAKE_SAMPLE_DATA"."WEATHER"."DAILY_14_TOTAL" limit 10;
tip

Query results can be transformed using transformations. Read our transformations documentation to learn more.