## Crawl Trino

URL: https://docs.atlan.com/apps/connectors/database/trino/how-tos/crawl-trino

> Crawl metadata from Trino to catalog schemas, tables, views, and columns. Extract distributed query lineage and asset information after configuring user permissions.

Crawl metadata from [Trino](https://docs.atlan.com/llms/connectors/trino/set-up-trino/llms.txt) to automatically discover and catalog your data assets in Atlan. After completing the prerequisite setup, you can import schemas, tables, views, and column information, making your Trino data searchable and governable. If you use [private network access](https://docs.atlan.com/llms/connectors/trino/set-up-a-private-network-link-to-trino/llms.txt), complete that setup first. Review the [order of operations](https://docs.atlan.com/llms/catalog/connector-capabilities/order-workflows/llms.txt) for metadata enrichment workflows before starting.

## Prerequisites

Before you begin, make sure you have:
* Configured [Trino user permissions](https://docs.atlan.com/llms/connectors/trino/set-up-trino/llms.txt)
* Set up [private network access](https://docs.atlan.com/llms/connectors/trino/set-up-a-private-network-link-to-trino/llms.txt) (if using a private network)
* Reviewed the [order of operations](https://docs.atlan.com/llms/catalog/connector-capabilities/order-workflows/llms.txt) for connection workflows
* Obtained your Trino host, port, and authentication credentials

## Create crawler workflow

Follow these steps to create a workflow for Trino:

1. In your Atlan workspace, click **Connectors** in the left sidebar.
 * If you are using the **Old UI (Classic)**, click **New Workflow** in the top navigation.

2. Click **Marketplace**.

3. Search for **Trino Assets** and select it.

4. Click **Install**.

5. Once installation completes, click **Setup Workflow** on the same tile.

### Configure authentication

Choose your extraction method:

* In **Direct** extraction, Atlan connects to your database and crawls metadata directly.
* In **Agent** extraction, Atlan's secure agent executes metadata extraction within your organization's environment.

### Direct extraction

Configure your Trino authentication:

1. For **Host**, enter the hostname (or [PrivateLink endpoint](https://docs.atlan.com/llms/connectors/trino/set-up-a-private-network-link-to-trino/llms.txt)) for your Trino instance.

2. For **Port**, enter the port of your Trino instance.

3. For **Authentication Method**, select either **Basic** or **JWT**:

 * **Basic**: Enter your username and password credentials:
 * For **Username**, enter the [username you created](https://docs.atlan.com/llms/connectors/trino/set-up-trino/llms.txt).
 * For **Password**, enter the [password for the user you created](https://docs.atlan.com/llms/connectors/trino/set-up-trino/llms.txt).

 * **JWT**: Enter your JWT access token.
4. For **Enable TLS/HTTPS**, change to **True** to only enable TLS or HTTPS connections or keep the default **False**.

5. For **Disable SSL verification**, change to **True** to disable SSL verification for self-signed certificates or keep the default **False**.

6. Click **Test Authentication** to confirm connectivity to Trino using these details.

7. Once successful, at the bottom of the screen click **Next**.

### Agent extraction

Atlan supports using a Secure Agent for fetching metadata from Trino. To use a Secure Agent:

1. Select the **Agent** tab.

2. Configure the Trino data source by adding the secret keys for your secret store. For details on the required fields, refer to the [Direct extraction](#configure-authentication) section.

3. Complete the Secure Agent configuration by following the instructions in the [How to configure Secure Agent for workflow execution](https://docs.atlan.com/llms/platform/secure-agent/configure-secure-agent-for-workflow-execution/llms.txt) guide.

4. Click **Next** after completing the configuration.

### Configure connection

Set up your Trino connection name and define who can manage this connection in Atlan:

1. Provide a **Connection Name** that represents your source environment. For example, you might use values like `production`, `development`, `gold`, or `analytics`.

2. To change the users able to manage this connection, change the users or groups listed under **Connection Admins**. If you don't specify any user or group, nobody can manage the connection—not even admins.

3. At the bottom of the screen, click **Next** to proceed.

### Configure crawler

Customize the crawler settings. If an asset appears in both the include and exclude filters, the exclude filter takes precedence.

* To select the Trino assets you want to exclude from crawling, click **Exclude Metadata**. This defaults to no assets if none are specified.
* To select the Trino assets you want to include in crawling, click **Include Metadata**. This defaults to all assets if none are specified.
* For **Advanced Config**, keep **Default** for the default configuration or click **Custom** to configure the crawler:
 * For **Enable Source Level Filtering**, click **True** to enable schema-level filtering at source or click **False** to disable it.
 * For **Use JDBC Internal Methods**, click **True** to enable JDBC internal methods for data extraction or click **False** to disable it.

### Run crawler

Execute the crawler workflow:

1. To check for any [permissions or other configuration issues](https://docs.atlan.com/llms/connectors/trino/preflight-checks-for-trino/llms.txt) before running the crawler, click **Preflight checks**.

2. You can either:
 * To run the crawler once immediately, at the bottom of the screen, click the **Run** button.
 * To schedule the crawler to run hourly, daily, weekly, or monthly, at the bottom of the screen, click the **Schedule Run** button.

Once the crawler has completed running, you can see the assets in Atlan's asset page.

## Troubleshooting

If you encounter connection or authentication issues during the crawl, see [Troubleshooting Trino connectivity](https://docs.atlan.com/llms/connectors/trino/troubleshooting-trino-connectivity/llms.txt).

## See also

* [What does Atlan crawl from Trino?](https://docs.atlan.com/llms/connectors/trino/what-does-atlan-crawl-from-trino/llms.txt): Learn about the metadata and assets that Atlan extracts from Trino.

---