New features and improvements
SQL/native query snippets
You can now save bits of SQL or native queries and refer to them in your 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.
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.
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.
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.
Other enhancements
- Added a hide-all-tables / show-all-tables button for databases in the Data Model
- Added support for SSH keys
- Added support for connection URIs for MongoDB and JDBC databases
- Added support for BigQuery Service Accounts (#4634)
- Jetty request header size is now configurable (#12683)
- You can now link dashboard filters to Custom questions with filtered aggregate data (#11007)
Bug fixes
- Input box disappeared on date Filter UI (#12750)
- Download not working on revoking raw sql query access (#12745)
- Setup has duplicate step numbers (#12742)
- Sync DB schema loses manual schema config (#12680)
- Documentation links in app not correct (#12615)
- Sanitize field names better (#12592)
- Query fails on "Error reducing result rows" on cumulative aggregations with null-values (#12585)
- Can't use "Sum over time" or "Distribution" with nested question (#12568)
- Creating a dashboard with a nested query Card can result in all dashboards being broken until hard refreshing (#12518)
- Homepage is missing sections (X-rays and Our data) after setup (#12510)
- viewing Card with another Card as source query gets stuck on loading spinner forever (#12501)
- Drill-through is broken on nested question on dashboard (#12455)
- Visualization type gets reset to "Table" (different scenarios) (#12361)
- Some users don't have permission to view query with a subquery, but can view the subquery directly (#12354)
- java.lang.ClassCastException: class java.time.Instant cannot be cast to class java.time.chrono.ChronoLocalDateTime (#12311)
- "Custom Column" with a
/(slashes) in name will fail the query (#12305) - Dashboard filter dropdown not working when linked to question joined table (#12250)
- unexpected change of visual and entering editor mode for question on change of date time filter of a saved question (#12014)
- Native question will reset visualization to Table unless there's data from the beginning (#11960)
- Druid: allow filtering on metrics (#11823)
- Drill-through is broken on nested question (#11807)
- Visualization type cannot be saved when is only one result (#11675)
- Missing Translation at modal on new user at question (#11504)
- Editor screen jumps to top when unselecting the columns where list exceeds screen height (#11202)
- Can't view nested saved questions without data access permissions (#11028)
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.36.0-rc2
Download the JAR here: https://downloads.metabase.com/v0.36.0-rc2/metabase.jar
Notes
SHA-256 checksum for the 0.36.0-rc2 JAR:
26972cbad6dc7c09d293c3893cdfe7a56576cba28290cd1011bace9be9c7322e