Skip to main content
Version: 24.3.x

Tableau

Connect Tableau to Dremio to derive powerful insights from your data and create real-time dashboards.

You can connect from your Tableau application to Dremio in either of two ways:

  • Configure a reusable connection in Tableau Desktop, Tableau Server, or Tableau Cloud to a project in Dremio
  • Connect to a dataset by opening .tds file that you downloaded from Dremio

Supported Versions​

ProductSupported Versions
Tableau Desktop2020.4 and later
Tableau Server2020.4 and later
Tableau Cloud2021.3 and later
note

It is not recommended to use Tableau Desktop 2021.3.4, due to a known issue in that version. For information about the known issue, see this article in Tableau's Knowledge Base.

Supported Authentication Methods​

You can authenticate to Dremio through OAuth 2.0 for single sign-on (SSO) authentication. Alternatively, you can authenticate with a username and password, or with a personal access token that you have obtained from Dremio. If you want to authenticate your connection to Dremio by using a personal access token, see Personal Access Tokens.

If you want to authenticate through OAuth 2.0 for SSO authentication, follow these steps to enable SSO.

If you want to connect securely from Tableau Desktop on macOS to Dremio, follow these steps to enable SSL.

Enabling Single Sign-On (SSO) Authentication to Dremio from Tableau​

You can configure Dremio to use SSO authentication when users connect to Dremio from Tableau Server or from Tableau Desktop. Users of Tableau Desktop will use SSO authentication whether connecting directly to Dremio or connecting through a .tds file downloaded from Dremio.

note

Using OAuth 2.0 for SSO authentication is supported by Tableau Server 2021.2 and later, and by Tableau Desktop 2022.3 and later.

Before enabling SSO authentication, configure your Dremio cluster for SSO authentication.

To enable SSO authentication to Dremio from Tableau:

  1. In Dremio, click the Settings icon and select the BI Applications page.

  2. On the BI Applications page, click Tableau.

  3. Ensure that Enable single sign-on for Tableau is toggled on.

Enabling SSL for macOS​

If you've enabled SSL/TLS for JDBC connections for your Dremio server, and you are running Tableau Desktop on macOS, you must perform additional steps to fully enable secure communications.

  1. Obtain the certificate from your Dremio server.

  2. Install the certificate in the cacerts truststore, which comes with your Java 8 runtime. The location of the truststore is typically $JAVA_HOME/jre/lib/security/cacert/. To install the .der certificate, perform a command like the following:

    Install .der certificate 
    sudo keytool -importcert -alias dremio -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass changeit -file /path/to/dremioServerCert.der

  3. Verify that the certificate has been added.

    Verify certificate was added 
    keytool -keystore cacerts -storepass changeit -list | grep -A1 dremio
    dremio, Dec 16, 2019, trustedCertEntry,Certificate fingerprint (SHA1): 2B:2B:F6:D4:79:64:33:59:AB:43:3E:D9:17:C9:FD:A7:5E:C1:6D:42

Once complete, you must ensure that the Require SSL option is selected when adding your Dremio server to Tableau Desktop.

Tableau Desktop​

If you are using Tableau Desktop 2021.2 or later, the recommended method of connecting to Dremio is by using the native Dremio connector. Alternatively, you can connect by using a Dremio connector that you install yourself.

If you are using Tableau Desktop 2021.1 or earlier, you must connect to Dremio by using a Dremio connector that you install yourself.

note

If you want to use SSO authentication when connecting to Dremio, you must connect by using a Dremio connector that you install yourself.

Before attempting to connect from Tableau Desktop to Dremio, ensure that Java 8 or later is installed on your system.

Connecting with Tableau Desktop's Native Connector for Dremio​

Tableau Desktop 2021.2 and later includes a connector that you can use to connect to Dremio. However, the connector requires the Dremio JDBC driver to be on your system.

Prerequisites​

  • Download the Dremio JDBC driver and copy it to the Tableau Desktop's Drivers folder:

    • macOS
      In a Terminal window, run the following command to download the driver to ~/Library/Tableau/Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using Finder.

      Download driver for macOS 
      curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o ~/Library/Tableau/Drivers/dremio-jdbc-driver-LATEST.jar

    • Windows
      In a command-line window, run the following command as an administrator to download the driver to C:\Program Files\Tableau\Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using File Explorer.

      Download driver for Windows 
      curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o C:\PROGRA~1\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar

  • If you want to add JDBC parameters to the JDBC URL that Tableau generates for connections to Dremio, parameters other than those Tableau sets through the Dremio connection dialog, see Use a PROPERTIES file to customize a JDBC connection in the Tableau documentation.

