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.
3. Choose the ‘Database table’ from the list of options available in the dropdown.
4. Under the ‘Settings’ tab, choose ‘Snowflake’ from the list of connections available.
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.
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.
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.
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.
11. Once all the required information is provided, click on the ‘Run Flow’.
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.