Skip to main content

Tableau

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

note

When using Tableau with Dremio, avoid using periods in space or dataset names. Due to differences in hierarchy support, periods in paths are treated as separators, resulting in errors when navigating or selecting spaces or datasets with periods in their names.

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

  • Configure a reusable connection in Tableau Desktop, Tableau Server, or Tableau Cloud.
  • Connect to a specific dataset by downloading the .tds file from Dremio and opening it in Tableau Desktop.

Supported Versions​

ProductSupported Versions
Tableau Desktop2022.1 and later
Tableau Server2022.1 and later
Tableau CloudLatest version deployed by Tableau

Supported Authentication Methods​

From Tableau, you can authenticate to Dremio with a username and password, or with a personal access token (PAT) that can be obtained from the Dremio console.

You can also configure single sign-on (SSO) through OAuth 2.0. For steps on how to configure SSO, see Enabling SSO to Dremio from Tableau.

Tableau Desktop​

Tableau Desktop includes a native connector that you can use to connect to Dremio.

Prerequisites for Using the Dremio JDBC Driver (Legacy)​

To connect to Dremio, you'll also need to install the Dremio JDBC driver. Download the Dremio JDBC driver and copy it to the Tableau Desktop's Drivers folder.

Download driver for macOS by running this command in a Terminal window 
curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o ~/Library/Tableau/Drivers/dremio-jdbc-driver-LATEST.jar
Download driver for Windows by running this command in a PowerShell window 
Invoke-WebRequest -Uri "https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar" -OutFile "C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar"

Prerequisites for Using the Arrow Flight SQL JDBC Driver​

The Tableau Desktop 2025.1+ connector for Dremio supports Arrow Flight SQL JDBC in place of the Dremio JDBC driver (Legacy). To change the driver, download the Arrow Flight SQL JDBC driver, copy it to Tableau Desktop's Drivers folder, and select the Use Arrow Flight SQL Driver (preview) option in the Advanced tab of the connection dialog.

Download driver for macOS by running this command in a Terminal window 
curl -L https://repo1.maven.org/maven2/org/apache/arrow/flight-sql-jdbc-driver/16.1.0/flight-sql-jdbc-driver-16.1.0.jar -o ~/Library/Tableau/Drivers/flight-sql-jdbc-driver-16.1.0.jar
Download driver for Windows by running this command in a PowerShell window 
Invoke-WebRequest -Uri "https://repo1.maven.org/maven2/org/apache/arrow/flight-sql-jdbc-driver/16.1.0/flight-sql-jdbc-driver-16.1.0.jar" -OutFile "C:\Program Files\Tableau\Drivers\flight-sql-jdbc-driver-16.1.0.jar"

Steps for Connecting​

To create a Dremio source in Tableau Desktop:

  1. Open Tableau Desktop. If you already had Tableau Desktop open, restart the application. Under the To a Server section in the Connect panel, click More.
  2. Select Dremio. The Dremio connection dialog opens.
  3. In the Product field, select Dremio Cloud.
  4. In the Region field, select the Dremio control plane in which your Dremio organization is located: US or Europe. For Tableau 2024.3 or before, in the Server field, select sql.dremio.cloud (US) or sql.eu.dremio.cloud (EU).
  5. In the Authentication field, select Personal Access Token or OAuth 2.0.
    • If you selected Personal Access Token, in the Password field, specify your PAT.
    • If you selected OAuth 2.0, specify one of these URLs in the Dremio Authentication Server field:
      • If your Dremio Cloud organization is on the US control plane: https://login.dremio.cloud
      • If your Dremio Cloud organization is on the EU control plane: https://login.eu.dremio.cloud
  6. (Optional) In the Project field, if your datasets are in a non-default project of your Dremio Cloud organization or you do not have access to the default project, paste the ID of the project that you want to connect to. To obtain the project ID, see Obtaining the ID of a project.
  7. (Optional for Tableau 2025.1+) If you are using the Arrow Flight SQL JDBC driver, in the Advanced tab, select the Use Arrow Flight SQL Driver (preview) option. Ensure that you have the Arrow Flight SQL JDBC driver downloaded.
  8. (Optional) In the Advanced tab, specify an Engine to run queries on.
  9. Click Sign In.

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, and you can think of it as a shortcut to a Tableau session with a preconfigured view of your data.

