Connect Tableau to Snowflake

Some organizations choose to store their visualization source data in Snowflake, and then connect to Snowflake from Tableau.

You may send an Apache Parquet, Apache Avro, CSV, or JSON file from Amperity to Snowflake, and then connect to that data from Tableau.

What is Snowflake?

Snowflake is an analytic data warehouse that is fast, easy to use, and flexible. Snowflake uses a SQL database engine that is designed for the cloud. Snowflake can provide tables as a data source to Amperity.

Add workflow

Amperity can be configured to send data directly to Snowflake. Tableau can be configured to connect to Snowflake, and use Amperity as a source for data visualizations.

Connect Tableau to Snowflake.

To connect Tableau to Snowflake

The steps required to configure Amperity to send data that is accessible to Tableau from a Snowflake data warehouse requires completion of a series of short workflows, some of which must be done outside of Amperity.

Step 1.

Configure Snowflake objects for the correct database, tables, roles, and users. (Refer to the Amazon S3 or Azure topic, as appropriate for your tenant.)

Note

Snowflake can be configured to run in Amazon AWS or Azure. When using the Amazon Data Warehouse you will use the same cloud platform as your Amperity tenant. When using your own instance of Snowflake, you should use the same Amazon S3 bucket or Azure Blob Storage container that is included with your tenant when configuring Snowflake for data sharing, but then connect Tableau directly to your own instance of Snowflake.

Step 2.

Send data to Snowflake from Amperity. (Refer to the Amazon S3 or Azure topic, as appropriate for your tenant.)

Step 3.

Connect Tableau to Snowflake , and then access the data sent from Amperity.

Note

The URL for the Snowflake data warehouse, the Snowflake username, the password, and the name of the Snowflake data warehouse are sent to the Tableau user within a SnapPass link. Request this information from your Amperity representative prior to attempting to connect Tableau to Snowflake.

Step 4.

Validate the workflow within Amperity and the data within Tableau.

Step 5.

Configure Amperity to automate this workflow for a regular (daily) refresh of data.