Steps for Connecting​

  1. Open Tableau Desktop. If you already have Tableau Desktop open, restart the application.

  2. Under the To a Server section in the Connect panel, click More.

  3. Select Dremio. The Dremio connection dialog opens.

  4. In the Server field, specify the Dremio DNS configured on your system.

  5. In the Port field, specify the port, if it differs from the default port, which is 31010.

  6. In the Username and Password fields, specify your Dremio credentials:

    • If you want to authenticate with your Dremio username and password, specify them in these fields.

    • If you have a personal access token, specify your username and then paste the token into the Password field.

  7. If your Dremio cluster is configured for secure connections, select the Require SSL option.

  8. (Optional) In the Advanced tab, specify the engine, queue, and tag. For information about how these values are used, see Workload Management.

  9. Click Sign In.

Connecting After Manually Installing the Connector for Dremio​

You can use this method of connecting with any supported version of Tableau Desktop.

note

If you want to use single sign-on authentication (SSO) when connecting to Dremio, ensure that SSO is enabled.

Prerequisites​

  1. If you are using Tableau Desktop 2021.1 or earlier, follow these steps:

    a. Download the dremio.taco file from the Tableau Extension Gallery.

    b. Move the dremio.taco file to Tableau Desktop's Connectors folder:

    • macOS
      In a Terminal window, run the following command:

      Move dremio.taco file for macOS 
      cp <download-location>/dremio.taco ~/Documents/My\ Tableau\ Repository/Connectors/

    • Windows
      In a command-line window, run the following command:

      Move dremio.taco file for Windows 
      copy C:\<download-location>\dremio.taco C:\Users\[user]\Documents\My Tableau Repository\Connectors

  2. If you are using Tableau Desktop 2021.2 or later, follow these steps:

    a. Download the dremio.taco file.

    b. Move the dremio.taco file:

    • macOS
      In a Terminal window, run the following command to copy the dremio.taco file to Tableau Desktop's Connectors folder. Create the Connectors folder if it doesn't already exist.

      Copy dremo.taco file for macOS 
      cp <download-location>/dremio.taco ~/Library/Tableau/Connectors/

    • Windows
      In a command-line window, run the following command to copy the dremio.taco file to Tableau Desktop's Connectors folder. Create the Connectors folder if it doesn't already exist.

      Copy dremio.taco file for Windows 
      copy C:\<download-location>\dremio.taco C:\Program Files\Tableau\Connectors

  3. Download the Dremio JDBC driver and copy it to Tableau Desktop's Drivers folder:

    • macOS
      In a Terminal window, run the following command to download the driver to ~/Libary/Tableau/Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using Finder.

      Download driver for macOS 
      curl https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l ~/Library/Tableau/Drivers/dremio-jdbc-driver-LATEST.jar

    • Windows
      In a command-line window, run the following command to download the driver to C:\Program Files\Tableau\Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using File Explorer.

      Download driver for Windows 
      curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l C:\PROGRA~1\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar

  4. If you want to add JDBC parameters to the JDBC URL that Tableau generates for connections to Dremio, parameters other than those Tableau sets through the Dremio connection dialog, see Use a PROPERTIES file to customize a JDBC connection in the Tableau documentation.