note
  • The .tds file download option must be enabled for users to have access to this feature. To enable this feature, see Enabling the .tds File Download in the Dremio console.
  • OAuth is the only supported authentication mechanism for .tds files.
  • For tables and views in a Dremio Arctic catalog, this functionality is only supported for those that are on the main branch.

To download a .tds file:

  1. On the Datasets page of your Dremio Cloud project, find the dataset you want to work with and open the Details panel for the dataset.
  2. Click the button that displays the Tableau logo. Dremio downloads a .tds file to your system.
  3. Open the .tds file.
  4. Authenticate to Dremio in the browser window that Tableau opens. The dataset will open in Tableau Desktop.

Tableau Server​

Tableau Server includes a native connector that you can use to connect to Dremio.

Prerequisites for Using the Dremio JDBC Driver (Legacy)​

To connect to Dremio, you'll need to install the Dremio JDBC driver. Download the Dremio JDBC driver and copy it to the Drivers folder.

Download driver for Windows by running this command in a PowerShell window 
Invoke-WebRequest -Uri "https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar" -OutFile "C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar"
Download driver for Linux by running this command in a command-line window 
curl -L https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o /opt/tableau/tableau_driver/jdbc/dremio-jdbc-driver-LATEST.jar

Prerequisites for Using the Arrow Flight SQL JDBC Driver​

The Tableau Server 2025.1+ connector for Dremio supports Arrow Flight SQL JDBC in place of the Dremio JDBC driver (Legacy). To change the driver, download the Arrow Flight SQL JDBC driver, copy it to the Drivers folder, and select the Use Arrow Flight SQL Driver (preview) option in the Advanced tab of the connection dialog.

Download driver for Windows by running this command in a PowerShell window 
Invoke-WebRequest -Uri "https://repo1.maven.org/maven2/org/apache/arrow/flight-sql-jdbc-driver/16.1.0/flight-sql-jdbc-driver-16.1.0.jar" -OutFile "C:\Program Files\Tableau\Drivers\flight-sql-jdbc-driver-16.1.0.jar"
Download driver for Linux by running this command in a command-line window 
curl -L https://repo1.maven.org/maven2/org/apache/arrow/flight-sql-jdbc-driver/16.1.0/flight-sql-jdbc-driver-16.1.0.jar -o /opt/tableau/tableau_driver/jdbc/flight-sql-jdbc-driver-16.1.0.jar

Steps for Connecting​

To create a Dremio source in Tableau Server:

  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 the Product field, select Dremio Cloud.
  5. In the Region field, select the Dremio control plane in which your Dremio organization is located: US or Europe. For Tableau 2024.3 or before, in the Server field, select sql.dremio.cloud (US) or sql.eu.dremio.cloud (EU).
  6. In the Authentication field, select Personal Access Token or OAuth 2.0.
    • If you selected Personal Access Token, in the Password field, specify your PAT.
    • If you selected OAuth 2.0, specify one of these URLs in the Dremio Authentication Server field:
      • If your Dremio Cloud organization is on the US control plane: https://login.dremio.cloud
      • If your Dremio Cloud organization is on the EU control plane: https://login.eu.dremio.cloud
  7. (Optional) In the Project field, if your datasets are in a non-default project of your Dremio Cloud organization or you do not have access to the default project, paste the ID of the project that you want to connect to. To obtain the project ID, see Obtaining the ID of a project.
  8. (Optional for Tableau 2025.1+) If you are using the Arrow Flight SQL JDBC driver, in the Advanced tab, select the Use Arrow Flight SQL Driver (preview) option. Ensure that you have the Arrow Flight SQL JDBC driver downloaded.
  9. (Optional) In the Advanced tab, specify an Engine to run queries on.
  10. Click Sign In.

Tableau Cloud​

Tableau Cloud includes a native connector that you can use to connect to Dremio.

note

The Tableau Cloud 2025.1 connector for Dremio has an option to use the Arrow Flight SQL JDBC driver in place of the Dremio JDBC driver to power the connection to Dremio. In the Advanced tab, select the Use Arrow Flight SQL Driver (preview) option.

