Metabase v0.45.0-RC3
Pre-releaseHere's an incomplete list of all of the improvements that we’ll be shipping in Metabase 45. We'll go into more detail in our official release post; this list is just a brief summary for those of you helping us test out the release candidate.
NOTE: Metabase 0.45 is NOT backwards compatible.
Visualizations
- Better static charts: We've put a lot more work into making the charts that your Metabase sends in email or Slack look like they do when you view them in your Metabase. Plus now you can get gauge charts via email and Slack.
- Line, area, bar, and combo charts now have better legends. Labels are above the charts, and they're laid out in rows.
- Row charts are now real. They actually work. We gave them the same feature set as bar charts, rotated 90 degrees, which was actually harder to pull off than you might think. You have to see it to believe it.
- You can now reorder series. Which is a pretty big deal, especially if you want to do things like change up the order of steps in a funnel chart.
- Pie charts can now show labels inside the pie. Though by “pie” we really mean donut.
Models
Models in Metabase had a bit of a rough landing, but since they're such a fundamental building block for a healthy data culture, we did a ton of work to make models easier and more reliable to work with. Plus, we added some new features.
- You can create a model from the + New menu (as well as from an existing saved question)
- Models retain their metadata, even when you change the model’s underlying query
- You’ll get faster results for SQL questions built on top of persisted models. When joining against a persisted model in a native query, Metabase will, if possible, use the model's cached results to return results faster.
- Models are easier to reference in SQL questions.
New datetime functions for custom expressions
We added a bunch of new functions for dealing with dates in the query builder:
second
,minute
,hour
,day
,week
,month
,quarter
,year
functions for extracting bits of a timestamp. See the full [list of expressions](https://www.metabase.com/docs/latest/questions/query-builder/expressions-list).datetimeAdd
anddatetimeSubtract
functions so you can "math" dates.
Native editor and data reference upgrades
- We cleaned up the data reference sidebar in the native editor, and made it easier to search for models and questions to reference in your SQL questions. Just start typing
{{#
and Metabase will prompt you with models as you type. - We added CTRL + F search to the native editor to find specific code in larger queries.
Better tables in the sample database
For now, these new tables are hidden by default, but admins can unhide them by clicking on the gear icon > Admin settings > Data Model > Sample Database.
Deep copy dashboards
Metabase now supports deep copying of dashboards. You can choose either to copy the dashboard and all of its questions, or just the dashboard (which will refer to the original questions).
Full changelog
Enhancements
- [Epic] Let users know why there’s no drill-through on their SQL/native questions (#26565)
- Record application database version in Snowplow metrics (#26329)
- Serdes v2: it should be possible to load content to an instance without the serialized data model (if the target instance already contains the data model) (#26163)
- [Epic] metabase-lib consolidation (#25618)
- Add journey to create fresh Model using New button (#25602)
- Add page to create Model without a Question using Native Query Editor (#25600)
- Add page to create Model without a Question using Notebook Editor (#25598)
- Revamped row chart (#25408)
- [Epic] Make it clearer how to connect a SQL question to a dashboard filter (#25307)
Bug fixes
- In Mongo, the filter does not work for uuid fields (#26310)
- Sync of new tables stops working if an existing table has a description set to empty (not null) (#26268)
- BigQuery Arrays are not exported correctly to CSV (#26261)
- Changing permissions can fail with
Data too long for column 'before' at row 1
when using MySQL/MariaDB application database (#26212) - Serdes v2 is not transferring
report_card.result_metadata
on models (#26150) - Model list appears empty when creating new question, even though models exist (#26091)
- Click Behavior not working for Funnel (#26051)
- Modal filtering doesn't work on joined table when Question has a filter after aggregation (#25990)
- Reordering columns in pivot tables breaks the UI (#25785)
- Dashboard Slack Subscription hits slack API max characters allowed per block (#25704)
- Notify endpoint will always return 200 even if the tables don't exist (#25627)
- Data Model keeps resetting input fields while editing (#25570)
- Persistent caching for Models fails to enable for MySQL (#25552)
- Referencing a model in a SQL query won't use the persisted model (#25516)
- When using Date Filters and setting up relative dates "starting from" the range specified provides inconsistent results. (#25481)
- Recent item in search has label of
Dataset
instead ofModel
(#25447) - Blank Model metadata sidebar (#25437)
- "Week" aggregation is inconsistent with setting "Start-of-the-week: Monday" (#25356)
- Between Filter does not always stay within window (#25185)
- our schema identifies fields by
id
alone, so the fields on virtual card tables get clobbered by the fields from concrete tables (#25141) - Incorrect last-X-weeks/months/years calculation on BigQuery (#25080)
Upgrading
You can download a .jar of the release, or get the latest on Docker. Make sure to back up your Metabase
database before you upgrade! Need help? Check out our
upgrading instructions.
Docker image: metabase/metabase:v0.45.0-RC3
Download the JAR here: https://downloads.metabase.com/v0.45.0-RC3/metabase.jar
Notes
SHA-256 checksum for the 0.45.0-RC3 JAR:
fcc6ef896edad02fe8a0f79a9f88abdaa15b7c71e98c54f42d4ee1ff6d87db15