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

• Managing databases
• Metadata editing
• Models
• Setting data access permissions