Tableau Prep Builder can connect to Starburst Galaxy or SEP to access your data.
There are three ways to connect Tableau Prep Builder a Starburst Enterprise platform (SEP) or Starburst Galaxy cluster:
Tableau data connector: The recommended connection method uses a Tableau data connector paired with the Starburst JDBC driver.
ODBC connection: Starburst supports connecting to clusters with the Starburst ODBC driver.
Legacy JDBC connection: Starburst continues to support the legacy connection method that uses a plain JDBC connection and the “Other Databases (JDBC)” entry point. Starburst strongly recommends migrating from this legacy method to the Tableau data connector method.
For Starburst Galaxy clusters, use the Connection info pane to obtain the connection information.
You can connect Tableau Prep Builder to Starburst Galaxy or SEP clusters with a combination of a Tableau data connector file and JDBC driver. This method requires:
Note that a Tableau data connector is not the same as a data source connector in
SEP. The Tableau data connector is a software bridge between
Tableau and the standard Starburst JDBC driver. The two files work
together to enable access between Tableau and one or more Starburst Galaxy or
SEP clusters. The Tableau data connector is a JAR file with a
name similar to
In Tableau Prep Builder, the Tableau data connector for Starburst Enterprise does not appear automatically in the list of Additional Connectors. To get Starburst Enterprise to appear in that list, follow these steps to manually download the Tableau data connector for Starburst Enterprise:
Close and exit Tableau Prep Builder.
From the Starburst Enterprise
page of Tableau’s
web-based Extension Gallery, download the Tableau data connector file whose
name is similar to
StarburstEnterprise.taco. Use the Download button
on the upper right of the page. This requires logging into Tableau’s site
with a free login.
Move the data connector
.taco file to the following location, depending
on which operating system you are using:
Download the latest Trino JDBC driver.
Place the JDBC driver file in the following location, depending on which operating system you are using:
Do not store more than one Starburst JDBC driver in this directory. Delete any older drivers when you update to a newer version. Connections to all connected data sources are made through the JDBC driver.
To establish a connection to Starburst Galaxy or SEP, do the following:
Start Tableau Prep Builder. In the left-side blue panel, click to expose the Connections pane, then click the plus + sign to add a new connection.
In the list of server types, select Starburst Enterprise by Starburst. This opens a Connector Details dialog that describes the data connector.
Click Install. This opens a connection dialog:
Fill in the connection dialog with the following parameters:
|Hostname or IP address of your cluster.
|Port used by your cluster.
|Use the drop-down list to select among four options: Username for a cluster with no authentication, Username and Password for a cluster with a password-based authentication method such as LDAP, or OAuth. If you select OAuth, see OAuth 2.0 authentication.
|Your username for Starburst Galaxy or SEP.
|(If selected) the password for the specified Username.
|Select this checkbox if your cluster has any authentication enabled. When selected, the following field appears.
|Select an entry in the drop-down list to specify how rigorously the server’s certificate is to be validated.
The values for SSL Verification have the following meanings:
When the connection is made, the Connections panel shows a list of the catalogs configured in your cluster.
To see the available tables, select a catalog, then a schema from that catalog.
Select a table, or select multiple tables and specify relationships or joins.
To use OAuth 2.0 to connect to Starburst, you must request and install a custom data connector file. Contact your account team for more information.
If you have a custom data connector file, install it as described in the download data connector section.
Open Tableau Desktop and begin the ODBC configuration. On the startup page, select Other Databases (ODBC), and configure as follows:
String Extras field supports any of the ODBC connection properties from
the Starburst ODBC driver.
Select Sign In to establish the connection. If you are prompted for a password, this means the cluster has authentication enabled.
The Tableau ODBC documentation contains further information.
Tableau Prep Builder provides a generic connection method titled Other Databases (JDBC). Although Starburst strongly recommends using a Tableau data connector, this generic JDBC connection method is still available. Follow these steps:
Download the latest Trino JDBC driver.
Place the JDBC driver JAR file in the Tableau drivers directory:
Do not store more than one Trino JDBC driver in this directory. Delete any older drivers when you update to a newer version. Connections to all connected data sources are made through the Trino JDBC driver.
Start Tableau Prep Builder and select Connect to a server using the Other Databases (JDBC) connector in Tableau.
Fill in the connection dialog as shown in the following table. For the URL field, use a JDBC connection string in this format:
The JDBC connection string must include the initial catalog to connect to. Once connected, you can select schemas and tables within that catalog, or select a different catalog.
If your cluster has TLS enabled, append the property
?SSL=true to the
|Full JDBC connection string for your cluster. Must include a catalog name, such as `mysql` in the following example.
|Must be 'SQL92'
|Specify or browse to the path of a JDBC properties file containing further specifications for this connection. See Customized JDBC Connections.
Is the information on this page helpful?