Attaching two workflows that allow users to connect and orchestrate Snowflake from within KNIME - with no code!
Different connectors offer the following functionality:
- Logging in to Snowflake
- Creating warehouses (for compute)
- Creating databases (to store data)
note: Snowflake breaks compute from storage to enable simple scaling - Writing data to a new database table.
2 options for inputs - in-db, or KNIME table - Appending data to an existing database table
- Reading data from an existing database table.
2 options for outputs - in-db or KNIME table
Hope it helps! If anyone is interested in learning more please reach out to www.day5analytics.com. We will also be collecting feedback for KNIME as they look to build nodes for Snowflake shortly!
Snowflake_KNIME_Connectors_Day5Analytics_PUBLIC.knwf (1.2 MB)
Snowflake_KNIME_Workflow_Day5Analytics_PUBLIC.knwf (3.3 MB)
Alternatively: Snowflake-KNIME Workflows URL