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 DB Table Creator and DB Loader nodes.

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.

External resources

• KNIME Database Documentation
• Will They Blend? Snowflake meets Tableau