Skip to main content

Trino Engine

This section explains how to create, configure, and test a Trino Engine data source in DataDios.

Steps to Create and Test a Trino Data Source​

Step 1: Create a Data Source​

  1. Navigate to the Data Sources tab in DataDios

  2. Click + CREATE DS

  3. From the list of available data source types, select Trino Engine

    Choose Trino

Step 2: Fill Connection Details​

In the Connection Details form, provide the required parameters:

  • Group: (Optional) Grouping for data sources
  • Host: Trino host or IP address
  • Port: Trino port (default: 8080)
  • User: Trino login username
  • Catalog: Catalog to connect to (comma separated catalogs if multiple)
  • Schema: Target schema (leave blank to use the default schema)
  • Is JMX enabled: Choose Yes if JMX monitoring is enabled on the Trino server and will be used for workload extraction
  • JMX Port: JMX port number (default: 9010)
  • Schedule Sync: Configure for metadata timeline synchronization (see Metadata Timeline)
    • JSON Structure
          {
             "group": "",
             "host": "",
             "port": "8080",
             "service_type": "",
             "user": "trino-user",
             "catalog": "mysql,postgresql",
             "schema": "",
             "object_types": "",
             "password": "Admin@123"
          }

Step 3: Test Connection​

  1. After entering details, click Test Connection

  2. Ensure the connection is validated successfully

    Validate Connection

Step 4: Save Data Source​

  1. If the test succeeds, click Create to save the data source
  2. You will be redirected to the Datasource Listing Page, where the Trino data source will appear

Step 5: Explore Data Source Items​

  1. Expand the Trino data source to view all items (catalogs, tables, views, etc.)

    List Items Trino

  2. To view metadata about any item:

    • Click the item name
    • Click the three stacked lines icon to open the Object Metadata pop-up

    Trino Metadata

  3. You can also explore additional features in the Metadata Explorer:

    • Object Data

      • View the actual data present in the selected resource (e.g., table rows or file details) Trino Objectdata

    • Graphs

      • Visualize dependencies and relationships across schemas
      • See how the item is connected to databases or other schema objects Trino Graph

  4. You can also use below additional features

    • Data Quality
      • Define and monitor data quality rules for the selected database object.
      • For detailed information, refer to the Data Quality documentation
    • Metadata Timeline
      • View changes over time for the selected database object
      • For detailed information, refer to the Metadata Timeline
    • AI Studio
      • Explore and query data using natural language with AI assistance
      • For detailed information, refer to the AI Studio documentation

Best Practices​

  1. Always Test Connection before saving to ensure configuration is correct
    2Organize with Groups for easier management of multiple Trino data sources
  2. Leverage Schedule Sync to keep metadata timelines updated