## Crawl PrestoSQL

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

> Once you have configured the [PrestoSQL user permissions](/apps/connectors/database/prestosql/how-tos/set-up-prestosql), you can establish a connection between Atlan and PrestoSQL.

Once you have configured the [PrestoSQL user permissions](https://docs.atlan.com/llms/connectors/prestosql/set-up-prestosql/llms.txt), you can establish a connection between Atlan and PrestoSQL.

:::info **Did you know?** 
 Atlan currently only supports PrestoSQL until version 349. PrestoDB is not supported at present.

:::

To crawl metadata from PrestoSQL, review the [order of operations](https://docs.atlan.com/llms/catalog/connector-capabilities/order-workflows/llms.txt) and then complete the following steps.

To select PrestoSQL as your source:

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 **PrestoSQL Assets** and select it.

4. Click **Install**.

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

## Provide credentials

To enter your PrestoSQL credentials:

1. For _Host_ enter the host for your PrestoSQL instance.

2. For _Port_ enter the port of your PrestoSQL instance.

3. For _Username_ enter the [name of the user you created](https://docs.atlan.com/llms/connectors/prestosql/set-up-prestosql/llms.txt).

4. For _Password_ enter the [password for the user you created](https://docs.atlan.com/llms/connectors/prestosql/set-up-prestosql/llms.txt).

5. Click **Test Authentication** to confirm connectivity to PrestoSQL using these details.

6. When successful, at the bottom of the screen click **Next**.

## Configure the connection

To complete the PrestoSQL connection configuration:

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

2. (Optional) To change the users able to manage this connection, change the users or groups listed under _Connection Admins_.

 :::warning

 If you do not specify any user or group, nobody will be able to manage the connection - not even admins.

 :::

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

## Configure the crawler

Before running the PrestoSQL crawler, you can further configure it.

You can override the defaults for any of these options:

- To select the PrestoSQL assets you want to exclude from crawling, click **Exclude Metadata**. (This will default to no assets if none are specified.)
- To select the PrestoSQL assets you want to include in crawling, click **Include Metadata**. (This will default to all assets, if none are specified.)
- To enable or disable schema-level filtering at source, click **Enable Source Level Filtering** and select the relevant option.

:::info **Did you know?** 
 If an asset appears in both the include and exclude filters, the exclude filter takes precedence.

:::

## Run the crawler

To run the PrestoSQL crawler, after completing the steps above:

1. To check for any [permissions or other configuration issues](https://docs.atlan.com/llms/connectors/prestosql/preflight-checks-for-prestosql/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 will see the assets in Atlan's asset page! 🎉

---