Icon

11_​Snowflake_​meets_​Tableau

Snowflake meets Tableau

This workflow implements a DWH operation, configuring and launching a Snowflake in-cloud data warehouse instance. Sales orders are read from an Excel file, return orders supplied from our e-commerce platform's API in JSON format are filtered out, all the clean correct orders are uploaded to a Snowflake table, dynamically created by the Database Writer node.

Once uploaded, a subset of those are read into KNIME Analytics Platform, filtered using a Row Filter to only report on the data for the relveant organisational divisons and exported to Tableau's .Hyper file format for dashboard creation.

Prepare Data- Clean up order data in Excel File - Read returned orders from JSON structure- Remove returned orders from Excel data Launch SnowFlake InstanceBy using create or replace in the SQL command, even if it is re-run, no error isencountered. Upload joined data to Snowflake- Connect to Snowflake- Upload the dataset directly to a database table- Read the data and filter out the Technology division Send to Tableau This workflow demonstrates how to launch Snowflake in-cloud data warehouse instance and export the data to Tableau.For more information see the workflow metadata. Find it here: View -> Description. Round measuresFix incorrect time fieldRemove ID columnsJoin the two data setsFilter out returned ordersRemove the Returned column Write to Tableau Hyper fileFilter out the Technology divisionDrop any pre-existing tableCreate the table and load dataRead data from SnowflakeSnowflake ConnectorLoad Excel DataSnowflake ConnectorCreate warehouseCreate databaseRound Double String to Date&Time Column Filter JSON Path Ungroup ContainerInput (JSON) Joiner Row Filter Column Filter Tableau Writer(Hyper) Row Filter DB Table Remover DB Writer DB Query Reader DB Connector Excel Reader (XLS) DB Connector DB SQL Executor DB SQL Executor Prepare Data- Clean up order data in Excel File - Read returned orders from JSON structure- Remove returned orders from Excel data Launch SnowFlake InstanceBy using create or replace in the SQL command, even if it is re-run, no error isencountered. Upload joined data to Snowflake- Connect to Snowflake- Upload the dataset directly to a database table- Read the data and filter out the Technology division Send to Tableau This workflow demonstrates how to launch Snowflake in-cloud data warehouse instance and export the data to Tableau.For more information see the workflow metadata. Find it here: View -> Description. Round measuresFix incorrect time fieldRemove ID columnsJoin the two data setsFilter out returned ordersRemove the Returned column Write to Tableau Hyper fileFilter out the Technology divisionDrop any pre-existing tableCreate the table and load dataRead data from SnowflakeSnowflake ConnectorLoad Excel DataSnowflake ConnectorCreate warehouseCreate databaseRound Double String to Date&Time Column Filter JSON Path Ungroup ContainerInput (JSON) Joiner Row Filter Column Filter Tableau Writer(Hyper) Row Filter DB Table Remover DB Writer DB Query Reader DB Connector Excel Reader (XLS) DB Connector DB SQL Executor DB SQL Executor

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: craigcullum
Created at: 2017-04-01
On NodePit since: 2020-07-23
Last update: 2024-04-23
Created with KNIME version: v4.1.0
Tags: snowflakedata warehouseHyperTableauKNIME

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

Try NodePit Runner!