To create a Dremio source in Tableau Cloud:

  1. In a web browser, navigate to your Tableau Cloud site.
  2. Click New > Published Data Source to create a reusable data source or Data > Add a Data Source from within a workbook. 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 Dremio connection dialog, for the Product field, select Dremio Cloud.
  5. In the Region field, select the Dremio control plane in which your Dremio organization is located: US or Europe.
  6. In the Authentication field, select Personal Access Token or OAuth 2.0.
    • If you selected Personal Access Token, in the Password field, specify your PAT.
    • If you selected OAuth 2.0, specify one of these URLs in the Dremio Authentication Server field:
      • If your Dremio Cloud organization is on the US control plane: https://login.dremio.cloud
      • If your Dremio Cloud organization is on the EU control plane: https://login.eu.dremio.cloud
  7. (Optional) In the Project field, if your datasets are in a non-default project of your Dremio Cloud organization or you do not have access to the default project, paste the ID of the project that you want to connect to. To obtain the project ID, see Obtaining the ID of a Project.
  8. (Optional for Tableau 2025.1+) If you are using the Arrow Flight SQL JDBC driver, in the Advanced tab, select the Use Arrow Flight SQL Driver (preview) option.
  9. (Optional) In the Advanced tab, specify an Engine to run queries on.
  10. Click Sign In.

Advanced Configuration​

Enabling the .tds File Download in the Dremio console​

ADMIN privileges are required to make updates to this setting.

To enable users to download .tds files for datasets in Dremio, follow these steps:

  1. Click the Settings icon in the left sidebar of a project.
  2. Select Project Settings.
  3. Select BI Applications.
  4. Select the Tableau tab.
  5. Toggle the Enable Tableau Desktop setting on.

After the organization administrator completes these steps, refresh your browser window.

Enabling SSO to Dremio from Tableau Enterprise​

SSO using OAuth 2.0 is supported by Tableau Desktop 2022.3 or later, Tableau Server, and Tableau Cloud.

Users of Tableau Desktop will use SSO authentication whether connecting directly to Dremio or connecting through a .tds file downloaded from Dremio. If you want to use SSO to authenticate when connecting to Dremio through a .tds file, ensure that SSO is enabled and configured for your Dremio cluster before the file is downloaded.

To enable SSO to Dremio from Tableau, ensure that your Dremio cluster has SSO configured with your identity provider and follow these steps:

  1. For Tableau Server only, follow the configuration steps.
  2. Follow the steps to enable SSO to Dremio from Tableau.

Configuring SSO for Tableau Server​

note

Using OAuth 2.0 with Tableau Server If you are using Tableau Server and you want to use OAuth 2.0 to authenticate to Dremio Cloud, you must have TLS enabled for Tableau Server for OAuth 2.0 to work. See Example: SSL Certificate - Generate a Key and CSR in the Tableau's documentation for additional information.

To configure SSO using OAuth for Tableau Server, follow these steps:

  1. 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.

Configuring Dremio​

To enable SSO authentication to Dremio from Tableau:

  1. In the Dremio console, navigate to Organization Settings 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.

  4. For Tableau Server only: 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

Customizing the Connection String​

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.

Manually Installing the Dremio Connector​

If you are previewing a feature that hasn't been released or you have been provided a .taco file with a fix that hasn't been released, you can manually install this version of the Dremio connector for temporary use.

To manually install the connector:

  1. Download the dremio.taco file.

  2. Move the dremio.taco file:

    Copy dremio.taco file on macOS 
    cp <download-location>/dremio.taco ~/Library/Tableau/Connectors/
    Copy dremio.taco file on Windows 
    copy C:\<download-location>\dremio.taco "C:\Program Files\Tableau\Connectors"
    Move dremio.taco file for Linux (Tableau Server only) 
    mv <download-location>/dremio.taco /opt/tableau/connectors/dremio.taco

  3. (Optional) If a new version of the Dremio JDBC driver is required, download it and copy it to Tableau Desktop's Drivers folder by running the following command:

    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
    Download driver for Windows 
    Invoke-WebRequest -Uri "https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar" -OutFile "C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar"

    For Linux, download the driver from the download site and move it by using this command: Download driver for Linux (Tableau Server only)

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

  4. Now you can connect to Dremio from Tableau Desktop or Tableau Server.