Trino - Latitude Docs

Install

Run the following command to install the connector from the root of your project:

npm install --save @latitude-data/trino-connector

The sources files must be inside the queries/ folder.

To know how the source hierarchy works, please, visit How to configure sources.

To configure the connection with your Trino database follow these steps:

Create the source `.yaml` file within the `queries` folder if you haven't already

/queries/source.yml

Add the following code for your Trino connection

type: trino 
details: 
  server: string
  catalog?: string
  schema?: string
  username: string
  password?: string

Replace the details section with your info and save

Done, now you can test your connection

Server → The unique identifier for your Trino account. This is a full url. Example: http://localhost:8080
Username → The Trino username
Password → (Optional) The user’s password
Catalog → (Optional) The catalog
Schema → (Optional) The db schema

To test the connection you can:

Create a query .sql in the queries directory that points to a table of your new connection in the FROM clause. See the section SQL Syntax Basics to learn more.
Use the command line to run latitude run query_file_name where query_file_name is the name of your .sql file. This will display the results in your terminal. See the section Running queries to learn more about how to query your data.