# Trino

{% content-ref url="/pages/CeVOGyvadgbMqxDySGSM" %}
[Trino Metadata Extracted](/integrations/query-engines/trino/trino-metadata-extracted.md)
{% endcontent-ref %}

## Get Started With Trino

There are three steps to connect Trino with Secoda:

1. Create a Trino User
2. Connect Trino to Secoda
3. Whitelist Secoda IP Address

#### **Create a Trino User**

Depending on your setup, this could be through LDAP, a file-based system, etc. For the purpose of this guide, we'll assume you're using a file-based system for simplicity, but we will also provide instructions for setting up JWT authentication.

* **For File-based Authentication:**
  * Edit the user file (e.g., etc/password) to include a new user entry for Secoda.
  * Add a line like `secoda:<password>` in the file, replacing `<password>` with a strong password.
  * Ensure that this user has the necessary permissions to access the data in Trino.
* **For JWT Authentication:**
  * You will need to configure Trino to accept JWT for authentication. This involves setting up a JWT provider and configuring Trino to validate JWT tokens against your provider.
  * Generate a JWT token that includes a claim identifying the user as Secoda. The exact claim required will depend on your Trino configuration.
  * Ensure that the JWT token grants the necessary permissions for Secoda to access the data in Trino.

#### **(Optional) Query History Config**

If you store the query history from Trino in a table, you can specify the location of this query history table and the relevant columns. Copy the following JSON and replace the values with your configuration. Use this in the **Query History Config** field on your Trino integration.

```json
{
  "query_table": "prod.analytics.query_history",
  "start_time_column": "start_time", 
  "end_time_column": "end_time",
  "query_column": "query_text",
  "user_column": "user"
}
```

{% hint style="info" %}
The `query_table` must be the full path, i.e, database.schema.table.

The `user_column` in your `query_table` should contain emails as the value. This is not a requirement.
{% endhint %}

#### **Connect Trino to Secoda**

After creating a Trino user, the next step is to connect Trino to Secoda:

1. In the Secoda App, navigate to the 'Integrations' tab.
2. Click on ‘Add Integration’.
3. Search for and select ‘Trino’.
4. Enter the details for your Trino environment, including the username and password or JWT token for the user you created.
5. Click 'Connect'.

#### **Whitelist Secoda IP Address**

For Secoda to access your Trino environment, you may need to whitelist its IP address. This process will vary depending on your network setup and where your Trino environment is hosted. Generally, you will need to update your firewall or network security group rules to allow incoming connections from Secoda’s IP address to your Trino cluster.

Remember to follow your organization's security policies and best practices when configuring these settings.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.secoda.co/integrations/query-engines/trino.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.