The connector for PrestoSQL Trino allows data sources connected to PrestoSQL Trino to be cataloged, queried, transformed and more. This can be used to quickly and easily join data between different systems.

The PrestoSQL Trino connector is available for all Promethium editions, including Free, Professional, Premium and Enterprise.

Note, PrestoSQL was renamed Trino in December 2020.

Connect PrestoSQL Trino

Connecting to PrestoSQL Trino is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Presto and enter the information for your PrestoSQL Trino.

PrestoSQL Trino Connection

PrestoSQL Trino connection details can be case sensitive. Ensure that data is entered with the correct case for your PrestoSQL Trino.

Field

Description

Data Source Name

Give the PrestoSQL Trino connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Host Name

Enter the host name for your PrestoSQL Trino database. For example: db.company.com

DB Port

Enter the port number for your PrestoSQL Trino.

User Name

Enter the username associated with your PrestoSQL Trino account.

Password

Enter the password associated with your PostgreSQL account.

Catalog Name

Enter the PrestoSQL Trino catalog name.

Schema Name

Enter the PrestoSQL Trino schema name.

What Happens Next - Finish PrestoSQL Trino Connection

Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your PrestoSQL Trino, then make the data easily searchable and usable.

Click Data Explorer from the menu and begin exploring the data in your PrestoSQL Trino.

PrestoSQL Trino Data Catalog Promethium

FAQs

  • Is my data moved or copied?

    No. Your data stays where it is and isn't moved to Promethium.

  • What options are available for publishing datasets?

    Datasets can be published as a view, as a table or as a dbt model.

  • Is this a Production-level connector?

    Yes. The PrestoSQL Trino connector is designed for all-sized Datasets.

Watch how to video

Did this answer your question?