Icon

Basic Snowflake Workflow

Getting Started with Snowflake Workflows

This example 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 sample data, which is shared with your Snowflake account.

Visually create a Snowflake query with KNIME Use custom SQL for query execution in Snowflake Getting Started with Snowflake WorkflowsThis example 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. Theworkflow connects to the CUSTOMERS table in the TPCH sample data, which is shared with your Snowflake account. Select filtering criteriaPick from visual schema listing Send query to Snowflake and return values to KNIMESend query to Snowflakeand return values to KNIMEChange connection information to your Snowflake account DB Row Filter DB Table Selector DB Query Reader DB Reader Snowflake Connector Visually create a Snowflake query with KNIME Use custom SQL for query execution in Snowflake Getting Started with Snowflake WorkflowsThis example 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. Theworkflow connects to the CUSTOMERS table in the TPCH sample data, which is shared with your Snowflake account. Select filtering criteriaPick from visual schema listing Send query to Snowflake and return values to KNIMESend query to Snowflakeand return values to KNIMEChange connection information to your Snowflake accountDB Row Filter DB Table Selector DB Query Reader DB Reader Snowflake Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: srauner
Created at: 2023-09-14
On NodePit since: 2023-09-18
Last update: 2024-05-02
Created with KNIME version: v4.7.7
Tags: SnowflakeDB

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!