Skip to main content

Trino

To add a Trino connection, click on the Trino option in Connect a data source section. connect

Connect​

Fill in the connection settings: trino

Connecting from a local Trino database

For MacOS and Windows users connecting from a local Trino database, simply use host.docker.internal as the host to establish the connection.

Display name​

The display name for the database in the Wren AI interface.

Host​

Your Trino database's IP address or domain name.

Port​

Your Trino database port.

Catalog​

The catalog of the Trino database you want to connect to.

Schema​

The schema of the Trino database you want to connect to.

Username​

The database username for the account that you want to use to connect to your Trino database.

Password​

The password for the username that you use to connect to the database.

Click Next to start connection and go to the next step.

Select Tables​

All tables of your connected Trino database will be listed in this step. Select which tables you want to use in Wren AI. Each selected table will be created as a data model. See the Modeling documentations to learn more about what is data models. select_table

Define relationships​

Define the relationships among selected tables in this step. You can defined relationships by clicking the Add relationships button on the table blocks. relationship

Define following properties in a relationship:

  • From: Select the left side table and column of this relationship.
  • To: Select the right side table and column of this relationship.
  • Relationship Type: Select the type of relationship. add_relationship

Find more information about relationship in Modeling - Working with Relationships

You can also skip this step and finish connection and define relationships later.