On this page

    Connecting from Tableau to Dremio Cloud

    You can use Tableau with Dremio Cloud to derive powerful insights from your data and to create real-time dashboards.

    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 Online to a project in Dremio Cloud
    • Connect to a dataset by opening .tds file that you downloaded from Dremio Cloud

    Connecting from Tableau Desktop to Dremio Cloud

    note:

    Connecting to Dremio’s EU control plane (https://login.eu.dremio.cloud) is supported in Tableau Desktop 2022.1 and later.

    Supported Versions

    Dremio Cloud supports Tableau Desktop 2021.1 and later.

    Supported Authentication Methods

    You can authenticate to Dremio Cloud through OAuth 2.0 or with a personal access token that you have obtained from Dremio Cloud. If you want to authenticate your connection to Dremio Cloud by using a personal access token, see Creating a Token for the steps to obtain one.

    note:

    An issue in Tableau 2021.3 and later prevents more than one connection to Dremio Cloud at a time through OAuth 2.0. If you need to make a second connection to Dremio Cloud while one connection is already open, you can use a personal access token.

    Prerequisite

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

    Connecting with Tableau’s Native Connector for Dremio Cloud

    You can use this method of connecting with Tableau Desktop, Version 2021.3 or later.

    warning:

    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.

    1. Download the Dremio JDBC Driver and copy it to the /Tableau/Drivers/ folder. See below for instructions based on your OS.

      Mac

      In the terminal, run the following command to download the driver to ~/Library/Tableau/Drivers. You can also manually download the driver and move it to the folder.

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

      Windows

      In the command line, run the following command as an administrator to download the driver to C:\Program Files\Tableau\Drivers. You can also manually download the driver and move it to the folder.

      curl https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o C:\PROGRA~1\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar
      
    2. Open Tableau Desktop. If you already had Tableau Desktop open, restart the application.

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

    4. Select Dremio.

    5. In the Dremio connection dialog, follow these steps:

      a. In the Product field, select Dremio Cloud.

      b. (Tableau Desktop 2022.1 or later) In the Server field, select the Dremio control plane in which your Dremio organization is located: sql.dremio.cloud (US) or sql.eu.dremio.cloud (Europe).

      c. For authenticating to Dremio Cloud, follow one of these steps:

      • In the Authentication field, select OAuth 2.0. Then, in the Dremio Authentication Server field, specify one of these URLs:

        • If you selected the control plane for the US or if you are using a version of Tableau Desktop earlier than 2022.1, use https://login.dremio.cloud.
        • If you selected the control plane for Europe, use https://login.eu.dremio.cloud.
      • In the Authentication field, select Personal Access Token. Then, in the Personal Access Token field, paste in a personal access token for Dremio Cloud. See Creating a Token for information about generating a token.

      d. 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, log into Dremio Cloud, switch to the project that you want the ID for, click the settings icon, select Project Settings, and then copy the content of the Project field.
      If you want to use the default project for your Dremio Cloud organization, proceed to the next step. To learn how an administrator for your Dremio Cloud organization can set a default project, see Setting the Default Project for an Organization.

      e. (Optional) In the Advanced tab, specify an Engine to run queries on.

      f. Click Sign In.

    Installing the Connector for Tableau Desktop Manually

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

    1. Download the Dremio .taco file for 2021.3.

    2. Move the .taco file to the /Connectors/ folder. See below for instructions based on your OS.

      Tableau Desktop 2021.1

      Mac

      In the terminal, run the following command to copy the .taco file to /My Tableau Repository/Connectors/. This command assumes that the .taco file was downloaded into the Downloads folder.

      cp ~/Downloads/dremio-2021.3.taco ~/Documents/My\ Tableau\ Repository/Connectors/ 
      

      Windows

      In the command line, run the following command to copy the .taco file to /My Tableau Repository/Connectors. This command assumes that the .taco file was downloaded into the Downloads folder.

      copy C:\Users\[user]\Downloads\dremio-2021.3.taco C:\Users\[user]\Documents\My Tableau Repository\Connectors
      

      Tableau Desktop 2021.2 or later

      Mac

      In the terminal, run the following command to copy the .taco file to /Tableau/Connectors/. This command assumes that the .taco file was downloaded into the Downloads folder. The Connectors folder may need to be created if it doesn’t already exist.

      cp ~/Downloads/dremio-2021.3.taco /Users/<user>/Library/Tableau/Connectors/
      

      Windows

      In the command line, run the following command to copy the .taco file to /Tableau/Connectors. This command assumes that the .taco file was downloaded into the Downloads folder. The Connectors folder may need to be created if it doesn’t already exist.

      copy C:\Users\[user]\Downloads\dremio-2021.3.taco C:\Program Files\Tableau\Connectors
      
    3. Download the Dremio JDBC Driver and copy it to the /Tableau/Drivers/ folder.

      Mac

      In the terminal, run the following command to download the driver to ~/Libary/Tableau/Drivers. You can also manually download the driver and move it to the folder.

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

      In the command line, run the following command to download the driver to C:\Program Files\Tableau\Drivers. You can also manually download the driver and move it to the folder.

      curl https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar
      
    4. Open Tableau Desktop. If you already had Tableau Desktop open, restart the application.

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

    6. Select Dremio.

    7. In the Dremio connection dialog, follow these steps:

      a. In the Product field, select Dremio Cloud.

      b. (Tableau Desktop 2022.1 or later) In the Server field, select the Dremio control plane in which your Dremio organization is located: sql.dremio.cloud (US) or sql.eu.dremio.cloud (Europe).

      c. For authenticating to Dremio Cloud, follow one of these steps:

      • In the Authentication field, select OAuth 2.0. Then, in the Dremio Authentication Server field, specify one of these URLs:

        • If you selected the control plane for the US or if you are using a version of Tableau Desktop earlier than 2022.1, use https://login.dremio.cloud.
        • If you selected the control plane for Europe, use https://login.eu.dremio.cloud.
      • In the Authentication field, select Personal Access Token. Then, in the Personal Access Token field, paste in a personal access token for Dremio Cloud. See Creating a Token for information about generating a token.

      d. 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, log into Dremio Cloud, switch to the project that you want the ID for, click the settings icon, select Project Settings, and then copy the content of the Project field.
      If you want to use the default project for your Dremio Cloud organization, proceed to the next step. To learn how an administrator for your Dremio Cloud organization can set a default project, see Setting the Default Project for an Organization.

      e. (Optional) In the Advanced tab, specify an Engine to run queries on.

      f. Click Sign In.


    Connecting from Tableau Server to Dremio Cloud

    note:

    Connecting to Dremio’s EU control plane (https://login.eu.dremio.cloud) is supported in Tableau Server 2022.1 and later.

    Supported Versions

    Dremio Cloud supports Tableau Server 2021.1 and later.

    Supported Authentication Methods

    You can authenticate to Dremio Cloud through OAuth 2.0 or with a personal access token that you have obtained from Dremio Cloud.

    note:

    An issue in Tableau Server 2022.1.1 prevents it from supporting OAuth 2.0 for connections to Dremio Cloud.

    * If you want to authenticate your connection to Dremio Cloud by using a personal access token, see [Creating a Token](/cloud/security/authentication/personal-access-token/#creating-a-token) for the steps to obtain one.

    note:

    An issue in Tableau 2021.3 and later prevents more than one connection to Dremio Cloud at a time through OAuth 2.0. If you need to make a second connection to Dremio Cloud while one connection is already open, you can use a personal access token.

    If you are a Tableau Server admin and you want users to authenticate to Tableau Server by means of OAuth, 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:

      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 the settings of your Dremio Cloud organization, specify the same redirect URI that you used in the command in the previous step:

      a. In Dremio Cloud, move your mouse pointer over the gear in the left navigation sidebar and select Organization Settings.

      b. Select BI Applications on the left.

      c. On the BI Applications page, select Tableau.

      d. Specify the redirect URI in the Redirect URI(s) field.

    Prerequisite

    ‎ Before attempting to connect from Tableau Server to Dremio Cloud, ensure that Java 8 is installed on your system.

    Connecting with Tableau’s Native Connector for Dremio Cloud

    You can use this method of connecting with Tableau Server, Version 2021.3 or later

    1. Download the Dremio JDBC Driver and copy it to the /Tableau/Drivers/ folder. See below for instructions based on your OS.

      Windows

      In the command line, run the following command to download the driver to C:\Program Files\Tableau\Drivers. You can also manually download the driver and move it to the folder.

      curl https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar
      
      Linux

      Move the downloaded driver to the folder below.

      /opt/tableau/tableau_driver/jdbc
      
    2. Navigate to your Tableau Server site.

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

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

    5. In the Dremio connection dialog, follow these steps:

      a. In the Product field, select Dremio Cloud.

      b. (Tableau Server 2022.1 or later) In the Server field, select the Dremio control plane in which your Dremio organization is located: sql.dremio.cloud (US) or sql.eu.dremio.cloud (Europe).

      c. For authenticating to Dremio Cloud, follow one of these steps:

      • In the Authentication field, select OAuth 2.0. Then, in the Dremio Authentication Server field, specify one of these URLs:

        • If you selected the control plane for the US or if you are using a version of Tableau Server earlier than 2022.1, use https://login.dremio.cloud.
        • If you selected the control plane for Europe, use https://login.eu.dremio.cloud.
      • In the Authentication field, select Personal Access Token. Then, in the Personal Access Token field, paste in a personal access token for Dremio Cloud. See Creating a Token for information about generating a token.

      d. 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, log into Dremio Cloud, switch to the project that you want the ID for, click the settings icon, select Project Settings, and then copy the content of the Project field.
      If you want to use the default project for your Dremio Cloud organization, proceed to the next step. To learn how an administrator for your Dremio Cloud organization can set a default project, see Setting the Default Project for an Organization.

      e. (Optional) In the Advanced tab, specify an Engine to run queries on.

      f. Click Sign In.

    Installing the Connector for Tableau Server Manually

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

    1. Download the Dremio Connector .taco file.

    2. Move the .taco file to the /Connectors/ folder. See below for instructions based on your OS.

      Tableau Server 2021.1

      Windows

      Open the Command Prompt and run the following command. This command assumes that the .taco file was downloaded into the Downloads folder.

      copy C:\Users\[user]\Downloads\dremio-2021.3.taco C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors
      
      Linux

      Move the .taco file to the folder below.

      /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors
      

      Tableau Server 2021.2 or later

      Windows

      Open the Command Prompt and run the following command. This command assumes that the .taco file was downloaded into the Downloads folder. The Connectors folder may need to be created if it doesn’t already exist.

      copy C:\Users\[user]\Downloads\dremio-2021.3.taco C:\Program Files\Tableau\Connectors
      
      Linux

      Move the .taco file to the folder below.

      /opt/tableau/connectors
      
    3. Download the Dremio JDBC Driver and copy it to the /Tableau/Drivers/ folder.

      Windows

      In the command line, run the following command to download the driver to C:\Program Files\Tableau\Drivers. You can also manually download the driver and move it to the folder.

      curl https://download.dremio.com/jdbc-driver/dremio-jdbc-driver-LATEST.jar -o -l C:\Program Files\Tableau\Drivers\dremio-jdbc-driver-LATEST.jar
      
      Linux

      Move the JDBC driver to the folder below.

      opt/tableau/tableau_jdbc/jdbc
      
    4. Navigate to your Tableau Server site.

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

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

    7. In the Dremio connection dialog, follow these steps:

      a. In the Product field, select Dremio Cloud.

      b. (Tableau Server 2022.1 or later) In the Server field, select the Dremio control plane in which your Dremio organization is located: sql.dremio.cloud (US) or sql.eu.dremio.cloud (Europe).

      c. For authenticating to Dremio Cloud, follow one of these steps:

      • In the Authentication field, select OAuth 2.0. Then, in the Dremio Authentication Server field, specify one of these URLs:

        • If you selected the control plane for the US or if you are using a version of Tableau Server earlier than 2022.1, use https://login.dremio.cloud.
        • If you selected the control plane for Europe, use https://login.eu.dremio.cloud.
      • In the Authentication field, select Personal Access Token. Then, in the Personal Access Token field, paste in a personal access token for Dremio Cloud. See Creating a Token for information about generating a token.

      d. 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, log into Dremio Cloud, switch to the project that you want the ID for, click the settings icon, select Project Settings, and then copy the content of the Project field.
      If you want to use the default project for your Dremio Cloud organization, proceed to the next step. To learn how an administrator for your Dremio Cloud organization can set a default project, see Setting the Default Project for an Organization.

      e. (Optional) In the Advanced tab, specify an Engine to run queries on.

      f. Click Sign In.


    Connecting from Tableau Online to Dremio Cloud

    note:

    Connecting to the EU control plane (https://login.eu.dremio.cloud) from Tableau Online is not currently supported.

    Supported Versions

    Dremio Cloud supports Tableau Online, Version 2021.3 or later.

    Supported Authentication Method

    You can authenticate to Dremio Cloud by using a personal access token. See Creating a Token for the steps to obtain one.

    Connecting

    1. Navigate to your Tableau Online site.

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

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

    4. In the Dremio connection dialog, follow these steps:

      a. In the Product field, select Dremio Cloud.

      b. In the Authentication field, select Personal Access Token. Then, in the Personal Access Token field, paste in a personal access token for Dremio Cloud. See Creating a Token for information about generating a token.

      c. 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, log into Dremio Cloud, switch to the project that you want the ID for, click the settings icon, select Project Settings, and then copy the content of the Project field.
      If you want to use the default project for your Dremio Cloud organization, proceed to the next step. To learn how an administrator for your Dremio Cloud organization can set a default project, see Setting the Default Project for an Organization.

      e. (Optional) In the Advanced tab, specify an Engine to run queries on.

      f. Click Sign In.


    Creating a Live Connection to a Dataset from Dremio Cloud

    You can generate a Tableau Datasource (.tds) file that represents a “live connection” to a 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.

    You or a person that you send the file to can then double-click the file to open in in Tableau, provide credentials for connecting to Dremio Cloud, and then query the data that the file represents.

    note:

    OAuth is the only supported authentication mechanism for .tds files.

    Before you follow these steps, ensure that the Tableau Desktop option is enabled on the BI Applications page. To enable this option, ask an organization administrator to follow these steps:

    1. Click the Settings icon in the left sidebar.
    2. Select Project Settings.
    3. Select BI Applications.
    4. Toggle the switch next to Tableau Desktop.

    After the organization administrator completes these steps, refresh your browser window if you are viewing the SQL Runner.

    To download a .tds file:

    1. In the Datasets section of Dremio Cloud, locate a dataset you want to work with and click its name.
    2. (Optional) Modify the query in the SQL editor. By default, the query is SELECT * FROM <name-of-dataset>. If you want your .tds file to represent a view on the dataset, change the query and preview the results to be sure the view represents the data that you want.
    3. Above the SQL editor, click the button that displays the Tableau logo.

    After you complete the steps, either of these actions takes place:

    • If you did not modify the default query in the SQL editor, a .tds file for that query is downloaded to your system.
    • If you did modify the default query, Dremio asks you to name the new virtual dataset created by the modified query. After you specify a name, Dremio saves the virtual dataset and downloads a .tds file for the query.

    To view the data in Tableau Desktop:

    1. Double-click the .tds file.
    2. Authenticate to Dremio Cloud in the browser window that Tableau opens.

    Troubleshooting Tableau Client Connections

    Set the following environment variable if these three conditions are true:

    • You are using version 14.0 or earlier of the Dremio JDBC driver for connections from your Tableau application to Dremio Cloud.
    • Your system is running Java v9+.
    • Your queries are underperforming because their job profiles show that they are not using reflections.
    JAVA_TOOL_OPTIONS=-Dcdjd.io.netty.tryReflectionSetAccessible=true