Icon

01a_​Snowflake_​ELT

Preparing and Exploring Customer Data with KNIME and Snowflake (ELT)
Preparing and Exploring Customer Data with KNIME and Snowflake (ELT)This workflow is an example of how to read different data files in KNIME and upload it to Snowflake. Once uploaded the data is transformed and analysed within Snowflake and the resultis 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. 2. Loading.The extracted data is uploaded into two new tables inSnowflake. 3. Transformation. Transformation are done using theprocessing power of Snowflake. 1. Extraction.Extract data from Exceland CSV files. Change connectioninformation toyour Snowflake accountCreate calls tableCreate contract tableUploaddataInner Join2 tables based on customer PhoneUploaddataConvert churn to nominalAggregate byarea codeand churnRead aggregateddata into KNIME tableShow aggregationresultCalls dataContract dataSnowflake Connector DB Table Creator DB Table Creator DB Loader DB Joiner DB Loader DB Numeric-Binner DB GroupBy DB Reader Bar Chart Excel Reader CSV Reader Preparing and Exploring Customer Data with KNIME and Snowflake (ELT)This workflow is an example of how to read different data files in KNIME and upload it to Snowflake. Once uploaded the data is transformed and analysed within Snowflake and the resultis 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. 2. Loading.The extracted data is uploaded into two new tables inSnowflake. 3. Transformation. Transformation are done using theprocessing power of Snowflake. 1. Extraction.Extract data from Exceland CSV files. Change connectioninformation toyour Snowflake accountCreate calls tableCreate contract tableUploaddataInner Join2 tables based on customer PhoneUploaddataConvert churn to nominalAggregate byarea codeand churnRead aggregateddata into KNIME tableShow aggregationresultCalls dataContract dataSnowflake Connector DB Table Creator DB Table Creator DB Loader DB Joiner DB Loader DB Numeric-Binner DB GroupBy DB Reader Bar Chart Excel Reader CSV Reader

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-04-24
Created with KNIME version: v4.5.2
Tags: SnowflakeELTCustomer 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!