Tableau Desktop (Windows)


Dremio Tableau integration requires:



Copy the .tdc file at: C:\Program Files\Dremio Connector\Resources\DremioConnector.tdc into
C:\Users\<username>\Documents\My Tableau Repository\Datasources.


Copy the .tdc file at: C:\Program Files (x86)\Dremio Connector\Resources\DremioConnector.tdc into
C:\Users\<username>\Documents\My Tableau Repository\Datasources.

More information on managing .tdc files can be found on Tableau's website.

Creating a Live Connection to a Dataset from Dremio

To open a dataset in Tableau from within Dremio, you can use the Analyze button in the upper right-hand corner of a dataset view. Just follow these steps:

  1. In Dremio UI, go to a dataset you want to work with and click on the dataset.

  2. Select Tableau from the Analyze button's dropdown menu.

  3. Click on the file that you just downloaded and enter your Dremio credentials.

  4. Dataset is ready to be used in Tableau.

How does it work?

When you click the Analyze (Tableau) button, Dremio generates a Tableau Datasource (.tds) file that represents a "live connection" to your Dremio dataset. No actual data is stored in this file, and you can think of it as a shortcut to a Tableau session with a preconfigured view of your data.

Creating a Dremio Source in Tableau

  1. Open Tableau Desktop and select Other Databases (ODBC) as the connection type for a new connection:

  2. Select Dremio Connector from the DSN dropdown and press Connect.

Your Dremio datasets will now be accessible from within Tableau. Just hit enter in the text field of the next screen's Schema dropdown to see what's available to explore on your cluster.

Exporting a Dremio Dataset with SSL

If you have SSL enabled on Dremio and you want to export a Dremio dataset to Tableau TDS format, you can do so by setting the export.tableau.extra-odbc-connection-properties Support Key in Advanced Settings. This property allows you to set the ODBC connection string when exporting a Dremio dataset to Tableau TDS format. The default is an empty string.

[info] Availability

The export.tableau.extra-odbc-connection-properties property is available as of Dremio version 3.1.8.

To set the export.tableau.extra-odbc-connection-properties Support Key:

  1. In the Dremio UI, go to Admin.
  2. Select Cluster > Support.
  3. Add the export.tableau.extra-odbc-connection-properties Support Key and click Show.
  4. Provide your value for the support key.

Example: SSL setting

In the following example, SSL (for generating a self-signed certificate with an ODBC/JDBC Dremio configuration) is enabled in the dremio.conf file. See Using Wire Encryption for more information.

services.coordinator.client-endpoint.ssl.enabled: true true

Example: export.tableau.extra-odbc-connection-properties value


results matching ""

    No results matching ""