Icon

Snowflake_​KNIME_​Workflow_​Day5Analytics_​PUBLIC

Snowflake_KNIME_Connectors

This workflow is designed to allow business users to leverage the power of Snowflake from directly within KNIME, with no code. All data is supplied internal to the workflow, and the Snowflake components present user friendly front ends to use Snowflake.

The major components expire on 05/15/2021 - please reach out to Day5 Analytics to learn more.

1. Input credentials and create processing warehouse (1 time) COFFEE_WH 2. Create Database COFFEE_DB 3. Load Sample Data Snowflake-KNIME ConnectorsDay5 Analytics Inc (www.day5analytics.com)This workflow allows a user to quickly test the Snowflake-KNIME connectors with minimal setup time.1. Sign up for a Snowflake account with $400 of free credits here: http://d5a.tinyc.co/Day5_Snowflake_Trial2. Download and install KNIME drivers3. Test out the workflows below! (remember to dry run unconfigured workflows to ensure the dropdowns work!) Transform data - Create VIEW Table Load VIEW Table to Snowflake Read Data from SnowflakeIMPORT INTO KNIME Combine Local Data with Database Data - Transform and Analyze Load to Snowflake/BI Read Data from SnowflakePROCESS IN DATABASE coffee_dbcoffee_whinput credentialstransactionsin_db_processing tableload transactionsto TRANSACTIONS tablein PUBLIC schemaload productsto PRODUCTS tablein PUBLIC SCHEMAload targetsto TARGETS table in PUBLIC SCHEMAJoin Product dataSum revenue and quanitity by storeand product groupJoin Targets dataRead manually recordedcoffee wasteSum waste quantityby productJoin product dataConvert Long to IntJoin product dataTop: Monthly All StoresBottom: Weekly Store 3Combine tablesCalculate Beveragewaste proportionForecast waste unitsand lost revenueExtract wasteproportionvalueRename columnsRename ColumnsCalculate weeklywaste at Store 3renamechange to doublerun this firstproductstargetstransactionsproductstargetstransactionsproductsknime_processing tableinput credentials SNFLK_CREATE_DATABASE SNFLK_CREATE_WAREHOUSE SNFLK_INPUT_CREDENTIALS SNFLK_LOAD_NEW_TABLE SNFLK_LOAD_NEW_TABLE_DB CSV Reader CSV Reader CSV Reader DB Joiner DB GroupBy DB Joiner CSV Reader GroupBy Joiner (Labs) Math Formula Joiner (Labs) Calculate WeeklyBeverage Quantity Column Appender Math Formula Math Formula(Multi Column) Table Rowto Variable Column Rename DB Column Rename GroupBy Column Rename DB SQL Executor SNFLK_LOAD_NEW_TABLE SNFLK_LOAD_NEW_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_LOAD_NEW_TABLE SNFLK_INPUT_CREDENTIALS 1. Input credentials and create processing warehouse (1 time) COFFEE_WH 2. Create Database COFFEE_DB 3. Load Sample Data Snowflake-KNIME ConnectorsDay5 Analytics Inc (www.day5analytics.com)This workflow allows a user to quickly test the Snowflake-KNIME connectors with minimal setup time.1. Sign up for a Snowflake account with $400 of free credits here: http://d5a.tinyc.co/Day5_Snowflake_Trial2. Download and install KNIME drivers3. Test out the workflows below! (remember to dry run unconfigured workflows to ensure the dropdowns work!) Transform data - Create VIEW Table Load VIEW Table to Snowflake Read Data from SnowflakeIMPORT INTO KNIME Combine Local Data with Database Data - Transform and Analyze Load to Snowflake/BI Read Data from SnowflakePROCESS IN DATABASE coffee_dbcoffee_whinput credentialstransactionsin_db_processing tableload transactionsto TRANSACTIONS tablein PUBLIC schemaload productsto PRODUCTS tablein PUBLIC SCHEMAload targetsto TARGETS table in PUBLIC SCHEMAJoin Product dataSum revenue and quanitity by storeand product groupJoin Targets dataRead manually recordedcoffee wasteSum waste quantityby productJoin product dataConvert Long to IntJoin product dataTop: Monthly All StoresBottom: Weekly Store 3Combine tablesCalculate Beveragewaste proportionForecast waste unitsand lost revenueExtract wasteproportionvalueRename columnsRename ColumnsCalculate weeklywaste at Store 3renamechange to doublerun this firstproductstargetstransactionsproductstargetstransactionsproductsknime_processing tableinput credentials SNFLK_CREATE_DATABASE SNFLK_CREATE_WAREHOUSE SNFLK_INPUT_CREDENTIALS SNFLK_LOAD_NEW_TABLE SNFLK_LOAD_NEW_TABLE_DB CSV Reader CSV Reader CSV Reader DB Joiner DB GroupBy DB Joiner CSV Reader GroupBy Joiner (Labs) Math Formula Joiner (Labs) Calculate WeeklyBeverage Quantity Column Appender Math Formula Math Formula(Multi Column) Table Rowto Variable Column Rename DB Column Rename GroupBy Column Rename DB SQL Executor SNFLK_LOAD_NEW_TABLE SNFLK_LOAD_NEW_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_READ_TABLE SNFLK_LOAD_NEW_TABLE SNFLK_INPUT_CREDENTIALS

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: Paras_D5A
Created at: 2021-04-13
On NodePit since: 2022-02-06
Last update: 2024-04-26
Created with KNIME version: v4.3.2
Tags: SnowflakeKNIMEDay5Day5 Analyticscreate warehousebulk load databaseData CloudData Marketplacewarehousedata lakedata engineeringdata applicationsdata science

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

Try NodePit Runner!