| title | Starburst |
|---|---|
| description | Learn how to connect Metabase to your Starburst or Trino database, including connection settings, SSL configuration, and database sync options. |
This driver also works for connections to a Trino database.
To add a database connection, click the grid icon in the top right, and navigate to Admin > Databases > Add a database.
You can edit these settings at any time. Just remember to save your changes.
After connecting to a database, you'll see the "Connection and sync" section that displays the current connection status and options to manage your database connection.
Here you can sync the database schema and rescan field values, and edit connection details.
To access or modify your database connection settings, click the Edit connection details button.
Paste a connection string here to pre-fill the remaining fields below.
The display name for the database in the Metabase interface.
Your database's IP address (e.g., 98.137.149.56) or its domain name (e.g., name.database.com).
The database port (e.g., 8080).
Starburst catalogs contain schemas and reference data sources via a connector.
Only add tables that come from a specific schema.
The database username for the account that you want to use to connect to your database. You can set up multiple connections to the same database using different user accounts to connect to the same database, each with different sets of privileges.
The password for the username that you use to connect to the database.
See SSL certificates.
Specify a role to override the database user's default role.
Requires Starburst Galaxy, Starburst Enterprise (version 420-e or higher), or Trino (version 418 or higher).
You can append options to the JDBC connection string. Separate options with &, like so:
connection_timeout=1000&socket_timeout=300000
Turn this option OFF if people want to click Run (the play button) before applying any Summarize or filter selections.
By default, Metabase will execute a query as soon as you choose an grouping option from the Summarize menu or a filter condition from the drill-through menu. If your database is slow, you may want to disable re-running to avoid loading data on each click.
See syncs and scans.
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.
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.
Set up an additional connection used for write operations. See Writable connections.
There aren't (yet) any model features for Starburst.
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.
See Danger zone.