Steps for Connecting​

  1. Open Tableau Desktop. If you already have Tableau Desktop open, restart the application.

  2. Under the To a Server section in the Connect panel, click More.

  3. Select Dremio. The Dremio connection dialog opens.

  4. In the Server field, specify the hostname or IP address for Dremio.

  5. In the Port field, specify the port, if it differs from the default port, which is 31010.

  6. In the Authentication field, select either OAuth 2.0 or Username and Password.

  7. If you selected OAuth 2.0 in the Authentication field, and your Dremio cluster is configured for single sign-on authentication, specify one of these URLs in the Dremio Authentication Server field, replacing <dremio-host> with the hostname or IP address for your Dremio coordinator node:

    • If your Dremio cluster does not use SSL: http://<dremio-host>:9047
    • If your Dremio cluster does use SSL: https://<dremio-host>:9047

  8. If you selected Username and Password in the Authentication field, specify your Dremio credentials:

    • If you want to authenticate with your Dremio username and password, specify them in these fields.

    • If you have a personal access token, specify your username and then paste the token into the Password field.

  9. If your Dremio cluster is configured for secure connections, select the Require SSL option.

  10. (Optional) In the Advanced tab, specify the engine, queue, and tag. For information about how these values are used, see Workload Management.

  11. Click Sign In.

  12. If you chose to use single sign-on authentication, follow these steps:

    a. Sign into your identity provider. You are taken to the sign-in screen only the first time that you log into Dremio during a session in Tableau Desktop.

    b. Click Accept in the Authorize App dialog. This dialog appears only the first time that you authenticate from Tableau Desktop through your identity provider.

Creating a Live Connection to a Dataset from Dremio​

You can generate a Tableau Datasource (.tds) file that represents a "live connection" to a dataset that is in Dremio. No actual data is stored in this file.

If you want to use single sign-on authentication when connecting to Dremio through the .tds file, ensure that you download the file only after single sign-on authentication is enabled and configured for your Dremio cluster.

  1. On the Datasets page in Dremio, find the dataset you want to work with and click it to open it in the SQL editor.
  2. Above the top-right corner of the editor, click the button that displays the Tableau logo. Dremio downloads a .tds file to your system.
  3. Open the .tds.
  4. Provide your credentials:

    • If you are not using single sign-on authentication, provide your Dremio credentials.

    • If you are using single sign-on authentication, follow these steps:

      1. Sign into your identity provider. You are taken to the sign-in screen only the first time that you log into Dremio during a session in Tableau.
      2. Click Accept in the Authorize App dialog. This dialog appears only the first time that you authenticate from Tableau through your identity provider.

Exporting a Dremio Dataset with SSL​

If you have SSL enabled on Dremio, and you want to export a .tds file to use in a Tableau application for quickly connecting to a dataset, you can do so by add the support key export.tableau.extra-native-connection-properties and set the value to SSL=true. This property allows you to set the JDBC connection string when exporting a .tds file. The default is an empty string. This is the only property currently supported for export.tableau.extra-native-connection-properties, and true is the only supported value.

To know how to set the export.tableau.extra-native-connection-properties support key, see Support Keys.

Changing the Hostname​

You can use the export.bi.hostname support key to change the default hostname of the SQL endpoint for generating TDS files. The export.bi.hostname property is available from Dremio version 13.0.0.

To know how to set the export.bi.hostname support key, see Support Keys.

Example: SSL setting​

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

Example SSL settings 
services.coordinator.client-endpoint.ssl.enabled: true
services.coordinator.client-endpoint.ssl.auto-certificate.enabled: true

Example: export.tableau.extra-native-connection-properties value​

Example SSL property value 
SSL=true

Tableau Server​

If you are using Tableau Server 2021.2 or later, the recommended method of connecting to Dremio is by using the native Dremio connector. Alternatively, you can connect by using a Dremio connector that you install yourself.

If you are using Tableau Server 2021.1 or earlier, you must connect to Dremio by using a Dremio connector that you install yourself.

Prerequisite​

If you are a Tableau Server admin and you want users to authenticate from Tableau Server to Dremio by means of OAuth 2.0 and single sign-on (SSO), you must follow these steps: ‎‎

  1. To configure OAuth for Tableau Server, run the following command in the Tableau Services Manager (TSM) command line. The only variable that you need to set the value for is <tableau-server-domain-name-or-ip>, which is the domain name or IP of your Tableau Server deployment:

    Configure OAuth for Tableau Server 
    tsm configuration set -k oauth.config.clients -v "[{\"oauth.config.id\":\"dremio\", \"oauth.config.client_id\":\"https\:\/\/connectors.dremio.app\/tableau\", \"oauth.config.client_secret\":\"test-client-secret\", \"oauth.config.redirect_uri\":\"https://<tableau-server-domain-name-or-ip>/auth/add_oauth_token\"}]" --force-keys

  2. To apply the changes to Tableau Server, run the command tsm pending-changes apply.

  3. In Dremio, click the Settings icon and select the BI Applications page.

  4. On the BI Applications page, click Tableau.

  5. Ensure that Enable single sign-on for Tableau is toggled on, if it isn't already.

  6. In the Redirect URIs field, paste in the redirect URI for your Tableau Server. If you have set up more than one Tableau Server, you can add multiple URIs, separating them with commas. Each URI uses this format, where <tableau-server> is the hostname or IP address of Tableau Server:

    Redirect URI for Tableau Server 
    https://<tableau-server>/auth/add_oauth_token

