## Set up PrestoSQL

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

> Learn about set up prestosql.

:::warning

For Starburst Presto, we recommend using the [Trino connector](https://docs.atlan.com/llms/connectors/trino/set-up-trino/llms.txt) because [the official Starburst documentation recommends using the Trino JDBC driver](https://docs.starburst.io/latest/client/jdbc.html).

:::

:::warning Who can do this?
 You will probably need your Presto administrator to run these commands - you may not have access yourself.

:::

Atlan only supports PrestoSQL until version 349 - PrestoDB is not supported at present.

Currently, we only support basic (username and password) authentication for PrestoSQL. We recommend creating a separate user for Atlan with read-only access. Please ensure you are using frontend password authentication over HTTPS for clients.

## Create user in PrestoSQL

To create a new user with password file authentication follow [the steps in the official Presto documentation](https://prestodb.io/docs/current/security/password-file.html).

## Grant read-only access

To grant read-only access to the user created above follow [the steps in the official Presto documentation](https://prestodb.io/docs/current/security/built-in-system-access-control.html). This includes adding a list of catalogs you wish to crawl to your `rules.json` file, for example:

```json
{
 "catalogs": [
 {
 "user": "atlan",
 "catalog": "postgresql",
 "allow": "read-only"
 },
 {
 "user": "atlan",
 "catalog": "mysql",
 "allow": "read-only"
 },
 ...
 ]
}
```

---