Tableau Cloud can connect to Starburst Galaxy or SEP to access your data. This connection is established using the Tableau data connector. It uses a Tableau data connector paired with the Trino JDBC driver.
Tableau Cloud was formerly known as Tableau Online.
For Starburst Galaxy clusters, use the Connection info pane to obtain the connection information.
Tableau Cloud comes with the Starburst Enterprise by Starburst data connector included for every customer. This option can be used to connect to both Starburst Galaxy and SEP clusters, with a username and password as the authentication method. For SEP, 354-e or later is required.
Note that a Tableau data connector is not the same as a data source connector in SEP.
To establish a connection to Starburst Galaxy or SEP, do the following:
Log in to Tableau Cloud. Click Create, then select Workbook. In the Connect to Data pane, click the Connectors tab.
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 three options: Username for a cluster with no authentication, Username and Password for a cluster with authentication enabled.
|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.
Remember that Starburst Enterprise and Starburst Galaxy are not databases. They are SQL query engines that can connect to multiple data sources at the same time. Each cluster can query multiple catalogs in a wide range of different data sources.
Although Tableau is typically configured to access one specific catalog and schema, it is possible to query more than one data source with a single Tableau connection.
To query multiple catalogs, select New Custom SQL and then reference the
fully-qualified name of any table in the cluster using the full
The following example query accesses four catalogs:
FROM postgresql.burst_bank.customer c
JOIN hive.burst_bank.account a on c.custkey = a.custkey
JOIN mysql.burst_bank.product_profile pp on a.custkey = pp.custkey
JOIN sqlserver.burst_bank.customer_profile cp on c.custkey = cp.custkey
WHERE c.country = 'US'
AND c.state NOT IN ('AA', 'AE', 'AP')
This approach is faster because all table access is managed by Starburst on the Starburst Galaxy or SEP cluster, and takes advantage of Starburst query optimization.
Tableau is also capable of joining data from multiple data sources, but this approach creates an unnecessary workload on Tableau, and can negatively impact Tableau performance.
Is the information on this page helpful?