Connecting with Tableau Server's Native Connector for Dremio​

Tableau Server 2021.2 and later includes a connector that you can use to connect to Dremio. However, the connector requires the Dremio JDBC driver to be on your system.

Prerequisites​

  1. Download the Dremio JDBC driver and copy it to Tableau Desktop's Drivers folder:

    • Windows
      In the command line, run the following command to download the driver to C:\Program Files\Tableau\Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using File Explorer.

      Download driver for Windows 
      curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l C:\Progra~1\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar

    • Linux
      Download the driver from the download site and move it by using this command:

      Download driver for Linux 
      mv <download-location>/dremio-jdbc-driver-LATEST.jar /opt/tableau/tableau_driver/jdbc/dremio-jdbc-driver-LATEST.jar

  2. If you want to add JDBC parameters to the JDBC URL that Tableau generates for connections to Dremio, parameters other than those Tableau sets through the Dremio connection dialog, see Use a PROPERTIES file to customize a JDBC connection in the Tableau documentation.

Steps for Connecting​

  1. In a web browser, navigate to your Tableau Server site.

  2. In your workbook, click Add a Data Source. Alternatively, you can publish an existing data source to Tableau Server.

  3. In the Connect to Data dialog, select Dremio under the Connectors tab.

  4. In the Dremio connection dialog, for Server, enter the Dremio DNS configured on your system.

  5. For Port, enter the port if it differs from the default 31010 port.

  6. In the Username and Password fields, specify your Dremio credentials:

    • If you want to authenticate with your Dremio username and password, specify them in these fields.

    • If you have a personal access token, specify your username and then paste the token into the Password field.

  7. If your Dremio cluster is configured for secure connections, select the Require SSL option.

  8. (Optional) In the Advanced tab, you can specify the Engine, Queue, and Tag.

  9. Click Sign In.

Connecting After Manually Installing the Connector for Dremio​

You can use this method of connecting with any supported version of Tableau Server.

note

If you want to use single sign-on authentication (SSO) when connecting to Dremio, ensure that SSO is enabled.

Prerequisites​

  1. If you are using Tableau Server 2021.1 or earlier, follow these steps:
    a. Download the dremio.taco file from the Tableau Extension Gallery.

    b. Move the dremio.taco file to Tableau Server's Connectors folder:

    • Windows In a command-line window, run the following command:

      Move dremio.taco file for Windows 
      copy C:\<download-location>\dremio.taco C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors

    • Linux Run the following command:

      Move dremio.taco file for Linux 
      mv <download-location>/dremio.taco /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors/dremio.taco

  2. If you are using Tableau Server 2021.2 or later, follow these steps:

    a. Download the dremio.taco file.

    b. Move the dremio.taco file:

    • Windows In a command-line window, run the following command:

      Move dremio.taco file for Windows 
      copy C:\<download-location>\dremio.taco C:\Progra~1\Tableau\Connectors

    • On Linux: Run the following command:

      Move dremio.taco file for Linux 
      mv <download-location>/dremio.taco /opt/tableau/connectors/dremio.taco

  3. Download the Dremio JDBC driver and copy it to Tableau Desktop's Drivers folder:

    • Windows
      In the command line, run the following command to download the driver to C:\Program Files\Tableau\Drivers. As an alternative, you can download the driver from the download site and move it to the folder by using File Explorer.

      Download driver for Windows 
      curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l C:\Progra~1\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar

    • Linux
      Download the driver from the download site and move it by using this command:

      Download driver for Linux 
      mv <download-location>/dremio-jdbc-driver-LATEST.jar /opt/tableau/tableau_driver/jdbc/dremio-jdbc-driver-LATEST.jar

  4. If you want to add JDBC parameters to the JDBC URL that Tableau generates for connections to Dremio, parameters other than those Tableau sets through the Dremio connection dialog, see Use a PROPERTIES file to customize a JDBC connection in the Tableau documentation.

