Metabase v0.36.0 Release Notes

Release Date: 2020-07-21 // almost 2 years ago
  • ๐Ÿ†• 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
    0๏ธโƒฃ 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 (#2086)
    • โž• Added support for SSH keys (#5153)
    • โž• Added support for connection URIs for MongoDB and JDBC databases (#5084)
    • โž• Added support for BigQuery Service Accounts (#4634)
    • ๐Ÿ”ง Jetty request header size is now configurable (#12683)
    • ๐Ÿ›  Fix z-index for all auth wrappers (#12894)
    • ๐Ÿ‘• Don't complain about API endpoints/schemas missing docstrings when running linters (#12417)

    ๐Ÿ› 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 (#11807)
    • Drill-through is broken on nested question on dashboard (#12455)
    • Visualization type gets reset to "Table" (different scenarios) (#12361)
    • Visualization type cannot be saved when is only one result (#11675)
    • 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)
    • ๐ŸŒ 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)
    • ๐ŸŒฒ :user-joined and :create-user activities not saved to activity log during setup (#12933)
    • โšก๏ธ Error when updating Max Cache Entry Size: "Values greater than {1} are not allowed" (#12884)
    • ๐Ÿ”€ Sync not triggered for database added during setup (#12826)
    • Can't create new Slack Metabot (#12678)
    • Password reset doesn't work on low-resolution screens (#12658)
    • Cannot start Metabase on Turkish language OS (#12623)
    • Search: no longer show inaccessible metrics & segments (#12916)
    • ๐Ÿ‘ SQLite does not support Right or Full Outer joins (#12598)
    • Trend visualization fails, when results comes from cache (#12556)
    • Column type of aggregated column in sql view is unknown (#12547)

    โฌ†๏ธ 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
    Download the JAR here: https://downloads.metabase.com/v0.36.0/metabase.jar

    Notes

    SHA-256 checksum for the 0.36.0 JAR:

    a0f93452136deb88c19af5b02018d0d1dc35afed3dca2d1e2615309f2bc8cea6