Skip to main content

Trino & Starburst

plan support

Included in all plans

IP Whitelist

Wren AI needs to access your Trino database via the IP address of the outbound IP of Wren AI Cloud. Please add the IP address of the Wren AI service to the firewall of your Trino database.

Scroll to the bottom of the data source connection page to find the IP address.

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

Connect​

Fill in the connection settings: trino

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.

Schemas​

Specify the catalogs and schemas of the Trino data source you wish to connect to. Enter a comma-separated list in the format catalogA.schemaA, catalogB.schemaB.

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.

Connecting to Starburst managed Trino instances​

Find your Starburst cluster connection details​

  1. Click Partner connect at side bar. partner_connect
  2. Select Ibis: Since Wren AI use ibis under the hood to connect to Trino, you could select Ibis to find connection details. select_ibis
  3. Copy the connection details. connection_detail

Connect to Starburst on Wren AI Cloud​

  1. The connection steps are the same as for Trino. Copy the connection details and paste them into Wren AI. connection_example

    For this example, we connect to the sample.burstbank schema.

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.