Steps for Connecting​

  1. In a web browser, navigate to your Tableau Server site.

  2. In your workbook, click Add a Data Source. Alternatively, you can publish an existing data source to Tableau Server.

  3. In the Connect to Data dialog, select Dremio under the Connectors tab.

  4. In the Dremio connection dialog, for Server, enter the Dremio DNS configured on your system.

  5. For Port, enter the port if it differs from the default 31010 port.

  6. In the Authentication field, select either OAuth 2.0 or Username and Password.

  7. If you selected OAuth 2.0 in the Authentication field, and your Dremio cluster is configured for single sign-on authentication, specify one of these URLs in the Dremio Authentication Server field, replacing <dremio-host> with the hostname or IP address for your Dremio coordinator node:

    • If your Dremio cluster does not use SSL: http://<dremio-host>:9047
    • If your Dremio cluster does use SSL: https://<dremio-host>:9047

  8. If you selected Username and Password in the Authentication field, specify your Dremio credentials:

    • If you want to authenticate with your Dremio username and password, specify them in these fields.

    • If you have a personal access token, specify your username and then paste the token into the Password field.

  9. If your Dremio cluster is configured for secure connections, select the Require SSL option.

  10. (Optional) In the Advanced tab, you can specify the Engine, Queue, and Tag.

  11. Click Sign In.

  12. If you chose to use single sign-on authentication, follow these steps:

    a. Sign into your identity provider. You are taken to the sign-in screen only the first time that you log into Dremio during a session in Tableau Server.

    b. Click Accept in the Authorize App dialog. This dialog appears only the first time that you authenticate from Tableau Server through your identity provider.

Tableau Cloud​

Connecting to Dremio​

note

If you want to use single sign-on authentication (SSO) when connecting to Dremio, ensure that SSO is enabled.

  1. In a web browser, navigate to your Tableau Cloud site.

  2. In your workbook, click Add a Data Source. Alternatively, you can publish an existing data source to Tableau Cloud.

  3. In the Connect to Data dialog, select Dremio under the Connectors tab.

  4. In the Server field in the Dremio connection dialog, specify the hostname or IP address of your Dremio coordinator node.

  5. In the Port field, enter the port if it differs from the default 31010 port.

  6. In the Authentication field, select either OAuth 2.0 or Username and Password.

  7. If you selected OAuth 2.0 in the Authentication field, and your Dremio cluster is configured for single sign-on authentication, specify one of these URLs in the Dremio Authentication Server field, replacing <dremio-host> with the hostname or IP address for your Dremio coordinator node:

    • If your Dremio cluster does not use SSL: http://<dremio-host>:9047
    • If your Dremio cluster does use SSL: https://<dremio-host>:9047

  8. If you selected Username and Password in the Authentication field, specify your Dremio credentials:

    • If you want to authenticate with your Dremio username and password, specify them in these fields.

    • If you have a personal access token, specify your username and then paste the token into the Password field.

  9. If your Dremio cluster is configured for secure connections, select the Require SSL option.

  10. (Optional) In the Advanced tab, you can specify the Engine, Queue, and Tag.

  11. Click Sign In.

  12. If you chose to use single sign-on authentication, follow these steps:

    a. Sign into your identity provider. You are taken to the sign-in screen only the first time that you log into Dremio during a session in Tableau Cloud.

    b. Click Accept in the Authorize App dialog. This dialog appears only the first time that you authenticate from Tableau Cloud through your identity provider.

Troubleshooting Tableau Client Connections​

Dremio users may need to perform one of the following workarounds if they are using the specified version of Tableau to access a Dremio deployment.

Tableau 2019.4​

Start Tableau from the command line with the -DDisableVerifyConnectorPluginSignature=true option. For example:

Start Tableau from command line 
cd /Applications/Tableau Desktop 2019.4.app/Contents/MacOS
./Tableau -DDisableVerifyConnectorPluginSignature=true

Dremio JDBC 14.0 or Earlier​

If you are running Java v9+, set the following environment variable on the machine running Tableau:

Set environment variable 
JAVA_TOOL_OPTIONS=-Dcdjd.io.netty.tryReflectionSetAccessible=true