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.

This is a companion discussion topic for the original entry at
1 Like

Hi @craigcullum ,

i am getting error while connecting to snowflak
Execute failed: JDBC driver encountered communication error. Message: HTTP status=403.

this is my url

@knime does not give complete description of the error, it just show error message why?

i am looking forward to hearing from you soon.

many thanks,