Establish Connectivity to Trino

This article describes how to connect to Trino in order to load data into Datasets and Reports in Metric Insights.

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source] 
  2. Select SQL as a type of new Data Source
  3. [Next Step]

2. Provide Required Parameters

  1. Input a descriptive phrase in Name
  2. Select the desired Auth Type:
    • "Password": input Trino credentials as exemplified above
    • "Identity Profile": select the required Identity Profile from the field that will appear below Auth Type
  3. Enter Data Source Username 
  4. Enter Data Source Password to access the database
  5. Specify Trino Host name
  6. Input the required Database name
  7. Choose "Trino" from the drop-down
    • The Port number will be set by default, but can be modified.
  8. [Save]