Metabase v0.39

Metabase 0.39 brings better search, improved custom expressions, and custom filter values for the Enterprise Edition, and ships with a boatload of other polish and improvements. Hope you enjoy!

Finding questions and dashboards just got a lot easier

The big news for 0.39 is our much-improved search: we've added typeahead, fuzzy search, and more.

Searches now take into account items' titles, as well as their metadata (like their descriptions). You can even search the contents of your SQL queries. That's right: you can search for things like SELECT escape_pod FROM mothership and find that one question you worked on six months ago. We've also made it easier to tell which item is the one you're looking for: you can now see an item's description, which collection it's saved in, what kind of object it is, and whether it's pinned.

Improved custom expressions

We've polished custom expressions to make it easier to ask more sophisticated questions. We've also included two new functions: isempty for checking for empty strings, and isnull for checking for null values.

More improvements throughout

You can now connect to Oracle databases over SSL, use a PEM file to connect to a MySQL database over SSL, and configure heartbeat intervals for database connections over SSH tunnels. We've even made it possible to manually cast text and number fields to date types. There's a whole lot of polish in this release, including performance and security improvements; check out the full list in our release notes.

Full list of enhancements

• map category/location to string so we can treat them like string/= in UI (#15698)
• Add an ENV var setting for typeahead search (#15379)
• Add missing "is" assertions to various tests (#15254)
• Custom Expression autocomplete operator selection is appended to what was typed (#15247)
• Custom Expression formula starts with high cursor placement on Firefox (#15245)
• Custom Expression filter not setting the "Done" button to current state of the formula until onblur (#15244)
• Dashboard Subscription Filters: Set Parameter Values (#15084)
• Normalize queries in URL fragments on FE (#15079)
• defsetting macro throw an Exception if you try to define a setting that's already defined in a different namespace (#15000)
• Fix render error when removing a dashboard parameter (#14999)
• Upgrade HoneySQL version to latest (#14934)
• SSH Connectivity Improvements (#14929)
• MBQL Refactor: Combine various Field clauses into one new clause (#14897)

Bug fixes

• Cannot select category Field Filter in Native query on 0.39.0 (#15700)
• Strings with placeholders like {0} aren't translating correctly (#15642)
• Wrong tooltip labels and values for multiple series charts in dashboard (#15612)
• Pulse fails when visualization_settings is referring to a field-literal column (#15475)
• Login History not recording correct IP address (#15437)
• BigQuery with filter after aggregation of join table fails query with wrong alias reference on 38.x (#15370)
• Dashboard Textbox images are 100% width (#15356)
• Questions based on Saved Questions is not using the same query for date filters leading to wrong results (#15352)
• Custom Expression editor is removing spaces too aggressive (#15243)
• Hitting return when modifying a custom expression incorrectly discards changes (#15241)
• metabase/metabase-enterprise-head Docker image doesn't have enterprise extensions (#15226)
• Custom expressions: UI is too wide when shown in the sidebar (#15217)
• Search: some results are as being in a folder which doesn't exist in the data reference (#15216)
• Error saving metric in data reference (#15127)

Get started with 0.39 right now

Before you upgrade:

• Definitely make a backup, as it’ll be harder to downgrade from 0.39. Just like we always suggest you make a backup, we are extra-suggesting that you make a backup this time, as our refactoring of the Metabase type system will make it more difficult to downgrade. And be sure to test core functionality in the new version before proceeding with the upgrade.
• Upgrading to 0.39 might take longer than usual. This is just a heads up: due to the improvements to Metabase’s type system, large installations might take a while to upgrade.
• Everyone will get an email when they first log in. 0.39 includes a security feature where we now send an email on the first login from an unknown device. When upgrading, since Metabase won’t know about any devices yet, it’ll send an email to each user on that first login.
• Metabase 0.39 will be the last release to support Internet Explorer 11. Starting with 0.40, we’ll drop support for Internet Explorer. IE11 will probably still work with Metabase, but you might get some unexpected behavior, so you might want to move to a different browser.

Not sure how to run Metabase? Check out our guide, How to run Metabase in production to find the approach that's right for you.

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

Notes

SHA-256 checksum for the 0.39.0.1 JAR:

c80b2290d660fbf3fbd0b2d2b64caaefeaea894e3132badb5ca74321e00bfefe