SQL snippets, localization

Metabase version 0.36 marks another big release from the Metabase team, with help as always from our contributors and the community.

If you’re ready to get going, you can start with our upgrade guide, or read on to learn what’s new.

New features and improvements

SQL snippets in the native query builder

You can now save bits of SQL and refer to them in your SQL editor queries via a tag, like {{ snippet: My Great Snippet }}. Updating the definition of a snippet will update every query that uses that snippet. Just click the icon with the three lines in the native query editor to open up the SQL snippets sidebar.

Any user with SQL editor permissions for at least one database can use, create, and edit snippets.

We’ll discuss snippets in more detail in an upcoming blog post, so stay tuned. In the meantime, you can check out the documentation on snippets.

Language selection

Instead of changing the language in the UI for each user based on their browser’s language settings, Metabase now lets admins pick the language for the instance on the Localization tab of the Settings page in the Admin Panel. Users can also change their personal language preferences from their Account Settings page.

Better value labels for line, area, bar, and combo charts

You can now turn on value labels for charts with multiple series, and selectively turn labels on or off for individual series.

A reorganized Data Model section

We’ve moved things around a bit in the Data Model section: there are now tabs at the top to see all of the Segments and Metrics you’ve defined across your whole instance, so you no longer need to drill down through your tables to find a Segment or Metric.

Reorderable table columns in the Data Model

You can now change the default order for table columns, and choose between database order, alphabetical, custom order, or the old “smart” ordering. You can also click and drag on columns to reorder them manually.

Improvements and bugs fixes

See the release notes for a list of all the improvements we made (and all the bugs we squashed).

Thanks to all who submitted issues, pull requests, and suggestions: you are a big part of why Metabase continues to get better and better.

Stay healthy and safe, everyone, and enjoy the new release!

Cheers,

The Metabase team