| title | Druid |
|---|
Prefer the Druid JDBC connection.
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. You can edit these settings at any time. Just remember to save your changes.
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, or its domain name (e.g., esc.mydatabase.com).
The database port (e.g, 8082).
See our guide to SSH tunneling.
Only available for the Druid JDBC connection.
This enables unfolding of JSON columns into their component fields.
See JSON unfolding.
Only available for the Druid JDBC connection.
Toggle on to enable basic authentication with a username and password.
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 available for Druid.
With database routing, an admin can build a question once using one database, and the question will run its query against a different database with the same schema depending on who is viewing the question.
See Database routing.
See Danger Zone.