---
title: Use Tableau to query data with SQL
seotitle: Use Tableau to query data stored in InfluxDB Cloud Serverless
description: >
  Install and use [Tableau](https://www.tableau.com/) to query data stored in InfluxDB.
weight: 201
menu:
  influxdb3_cloud_serverless:
    parent: Visualize data
    name: Use Tableau
influxdb3/cloud-serverless/tags: [Flight client, query, flightsql, tableau, sql]
aliases:
  - /influxdb3/cloud-serverless/query-data/sql/execute-queries/tableau/
alt_links:
  core: /influxdb3/core/visualize-data/tableau/
  enterprise: /influxdb3/enterprise/visualize-data/tableau/
metadata: [SQL only]
---

Use [Tableau](https://www.tableau.com/) to query and visualize time series data
stored in {{< product-name >}}. Tableau supports multiple SQL dialects.

> Tableau is a visual analytics platform transforming the way we use data to
> solve problems—empowering people and organizations to make the most of their data.
>
> {{% cite %}}[tableau.com](https://www.tableau.com/why-tableau/what-is-tableau){{% /cite %}}

> [!Note]
> #### Tableau Desktop
> 
> These instructions are for **Tableau Desktop**.
> Tableau Cloud and other Tableau products have not been tested, but may support
> connecting to {{< product-name >}} through the **Flight SQL JDBC driver**.

## Install Tableau Desktop

If you have not already, [download and install Tableau Desktop](https://www.tableau.com/products/desktop/download).

## Download and install the Flight SQL JDBC driver

To query {{< product-name >}} from Tableau, use the **Flight SQL protocol** and the
**Flight SQL JDBC driver**.

1.  **Download the Flight SQL JDBC driver.**
    1.  Visit the [Flight SQL JDBC driver](https://central.sonatype.com/artifact/org.apache.arrow/flight-sql-jdbc-driver/) page.
    2.  Select the **Versions** tab.
    3.  Click **Browse {{< icon "export" >}}** next to the version you want to
        download.
    4.  Click the `flight-sql-jdbc-driver-XX.XX.XX.jar` file
        (with only the `.jar` file extension) from the list of files
        to download the driver jar file.
        The version number in the file name is specific to the version you selected.

2.  **Copy the downloaded jar file into the following directory based on your operating system.**
  
    - **Windows**: `C:\Program Files\Tableau\Drivers`
    - **Mac**: `~/Library/Tableau/Drivers`
    - **Linux**: `/opt/tableau/tableau_driver/jdbc`

3.  **Start or restart Tableau.**

## Configure a JDBC server connection

1.  Open Tableau
2.  In the **Connect** column, under **To a Server**, select **Other Databases (JDBC)**.
    If that option isn't in the initial list, select **More...** to find it in
    the full list of connection options.
3.  Provide the required credentials:

    - **URL**: Your [InfluxDB Cloud Serverless region URL](/influxdb3/cloud-serverless/reference/regions/)
      with the following:

      - **Protocol**: `jdbc:arrow-flight-sql`
      - **Port**: `443`
      - **Query parameters**:
        - **useSystemTrustStore**: `false`

          > [!Note]
          > Setting `useSystemTrustStore=false` is only necessary on macOS and
          > doesn't actually affect the security of the connection to Tableau.

        - **database**: InfluxDB bucket name to query
    
      _See an [example connection URL](#example-connection-url)._
    
    - **Dialect**: PostreSQL
    - **Username**: _Leave empty_
    - **Password**: [API token](/influxdb3/cloud-serverless/admin/tokens/)
      with read access to the specified bucket
    - **Properties File**: _Leave empty_

4.  Click **Sign In**.

#### Example connection URL

{{< code-placeholders "BUCKET_NAME" >}}
```
jdbc:arrow-flight-sql://us-east-1-1.aws.cloud2.influxdata.com:443?useSystemTrustStore=false&database=BUCKET_NAME
```
{{< /code-placeholders >}}

## Query InfluxDB Cloud Serverless

With the connection successfully established, query your time series data stored
in {{< product-name >}}. In the left pane:

1.  Under **Database**, select **public** from the drop-down menu.
2.  Under **Schema**, select **iox** from the drop-down menu.
3.  Under **Table**, click and drag the measurement you want to query into the query pane.
4.  Use Tableau to build and execute SQL queries.
    For more information, see the
    [Tableau Desktop documentation](https://help.tableau.com/current/pro/desktop/en-us/default.htm).

## Build visualizations with Tableau

After you've connected Tableau to your InfluxDB database, see the Tableau documentation to [Set Up Data Sources](https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm) and begin working with data.