Blogs / Snowflake / Writing Data to Snowflake Table from Tableau Prep

Writing Data to Snowflake Table from Tableau Prep

Sep 13, 2020

SHARE

With the latest release of Tableau 2020.3, writing prepared data to external databases has become possible using Tableau Prep, currently available for seven databases. In this blog, we will explore the steps to write the prepared data to a Snowflake table from Tableau Prep.

How to Write Data?

1. Choose the flow for which you would like to write the prepared data to an external table.

2. Click on the ‘Output’ You will see the highlighted pane where you can specify where and how to save the output.

Writing Data to Snowflake Table from Tableau Prep

Save output pane

3. Choose the ‘Database table’ from the list of options available in the dropdown.

Writing Data to Snowflake Table from Tableau Prep
Choose Database table

4. Under the ‘Settings’ tab, choose ‘Snowflake’ from the list of connections available.

Writing Data to Snowflake Table from Tableau Prep
Choose Snowflake

5. On choosing the option mentioned in the step above, a dialog box appears where you must provide the server details, choose an authentication type and provide credentials for the chosen connection.

Writing Data to Snowflake Table from Tableau Prep
Server details – Snowflake

6. Enter all the details required and click on ‘Sign In.’ This establishes a connection between Tableau Prep and the target Server.

7. Now, choose the warehouse, database, and schema under the ‘Table’ option where you would like to write the prepared data.

Writing Data to Snowflake Table from Tableau Prep
Choose Warehouse, Database, Schema

8. You can enter a table name to create a new table and add values or choose a table from the list so that the prepared data is appended to an existing table.

9. When you enter a table name, a ‘Create table’ query is generated, which should be chosen to create a new table.

Writing Data to Snowflake Table from Tableau Prep
Create new table

10. Under the ‘Write Options’, choose an option based on your requirement from the list of options available. The description of each option is also displayed for further reference.

Writing Data to Snowflake Table from Tableau Prep
Write Options

11. Once all the required information is provided, click on the ‘Run Flow’.

Writing Data to Snowflake Table from Tableau Prep

Once the flow has run successfully, the prepared data from the output chosen initially will be written successfully into a Snowflake table.

By writing data to databases, it is possible to use the data stored in an external table to analyze and create insights by leveraging the organization’s resources. Writing to external tables simplifies the complex process of loading data into databases for advanced users and analysts. You can also schedule the flows, which always helps keep the data updated when you have selected the ‘Add to existing table’ option. Incrementally loading data into database tables is made more accessible as this feature reduces the data movement and makes your Tableau Prep flows efficient.

To learn about other new features of the latest release of Tableau 2020.3, check out our blog here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This Blog!

Share this blog with your friends and colleagues!