These are the docs for the Metabase master branch. Some features documented here may not yet be available in the latest release. Check out the docs for the latest version, Metabase v0.54.
Druid
Prefer the Druid JDBC connection.
To add a database connection, click on the gear icon in the top right, and navigate to Admin settings > Databases > Add a database.
Edit connection details
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.
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).
Broker node port
The database port (e.g, 8082).
Use an SSH tunnel
See our guide to SSH tunneling.
Allow unfolding of JSON columns
Only available for the Druid JDBC connection.
This enables unfolding of JSON columns into their component fields.
See JSON unfolding.
Authentication
Only available for the Druid JDBC connection.
Toggle on to enable basic authentication with a username and password.
Re-run queries for simple explorations
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.
Choose when syncs and scans happen
See syncs and scans.
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.
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.
Model features
There aren’t (yet) any model features available for Druid.
Danger zone
See Danger Zone.
Further reading
Read docs for other versions of Metabase.