Skip to main content
Version: 3.0.0-LTS

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.

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.

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.