Connecting to Tableau (desktop)
This topic describes the steps for setting up the Tableau (desktop) connection to Firebolt.
- Install the latest Firebolt JDBC Driver
- Install the latest Firebolt TACO file
- Set up the connection to Firebolt in Tableau
Install the latest Firebolt JDBC Driver
Download Firebolt’s JDBC driver for Tableau from here.
Put the JDBC jar file in the Tableau JDBC driver folder:
- Windows:
C:\Program Files\Tableau\Drivers
- Mac:
~/Library/Tableau/Drivers
Install the latest Firebolt TACO file
Download Firebolt’s packaged connector file for Tableau (with a .taco filename extension) from here.
Copy the packaged connector file into your My Tableau Repository/Connectors directory
:
- Windows:
C:\Users\[your-user]\Documents\My Tableau Repository\Connectors
- Mac:
~/Documents/My Tableau Repository/Connectors
Set up the connection to Firebolt in Tableau
Pre-requisites
-
Make a note of the database name you would like to connect to in Firebolt. Also, make sure the database has an up-and-running engine before you configure the connection in Tableau.
-
Make a note of the username and password used to log into Firebolt.
-
Start Tableau and disable signature validation for the TACO file. For more information, see “Disabling signature verification” in Run Your Connector in Tableau Connector SDK documentation.
Configuring the Connection
-
In Tableau, under Connect, choose More.
-
Search for Connector by Firebolt in the list of connectors and select it.
-
In the form that appears, fill in parameters according to the guidelines below, and then choose Sign in.
Parameter Description Value Server
The URL of Firebolt’s API server api.app.firebolt.io
Database
The name of the database you would like to connect to Database name Engine
The name of the engine you would like to use (optional). If not specified - the default engine will be used. Engine name Username
The username used for connecting to Firebolt Your Firebolt username Password
The password used for connecting to Firebolt Your Firebolt password