Skip to content

Metabase v0.38.0
Compare
Choose a tag to compare
@camsaul camsaul released this 17 Feb 00:29
· 131 commits to release-x.38.x since this release
v0.38.0
471aa51
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

Metabase v0.38

Pivot tables

At long last, Metabase now has honest-to-goodness pivot tables, with multiple levels of grouping and pivots, subtotals and grand totals, and collapsing and expanding rows. Tell your Finance team. Learn more.

pivot-table-options

Dashboard subscriptions

In the past, if you worked hard to create a beautiful dashboard and then wanted to send that dashboard out to folks regularly, you'd have to go create a "Pulse" in Metabase and manually add each and every question from that dashboard to it.

But in version 0.38 we've introduced dashboard subscriptions, which allow you to send the entire contents of a dashboard via email or Slack. You can set up as many subscriptions on a dashboard as you like, and any changes you make to your dashboard will be reflected in your subscriptions the next time they're delivered.

Because we've gotten plenty of demand for and positive feedback on dashboard subscription, we'll be gradually phasing out Pulses in favor of dashboard subscriptions. Pulses will continue to work as normal in 0.38, but in a future release we'll be removing them for good, while giving you a way to migrate any remaining Pulses you might have. You can learn how to use dashboard subscriptions here.

dashboard-subscription-options

Waterfall charts

We've added this new chart type which can be quite useful when you're trying to show decreases or losses along with increases or gains across a set of categories or a span of time. Those folks in Finance are having a real banner day, aren't they? More info here.

waterfall-chart

A new layout for collections

We've taken a crack at making it easier for you to navigate through large sets of nested collections. When you go to a collection now, you'll see a persistent sidebar on the left that allows you to rapidly explore the structure of collections and check out their contents. We've also given collections a new coat of paint — hopefully they look a bit lighter and brighter to you now.

collections-sidebar

Redesigned actions and drill-through menus

Another part of the app to receive a touch up is the menus that pop open when you click on charts or column headings. All the same functionality remains, just in a more approachable, friendly package.

action-menu

Improved nested queries and data sandboxes

The code that powers these two features has been hardened to improve stability and make sure that nested queries, as well as the Enterprise Edition's data sandboxes, let you use all the Metabase features and functionality they're meant to. You can see the full list of issues and bugs that we closed related to these features below.

For third-party drivers

Metabase 0.38.0 has made several changes to the driver interface in 0.38.0; several deprecated methods have been removed entirely. See this wiki page for the complete list of changes driver authors should be aware of.

Full list of enhancements

  • Pivot tables (#8572)
  • Waterfall charts (#11904)
  • Dashboard subscriptions (#13671)
  • Collections Redesign Implementation (#13660)
  • Restyled drill-through and actions popover (#13695)
  • Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
  • Add timeouts for both configurations (#13568)
  • Add Swiss number formatting (Localization - Separator Style) (#13348)
  • Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
  • Don't set Site URL on requests from ELB HealthChecker (#12996)
  • Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
  • Docker image can not run as non-root (#9861)
  • Add option to disable user ID/hash remark added to every SQL question (#8539)
  • Add field descriptions to lists of fields in the Data Reference (#6316) — thanks to @rthouvenin!
  • Support unix timestamps in microseconds (µs) (#1889)
  • Add Special Type: DateTime String (ISO) (#1576)
  • Write a smarter linter for our Liquibase migrations YAML file (#14092)
  • Add a lightweight notify api endpoint (#14634)
  • Allow usage of PKCS-12 certificates with Postgres connections (#14626)
  • add cmd rotate-encryption-key (#14552)
  • fix(rotate-encryption-key) settings-last-updated is not encrypted (#14769)
  • Login page should automatically focus on the email input field (#14505)
  • Allow minutes and hours for dashboard relative date filter (#14512)

Bug fixes

  • Datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
  • Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
  • On startup sync, application says refingerprinting rather than fingerprinting (#14411)
  • startup logging of database changes has null values in logs (#14409)
  • "Automatically run queries" setting should default to ON when adding a new database (#14334)
  • on startup sync, application says refingerprinting rather than fingerprinting (#14411)
  • Startup logging of database changes has null values in logs (#14409)
  • "Automatically run queries" setting should default to ON when adding a new database (#14334)
  • Moved collections not being correctly included in api/collection/tree API response (#14280)
  • Subcollection permissions not working right in sidebar on master (#14114)
  • Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
  • Custom GeoJSON files are not sorted in the dropdown (#14696)
  • user@password JDBC connection strings for application DB no longer work (#14678)
  • Shrunken bubbles shown in question for null values (#14662)
  • Drilling down by a Region Map assigns the wrong value to the filter (#14650)
  • Using "Reset to defaults" on textbox causes it to become a corrupted card on dashboard (#14644)
  • Sandboxing on tables with remapped FK (Display Values) causes query to fail (#14629)
  • dump-to-h2 does not return a non-zero exit code on failure (#14614)
  • Bar chart x-axis positions can cause different spacing depending on the dates returned (#14605)
  • dump-to-h2 with --dump-plaintext should check for presence of MB_ENCRYPTION_SECRET_KEY (#14588)
  • Token check retry is too aggressive (#14514)
  • Click Behavior with cross-filter sometimes does not list column options (#14473)
  • Sandboxed question with case Custom Field doesn't substitute the "else" argument's table (#14859)
  • Custom Expression using case() function fails when referencing the same column names (#14854)
  • Filtering a Custom Column does not give correct results when using "Not equal to" (#14843)
  • Cannot remove columns via QB sidebar, then query fails, but works if being removed via Notebook (#14841)
  • Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
  • Advanced Sandboxing using questions that return more/other columns than the sandboxed table is not possible anymore, but the errors are not helpful (#14612)

Upgrading

Note: Upgrading instances that use a PostgreSQL SSL connection with custom CA certificates may require an extra step.

If your Metabase:

  1. is connected to a PostgreSQL database or uses PostgreSQL as its application database, and
  2. uses SSL with custom CA certificates
    You may need to resolve an issue with SSL certificate validation. You can find details on what to do here.

How to upgrade

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.38.0
Download the JAR here: https://downloads.metabase.com/v0.38.0/metabase.jar

Notes

SHA-256 checksum for the 0.38.0 JAR:

174a5204b65dd9738c6e959eb205d7d9ed746c72c0d0d7023330b7c398900e9c
Assets 2