Create Dataset from Trino

This article explains how to create a Dataset and Report from Trino.

PREREQUISITES: 

Established connectivity to Trino

1. Add New Dataset

Access New > Datasets > Create New

Enter the basics:

  1. Select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Define if Dataset should be searchable
  3. Input a descriptive phrase in Name
  4. Specify Category to place the Dataset 

Proceed to Data tab to define details

2. Define Settings for Data Collection

  1. Select the Trino Analysis Services Data Source
  2. Specify Data collection trigger that will be used to collect data for Dataset
  3. Input an SQL command listing all the data you would like to fetch from Trino
  4. [Validate]
  5. [Enable & View] to proceed to Dataset Viewer

3. Build Report in Dataset Viewer

  1. Access Actions menu
  2. [Build Report] will automatically take you to a Viewer of the new Report after you name it. For more information on Dataset Reports, refer to Dataset Reports Overview.