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.
Workflow
Snowflake meets Tableau
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.1.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.1.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.1.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.1.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.1.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.1.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.