How to Get Started with Snowflake

Visually create a Snowflake query with KNIME

Use custom SQL for query execution in Snowflake

How to Get Started with Snowflake

This workflow shows two ways to execute a Snowflake query within KNIME. For this workflow to work, you will need to configure the Snowflake Connector node to connect to your data warehouse. The workflow connects to the CUSTOMERS table in the TPCH_SF1 sample schema, which is shared with your Snowflake account.

📍Technical Note:

If you don't have a Snowflake account, you can sign up for a free 30-day trial account (when signing up, select Enterprise edition and choose any Snowflake cloud/region - preferably AWS or Azure).

Configure the Snowflake Connector node:

After signing up, navigate to your Snowflake Account details. There, you'll find key information to configure the node:

• Account identifier (input it in Full account name field)

• Login name (input it in Authentication > Username & password field). The password field is Snowflake's programmatic access token.

• Role (select Access role and type it there). If you're using a free trial account, make sure the role is ACCOUNTADMIN. Otherwise, input the role that is enabled for your account (your role should have write permissions).

• Stay in your Account details and navigate to the Config File tab. Select the warehouse you prefer (e.g., SNOWFLAKE_LEARNING_WH, if you're using a free trial account) and input the warehouse name in the Virtual warehouse field.

--> Knime Snowflake Extension Guide