> ## Documentation Index > Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt > Use this file to discover all available pages before exploring further. ## Submitting Feedback If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback: POST https://docs.firebolt.io/feedback ```json { "path": "/guides/integrations/tableau", "feedback": "Description of the issue" } ``` Only submit feedback when you have something specific and actionable to report. > Connecting Tableau and Firebolt. # Tableau Tableau icon [Tableau](https://www.tableau.com/) is a visual analytics platform that empowers users to explore, analyze, and present data through interactive visualizations. It supports diverse use cases such as data exploration, reporting, and collaboration, and helps users gain insights and make informed decisions. This guide shows you how to set up your Firebolt account to integrate with [Tableau Desktop](https://www.tableau.com/products/desktop) or [Tableau Prep](https://www.tableau.com/products/prep). ## Prerequisites You must have the following prerequisites before you can connect your Firebolt account to Tableau: * **Tableau account** – You must have access to an active Tableau account. If you do not have access, you can [sign up](https://www.tableau.com/products/trial) for one. * **Firebolt account** – You need an active Firebolt account. If you do not have one, you can [sign up](https://go.firebolt.io/signup) for one. * **Firebolt database and table** – You must have access to a Firebolt database that contains a table with data ready for visualization. If you don't have access, you can [create a database](/guides/getting-started/get-started-sql#create-a-database) and then [load data](/guides/loading-data) into it. * **Firebolt service account** – You must have access to an active Firebolt [service account](/guides/managing-your-organization/service-accounts), which facilitates programmatic access to Firebolt, its ID and secret. * **Firebolt user** – You must have a user that is [associated](/guides/managing-your-organization/service-accounts#create-a-user) with your service account. The user should have [USAGE](/overview/security/rbac/database-permissions) permission to query your database, and [OPERATE](/overview/security/rbac/engine-permissions) permission to start and stop an engine if it is not already started. ## Set up Tableau Cloud 1. Navigate to Tableau Cloud's [login page](https://online.tableau.com/) and log in to your account. 2. On the home screen select **New** and from the drop-down menu select **Workbook**. 3. You will be redirected to a new page where a **Connect to Data** pane appears in the middle. Select **Connectors** to open a list of all the connectors available. 4. Find "Firebolt Connector by Firebolt" and select it. 5. Follow the steps in [Connect to Firebolt](#connect-to-firebolt) to connect to your Firebolt account and select a database and schema to query. ## Set up Tableau Desktop or Tableau Prep To connect Tableau Desktop or Tableau Prep to Firebolt, you must install a Firebolt connector, a [JDBC driver](/guides/developing-with-firebolt/connecting-with-jdbc#jdbc-driver), connect to Firebolt, and select a database and schema to query. 1. **Download and install Tableau** 1. Navigate to Tableau's [download page](https://www.tableau.com/products/desktop/download) for Desktop or [download page](https://www.tableau.com/products/prep/download) for Prep. 2. Follow the prompts to install Tableau Desktop or Tableau Prep. 2. **Download the latest JDBC driver** Download a JDBC driver, which will allow Tableau to interact with Firebolt databases using Java, from Firebolt's GitHub [repository](https://github.com/firebolt-db/jdbc/releases). The name of the file has the following format: `firebolt-jdbc-.jar`, and should be saved in a specific directory that depends on the operating system as follows: * Windows: `C:\Program Files\Tableau\Drivers` * Mac: `/Users//Library/Tableau/Drivers` * Linux: `/opt/tableau/tableau_driver/jdbc` 3. **Download the latest Firebolt connector** 1. **Tableau Desktop** 1. Open Tableau and on the home screen in the Connect section on the left find **To a Server** option. 2. Select **More...** to open a list of all the connectors available. 3. Find "Firebolt by Firebolt Analytics Inc" in the **Additional Connectors** section or use the search bar to quickly navigate to it. 4. Select this connector and in the following window select **Install and restart Tableau**. 2. **Tableau Prep** 1. Open Tableau and on the home screen in the top section press the **Connect to Data** button. 2. In the newly opened **Connect** section scroll down to find "Firebolt by Firebolt Analytics Inc" in the **Additional Connectors** section or use the search bar to quickly navigate to it. 3. Select this connector and in the following window select **Install and restart Tableau**. 4. **Start Tableau and verify Firebolt connector availability** 1. Start your Tableau Desktop or Tableau Prep. If you selected "Install and restart" in the previous step it should restart automatically. 2. Following the same steps as in **3a** or **3b** find the Firebolt Connector. 5. Follow the steps in [Connect to Firebolt](#connect-to-firebolt) to connect to your Firebolt account and select a database and schema to query. ## Connect to Firebolt 1. Select "Firebolt Connector by Firebolt" from the list of available connectors. 2. Enter the following parameters: | **Field** | **Required** | **Description** | | ----------------- | ------------ | ---------------------------------------------------------------------------------------------------------------------------- | | **Host** | No | Most users should not enter a value in the text box under `Host`. | | **Database** | Yes | The name of the Firebolt [database](/overview/indexes#databases) to connect to. | | **Client ID** | Yes | The [ID of your service account](/guides/managing-your-organization/service-accounts#get-a-service-account-id). | | **Client Secret** | Yes | The [secret](/guides/managing-your-organization/service-accounts#generate-a-secret) for your service account authentication. | | **Engine Name** | Yes | The name of the [engine](/overview/engine-fundamentals) to run queries. | | **Account** | Yes | The name of your Firebolt account within your organization. | 3. Select **Sign in**. 4. **Choose the database and the schema to query** After successful authentication, **Database** and **Schema** drop-down lists appear in the left navigation pane under **Connections**. The database name from the previous step appears in the database drop-down list. To change the database, you must repeat the previous step and set up a new connector. Choose the schema and tables as follows: 1. Select the drop-down list under **Schema** to select a [schema](/overview/indexes#schema). Most users should choose `public`. For more information about schema permissions and privileges, see [Schema permissions](/overview/security/rbac/database-permissions/schema-permissions). 2. Drag and drop tables from the list of available tables in your schema to use them in Tableau. 5. **Prepare or visualize your data** Once your data source is selected you can begin preparing or visualizing the data as follows: * **For Tableau Desktop/Cloud**: Select `Sheet 1` tab from the bottom-left corner of your Tableau window next to **Data Source**. In the left navigation panel under **Sheets**, drag and drop any available columns or pre-defined aggregation from your table into the Tableau workspace to start building charts. See Tableau's [Build a view from scratch](https://help.tableau.com/current/pro/desktop/en-us/getstarted_buildmanual_ex1basic.htm) documentation for more information. * **For Tableau Prep**: Use Tableau Prep's tools to clean and shape your data. See Tableau Prep's [Getting Started](https://help.tableau.com/current/prep/en-us/prep_get_started.htm) documentation for more information. Combine data from multiple sources if needed and save the prepared data for analysis in Tableau Desktop or Server. ## Limitations * Once you have set up a connection to Firebolt, you cannot change the database that you specified during setup. In order to change the database, you must repeat step 4 to **Start Tableau and verify Firebolt connector availability** in [Connect to Tableau](#connect-to-tableau-desktop-or-tableau-prep) to set up a new connection. ## Additional resources * Watch Tableau's [free training videos](https://www.tableau.com/en-gb/learn/training) on getting started, preparing data, and geographical analysis. * Read Tableau's data visualization [articles](https://www.tableau.com/en-gb/learn/articles) about creating effective, engaging, and interactive examples. * Follow Tableau's [blog](https://www.tableau.com/en-gb/blog) for new features and tips.