Using Starburst with Amazon QuickSight
Starburst is a full-featured data lake analytics service built on top of a massively parallel processing (MPP) query engine, Trino. Use this section to learn how to connect from Amazon QuickSight to Starburst. All traffic between QuickSight and Starburst is enabled by SSL. If you're connecting to Starburst Galaxy, you can get the necessary connection details by logging in to your Starburst Galaxy account, then choose Partner Connect and then QuickSight. You should be able to see information, such as hostname and port. Amazon QuickSight supports basic username and password authentication to Starburst.
Creating a data source connection for Starburst
-
Begin by creating a new dataset. From the left navigation pane, choose Datasets, then choose New Dataset.
Choose the Starburst data source card.
Select the Starburst product type. Choose Starburst Enterprise for on-prem Starburst instances. Choose Starburst Galaxy for managed instances.
You should see the following data source creation modal.
For Data source name, enter a descriptive name for your Starburst data source connection. Because you can create many datasets from a connection to Starburst, it's best to keep the name simple.
For Connection type, select the type of network you're using. Choose Public network if your data is shared publicly. Choose VPC if your data is inside a VPC. To configure a VPC connection in Amazon QuickSight, see Configuring the VPC connection in Amazon QuickSight. This connection type is not available for Starburst Galaxy.
For Database server enter the hostname specified in your Starburst connection details.
For Catalog, enter the catalog specified in your Starburst connection details.
For Port, enter the port specified in your Starburst connection details. Defaults to 443 for Starburst Galaxy.
For Username and Password, enter your Starburst connection credentials.
To verify the connection is working, choose Validate connection.
To finish and create the data source, choose Create data source.
Note
Connectivity between Amazon QuickSight and Starburst was validated using Starburst version 420.
Adding a new Amazon QuickSight dataset for Starburst
After you go through the data source creation process for Starburst, you can create Starburst datasets to use for analysis. You can create new datasets from a new or an existing Starburst data source. When you are creating a new data source, Amazon QuickSight immediately takes you to creating a dataset, which is step 3 below. If you're using an existing data source to create a new dataset, start from step 1 below.
To create a dataset using a Starburst data source, see the following steps.
-
From the start page, choose Datasets and then choose New dataset at the top right.
-
Scroll down to the section FROM EXISTING DATA SOURCES and choose the Starburst data source you just created in the section above.
Choose Create data set.
To specify the table you want to connect to, choose a schema. The screenshot below shows a chosen sample schema. If you don't want to choose a schema, you can also use your own SQL statement.
To specify the table you want to connect to, first select the Schema you want to use. For Tables, select the table that you want to use. If you prefer to use your own SQL statement, select Use custom SQL.
Choose Edit/Preview.
(Optional) To add more data, use the following steps:
Choose Add data at top right.
To connect to different data, choose Switch data source, and choose a different dataset.
Follow the prompts to finish adding data.
After adding new data to the same dataset, choose Configure this join(the two red dots). Set up a join for each additional table.
If you want to add calculated fields, choose Add calculated field.
Clear the checkbox for any fields that you want to omit.
Update any data types that you want to change.
When you are done, choose Save to save and close the dataset.
Note
Connectivity between QuickSight and Starburst was validated using Starburst version 420.
