Advanced Metabase features for data analysts

Set up alerts, annotate charts with events, model data, templatize SQL queries, customize click behavior, and more.

Get notified when results cross a goal line

You can set up an alert on a question so that Metabase will send you an email or Slack message when the question returns results that cross a goal line. You can also send the results to a webhook. Set up an alert

Share dashboard results via email and Slack

Set up a dashboard subscription to send the results of a dashboard via email or Slack. On Pro and Enterprise plans, you can filter results for different groups.

Dashboard subscription

Make data easier to query with models

You can create models to clean up messy raw data and make it easier for people to ask questions.

Speed up loading times by caching results

You can store the results of questions so Metabase can return them much faster. Check out:

Customize what happens when people click on dashboard charts

Questions built with the query builder get the drill-through menu built into their charts. But you can change what happens when people click on dashboard cards. Customizing click behavior is especially useful for adding functionality to questions written in SQL. You can:

  • Send people to a custom destination (like another dashboard, or to an external URL).
  • Open up the drill-through menu.
  • Update a value in a dashboard filter.

Click behavior options

Check out Interactive dashboards.

Annotate charts with events and timelines

You can add events on time series. You can use events to mark dates where something happened: an email campaign or outage or office party that got out of hand. You can group events into timelines to keep related events together. Events are useful for explaining spikes in the data, so you don’t have to answer for the umpteenth time why sales went way up in April.

Event on Metabase chart

SQL templates

Insert variables into your SQL and Metabase will create a filter widget for you. Also: check out field filters that create “smart” filters, with dropdown lists or date ranges.

SQL template

You can also save bits of SQL to reuse in other queries. Check out SQL snippets.

X-ray models, tables, charts, and more

Visit a model or table, hit a button, receive charts. You can save these auto-generated charts as a dashboard, or just use any of the charts as starting points to find the answers you’re looking for. Check out X-rays.

X-ray this table

Index models so you can search for individual records

When you’re editing metadata for a column in a model, you’ll see a toggle called Surface individual records in search by matching against this column. If you flip this toggle on, people will be able to search in Metabase for those records. If, for example, the field contains a list of customer names, you can index that column so that people can just search for customer names in the Metabase search bar. You can also X-ray.

Indexed records show up in search

Check out the docs for indexing fields on a model.

Upload CSVs for ad hoc exploration

Instead of tinkering with a spreadsheet, upload a CSV to Metabase and query the data with the query builder, the SQL editor, or even X-ray it.

Upload a CSV to a collection in Metabase

Export results and dashboards

You can download the results of a question as .json, .csv, .png, or .xlsx files, or export a dashboard as a PDF.

And a bunch of other stuff

Metabase is designed to be simple and intuitive, but it has a lot of depth. Consider spending way too much time reading our docs and Learn articles.

Next: Beyond BI: other problems you can solve with Metabase

Use Metabase as a database browser, or a publishing platform, or a lookup tool, or a quick business intelligence tool, or as just a way to field frequently asked questions.

Next article