Tableau TDE

There is a wide range of options for sending data to the Tableau ecosystem. This writer creates Tableau Data Extract (TDE) files and optionally uploads them to a destination (Tableau Server, Dropbox, Google Drive). As such it is more suitable to be used together with Tableau Desktop or Tableau Server. An alternative approach is to send data using the Snowflake writer through a Keboola provisioned database. That is more suitable to be used together with Tableau Online and also for larger data sets. Both approaches are interchangeable though.

Our Getting Started tutorial will guide you through the process of writing data from KBC to Tableau. You can also watch our Tableau Integration Demo on YouTube.

Create New Configuration

Find the Tableau writer in the list of writers and create a new configuration. Name it.

Screenshot - Create configuration

Configure Tables

Create a new table configuration by clicking the New Table button. Select a table from Storage.

Screenshot - Select Table

When you start configuring a table, it is possible to set all columns to the prevailing data type, e.g. string and then configure only the differing columns.

Screenshot - Table Configuration Start

For each column you may select one of the data types supported by TDE (string, boolean, number, decimal, date, datetime) or IGNORE, which means that the column will not be part od the TDE file. When configuring the data types, use the Preview icon to peek at the data. For date and datetime columns, you also have to specify the format in which dates are present in the table.

Screenshot - Table Configuration Columns

As optional last steps in table configuration, you can configure the name of the TDE file (useful for uploading to Dropbox or Google Drive) and Table data filter. The table data filter allows you to set a simple file for one column or take advantage of Incremental processing by writing only recently modified data.

Screenshot - Table Configuration Additional Settings

When done with configuring the table, don’t forget to Save the settings.

Downloading TDE File

You can configure as many tables as you want for the writer. Each table produces a separate TDE file, however. To download the TDE file, you have to Run the entire writer or a single table. Then the TDE file name will turn into a link through which you can download the TDE file to your computer.

Screenshot - TDE Download

Uploading TDE File

Apart from downloading the TDE files to your computer, you can also upload them to Tableau Server, Google Drive, or Dropbox. Start the upload configuration by clicking on the Upload Setup link:

Screenshot - Upload Setup

Then select the destination service. You can change the destination later, but only one destination can be used for one writer configuration.

Screenshot - Upload Destination

For Dropbox and Google Drive configurations click the Authorize button to sign-in into the respective service.

Screenshot - Google Drive / Dropbox Authorization

For Google Drive, you may also select the destination folder. For Dropbox, the destination folder is always Apps\Keboola Connection Writer V2\. For writing to Tableau Server, you need to enter the credentials:

Screenshot - Tableau Server Authorization

To activate the table upload, click the Enable instant upload link. Only when Instant Upload is enabled, the TDE files will be written to the selected destination.

Screenshot - Authorized