Icon

01b_​Snowflake_​ETL

Preparing and Exploring Customer Data with KNIME and Snowflake (ETL)
Preparing and Exploring Customer Data with KNIME and Snowflake (ETL)This workflow is an example of how to read and transform different data files within KNIME prior loading the manipluated data into Snowflake. Once uploaded the data isanalysed in Snowflake and the result is visualized in KNIME.Example data provided from kaggle: https://www.kaggle.com/becksddf/churn-in-telecoms-dataset 4. Exploring. Visualize the aggregation result in KNIME. 1. Extraction.Extract data from Exceland CSV files. 2. Transformation. Transformation are done directly inKNIME. 3. Loading.The manipulated data is uploaded into a newtable in Snowflake. Create tablecalls_contractUploaddataAggregate byarea codeand churnRead aggregateddata into KNIME tableShow aggregationresultCalls dataContract dataInner Join2 tables based on customer PhoneConvert churn to nominal Change connectioninformation to your Snowflake accountDB Table Creator DB Loader DB GroupBy DB Reader Bar Chart Excel Reader CSV Reader Joiner Numeric Binner Snowflake Connector Preparing and Exploring Customer Data with KNIME and Snowflake (ETL)This workflow is an example of how to read and transform different data files within KNIME prior loading the manipluated data into Snowflake. Once uploaded the data isanalysed in Snowflake and the result is visualized in KNIME.Example data provided from kaggle: https://www.kaggle.com/becksddf/churn-in-telecoms-dataset 4. Exploring. Visualize the aggregation result in KNIME. 1. Extraction.Extract data from Exceland CSV files. 2. Transformation. Transformation are done directly inKNIME. 3. Loading.The manipulated data is uploaded into a newtable in Snowflake. Create tablecalls_contractUploaddataAggregate byarea codeand churnRead aggregateddata into KNIME tableShow aggregationresultCalls dataContract dataInner Join2 tables based on customer PhoneConvert churn to nominal Change connectioninformation to your Snowflake accountDB Table Creator DB Loader DB GroupBy DB Reader Bar Chart Excel Reader CSV Reader Joiner Numeric Binner 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: rosy
Created at: 2015-04-23
On NodePit since: 2022-04-06
Last update: 2024-05-01
Created with KNIME version: v4.5.2
Tags: SnowflakeETLCustomer IntelligenceCIChurnMarketing AnalyticsDBDatabase

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

Try NodePit Runner!