--- title: "Presto" description: "Connect Metabase to Presto, with every connection setting explained." url: "https://www.metabase.com/docs/latest/databases/connections/presto" version: "65" --- # Presto To add a database connection, click the **grid** icon in the top right, and navigate to **Admin** > **Databases** > **Add a database**. Fill out the fields for that database, and click **Save changes** at the bottom. ## Edit connection details You can edit these settings at any time. Just remember to save your changes. ### Connection string Paste a connection string here to pre-fill the remaining fields below. ### Display name The display name for the database in the Metabase interface. ### Host Your database's IP address, or its domain name (e.g., esc.mydatabase.com). ### Port The database port. E.g., 8080. ### Catalog Presto catalogs contain schemas and reference data sources via a connector. ### Schema (optional) Only add tables to Metabase that come from a specific schema. ### Username The username Metabase uses to connect to your database. Create a dedicated database user for Metabase with read-only access to the schemas and tables you want to analyze. For write operations like uploads, actions, or transforms, use a separate [writable connection](https://www.metabase.com/docs/latest/databases/writable-connection.md). For instructions, see [Database users, roles, and privileges](https://www.metabase.com/docs/latest/databases/users-roles-privileges.md). You can set up multiple connections to the same database using different user accounts, each with different sets of privileges. ### Password The password for the username that you use to connect to the database. ### Use a secure connection (SSL) Metabase automatically tries to connect to databases with SSL first, then without if that doesn't work. If it's possible to connect to your database with an SSL connection, Metabase will make that the default setting for your database. If you prefer to connect without this layer of security, you can always change this setting later, but we recommend keeping SSL turned on to keep your data secure. ### Use SSL certificate? Metabase supports both keystores and truststores. #### Keystore You can specify a local file path, or upload a keystore. You'll also need to input your keystore password. #### Truststore You can specify a local file path, or upload a truststore. You'll also need to input your truststore password. ### Authenticate with Kerberos Kerberos settings include: - Kerberos principal (e.g., `service/instance@REALM`) - Kerberos coordinator service (e.g., `presto`) - You can use a canonical hostname. - Kerberos credential cache file (e.g., `/tmp/kerbo-credential-cache`) - Kerberos keytab file (e.g., `/path/to/kerberos.keytab`) - Kerberos configuration file (e.g., `/etc/krb5.conf`) - Presto coordinator Kerberos service principal pattern (e.g., `${SERVICE}@${HOST}.${SERVICE}`) ### Additional JDBC connection string options You can append options to the connection string that Metabase uses to connect to your database. ### Re-run queries for simple explorations Turn this option **OFF** if people want to click **Run** (the play button) before applying any [Summarize](https://www.metabase.com/docs/latest/questions/query-builder/summarizing-and-grouping.md) or filter selections. By default, Metabase will execute a query as soon as you choose a grouping option from the **Summarize** menu or a filter condition from the [drill-through menu](https://www.metabase.com/docs/latest/questions/visualizations/drill-through.md). If your database is slow, you may want to disable re-running to avoid loading data on each click. ### Choose when syncs and scans happen See [syncs and scans](https://www.metabase.com/docs/latest/databases/sync-scan.md#choose-when-syncs-and-scans-happen). ### Periodically refingerprint tables > Periodic refingerprinting will increase the load on your database. Turn this option **ON** to scan a sample of values every time Metabase runs a [sync](https://www.metabase.com/docs/latest/databases/sync-scan.md#how-database-syncs-work). A fingerprinting query examines the first 10,000 rows from each column and uses that data to guesstimate how many unique values each column has, what the minimum and maximum values are for numeric and timestamp columns, and so on. If you leave this option **OFF**, Metabase will only fingerprint your columns once during setup. ## Writable connection Set up an additional connection used for write operations. See [Writable connections](https://www.metabase.com/docs/latest/databases/writable-connection.md). ## Database routing With database routing, an admin can build a question once using one database (data catalog), and the question will run its query against a different data catalog with the same schema depending on who is viewing the question. See [Database routing](https://www.metabase.com/docs/latest/permissions/database-routing.md). ## Danger zone See [Danger zone](https://www.metabase.com/docs/latest/databases/danger-zone.md). ## Further reading - [Managing databases](https://www.metabase.com/docs/latest/databases/connecting.md) - [Metadata editing](https://www.metabase.com/docs/latest/data-modeling/metadata/metadata-editing.md) - [Models](https://www.metabase.com/docs/latest/data-modeling/models/models.md) - [Setting data access permissions](https://www.metabase.com/docs/latest/permissions/data.md)