Connecting Tableau and Firebolt.
Tableau 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 or Tableau Prep.
The latest Firebolt version is not compatible with Tableau Online, and you will not be able to connect it to your Firebolt account.
You must have the following prerequisites before you can connect your Firebolt account to Tableau:
To connect to Tableau Desktop or Tableau Prep, you must download a Firebolt connector, a JDBC driver, connect to Firebolt, and select a database and schema to query.
Download and install Tableau
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. The name of the file has the following format: firebolt-jdbc-<version>.jar
, and should be saved in a specific directory that depends on the operating system as follows:
C:\Program Files\Tableau\Drivers
/Users/<username>/Library/Tableau/Drivers
/opt/tableau/tableau_driver/jdbc
Download the latest Firebolt connector
a. Tableau Desktop
b. Tableau Prep
Start Tableau and verify Firebolt connector availability
Start your Tableau Desktop or Tableau Prep. If you selected “Install and restart” in the previous step it should restart automatically.
Following the same steps as in 3a or 3b find the Firebolt Connector.
Select it and Enter the following parameters in the General tab:
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 to connect to. |
Client ID | Yes | The ID of your service account. |
Client Secret | Yes | The secret for your service account authentication. |
Engine Name | Yes | The name of the engine to run queries. |
Account | Yes | The name of your Firebolt account within your organization. |
Select Sign in.
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:
Select the drop-down list under Schema to select a schema. Most users should choose public
. For more information about schema permissions and privileges, see Schema permissions.
Drag and drop tables from the list of available tables in your schema to use them in Tableau.
Prepare or visualize your data
Once your data source is selected you can begin preparing or visualizing the data as follows:
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 documentation for more information.