Using Trino with Amazon QuickSight
Trino is a massively parallel processing (MPP) query engine built to quickly query data lakes with petabytes of data. Use this section to learn how to connect from Amazon QuickSight to Trino. All traffic between Amazon QuickSight and Trino is enabled by SSL. Amazon QuickSight supports basic username and password authentication to Trino.
Creating a data source connection for Trino
-
Begin by creating a new dataset. From the left navigation pane, choose Datasets, then choose New Dataset.
Choose the Trino data source card.
You should see the following data source creation modal.
For Data source name, enter a descriptive name for your Trino data source connection. Because you can create many datasets from a connection to Trino, 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.
For Database server, enter the hostname specified in your Trino connection details.
For Catalog, enter the catalog specified in your Trino connection details.
For Port, enter the port specified in your Trino connection details.
For Username and Password, enter your Trino connection credentials.
To verify the connection is working, choose Validate connection.
To finish and create the data source, choose Create data source.
Adding a new Amazon QuickSight dataset for Trino
After you go through the data source creation process for Trino, you can create Trino datasets to use for analysis. You can create new datasets from a new or an existing Trino 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 Trino data source, see the following steps.
From the start page, choose Datasets and then choose New dataset in the top right.
Scroll down to the section that says FROM EXISTING DATA SOURCES and choose the Trino data source you created.
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, choose 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 in the 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 check box 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 Trino was validated using Trino version 410.
