Update docker.io/metabase/metabase Docker tag to v0.55.1

v0.55.1: Metabase 55.1

Compare Source

Upgrading

Before you upgrade, back up your Metabase application database!

Check out our upgrading instructions.

Get the most out of Metabase. Learn more about advanced features, managed cloud, and first-class support.

Metabase Open Source

Docker image: metabase/metabase:v0.55.1.x
JAR download: https://downloads.metabase.com/v0.55.1.x/metabase.jar

Metabase Enterprise

Docker image: metabase/metabase-enterprise:v1.55.1.x
JAR download: https://downloads.metabase.com/enterprise/v1.55.1.x/metabase.jar

Changelog

Breaking changes

• XLSX exports of pivot tables now export data into a plain XLSX file instead of Excel-native PivotTable format (#​56622, #​58313)

  • The data is still exported as pivoted (when the appropriate option is selected during export), but the XLSX file will no longer use the Excel PivotTable interface.
  • This change is due to the fact that Excel PivotTable doesn't natively support all the Metabase aggregation functions, which lead to correctness issues in XLSX exports.
  • If you require the use of Excel PivotTable, export unaggragated data instead and pivot it in Excel directly.

• Remove support for deprecated hide_download_button hash parameter in static embedding (#​58401)

  • Deprecated since v51. Use the downloads parameter instead.

New features

Databases

• Support multi-catalog connections in Databricks (#​55732, #​57148, #​57484)
• Database Routing (#​54648, #​57117, #​57070, #​56931, #​56901, #​56853)
  • Build a question using a template database, and choose a database to actually run the query based on user attributes
• Basic Sandboxing for MongoDB (#​49303)
  • Use user attributes to enforce row-level security
  • Note: Advanced sandboxing with SQL questions is not supported on MongoDB
• Connection impersonation for MySQL and SQLServer (#​57622)
  • Use database roles for View data permissions in Metabase

Visualizations

• New interface for editing dashboard cards (#​48280, #​58106, #​57560, #​58525, #​58484, #​58437, #​58399, #​58311, #​57833, #​57830, #​57829, #​58274, #​58237, #​58228, #​58243, #​57957,#​57919, #​57806, #​57805, #​58933)
  • Reuse queries to visualize results in different ways
  • Add/remove breakouts without editing the query
  • Drag and drop measures and dimensions and combine series
  • Build funnels from individual pieces
  • ..and a lot more!

Administration

• Development instances (#​56579, #​57620, #​57553, #​57746)

  • Set up dev or staging Metabase Cloud instances for a flat fee. Previously this required creating another subscription.

• Customizable log levels (#​57524, #​57205, #​57022, #​56973, #​56772, #​57667)

  • Choose logging level in Admin interface
  • Log presets for common troubleshooting cases, like serialization or linked filters

• New type coercion strategies in Table Metadata

  • Cast String->Integer, String->Float, Float->Integer, Datetime->Date in Table Metadata. Previously, only casting to temporal types were available.
  • See also new custom expression to cast columns in the query builder below.

Querying

• Add boolean filter types to dashboards and SQL field filters (#​57435)

Custom expressions

• date(), text(), and integer() casting expressions are now supported on all SQL databases (except date() on Oracle) and MongoDB (#​55774, #​57653, #​56180,#​56177, #​55704, #​56178).

• splitPart() expression to split a string is now supported on Postgres, MySQL/MariaDB, BigQuery, Redshift, Clickhouse, and Snowflake (#​55935, #​55938, #​55918, #​55914, #​55691)

• date() custom expression can now truncate datetimes to date (in addition to converting a string to a date) (#​57448, #​57523)

• integer() custom expression can now round floats (in addition to converting a string to an integer) (#​56817)

• New custom expressions:

  • datetime() to convert a string to datetime (#​58048)
  • float() to convert a string to float (#​56814, #​56982)
  • Both are supported on Postgres, MySQL/MariaDB, BigQuery, Redshift, Clickhouse, and Snowflake.

• Use constants as standalone custom expressions (not supported on MongoDB) (#​56534, #​56533, #​56334, #​56254, #​56942)

Embedding

• Support SAML for Embedded Analytics SDK auth (#​56869, #​58641)
• Disable PDF and result downloads for individual entities in static and public embedding (#​56131,#​56211,#​56541)
  • The downloads url param now accepts values results and pdf in addition to true and false.

Other

• Keyboard shortcuts (#​57212, #​57116, #​56812, #​56806, #​56798, #​56610, #​56457, #​55945)
  • Contextual shortcuts for common actions like creating a question or bookmarking a dashboard. Press ? to see the list of shortcuts.

Enhancements

Reporting

• Users using free OSS version of Metabase will see "Powered by Metabase" logo in pdf exports in subscriptions (#​58096, #​57501, #​57266, #​57088)
• Remember the last download format for the user (#​50651)
• Limit available intervals for 'by the minute' schedule option (#​56068)

Querying

• Use parentheses for custom expressions with no parameters (#​56835)
  • From now on, type Count() instead of Count. Existing queries are not affected.
• Use results of another question as a source for filter values for numeric dropdown filters (#​56825)
• Use "Enter" to submit a value in dashboard filter widgets (#​57388)
• Rename date picker labels: "Specific dates" to "Fixed date range", "Relative dates" to "Relative date range" (#​56699)
• Search by remapped field values in search box filters in query builder (#​56621)
• More precise error messages in custom expression editor (#​57332, #​57199, #​57170, #​56984,#​56962, #​55737)

Data modeling

• Streamline editing Table Metadata (#​57518,#​56374, #​56289, #​36956,#​56060, #​58434)
  • Only show semantic types compatible with the database field type
  • Better interface for sorting columns
• Segments are easier to view and edit (#​56213, #​56151, #​56146)

UI

• Clean up "+ New" menu and add new "Add entity" buttons (#​57649, #​57647, #​57641, #​57605, #​57616, #​57555, #​57496)

  • Remove Collection, Model, and Metric from "+ New" menu.
  • Collections, models, and metrics can be created from the corresponding "Browse.." pages
  • Collections can also be created from the navigation sidebar

• Improved Admin tasks page (#​56791, #​56664, #​56491, #​56383)

  • Support sorting, filtering, and pagination of tasks
  • Add Download, Copy and See logs actions to task details

• Add helper text to empty visualizations to explain how to create a viz (#​55706)

Other

• Remove zh from the list of supported translations (use a specific zh-* locale instead) (#​57672)
• Allow "Sync Now" for Google Sheets instead of waiting for next scheduled time (#​54940)

API changes

See API changelog

Bug fixes

Administration

• Deleting a database with more than 65535 fields will fail (#​58491)
• Same table/schema names with different capitalization breaks sync (#​56949)
• No error handling when creating, editing, or removing groups (#​52886)
• SSO does not respect MAX_SESSION_AGE and MB_SESSION_COOKIES (#​51889)
• sync_schema endpoint is synchronous when it should be asynchronous (only snowflake?) (#​41964)
• Integer columns in Redshift external tables aren't receiving valid metadata (#​41788)

Querying

• Text comparison with ClickHouse UUIDs does not work (#​58579)
• Binning information is duplicated in summarization sidebar (#​57697)
• Cannot use browser navigation to navigate the Models Editor (#​55486)
• Duplicating a model prompts the user to add the model to a dashboard (#​54452)
• Default filter name does not respect include-current parameter (#​50139)
• Users with "Create Queries" Disabled are Prompted to Ask a New Question on empty Dashboards (#​44937)
• When x-raying a table, the collection tree in the navigation sidebar does not show the newly created collections (#​57493)
• In the search value picker, some values can't be picked (#​56210)
• Offset(CumulativeSum(...), 1) does not work (#​55720)
• Custom Expression having a date function between 2 aggregation functions returning dates doesn't work (#​55622)
• Column named Count is mishandled in aggregation expression editor when creating new metric (#​55300)
• MB_DB_QUERY_TIMEOUT_MINUTES ignored if MB_JDBC_DATA_WAREHOUSE_UNRETURNED_CONNECTION_TIMEOUT_SECONDS value is higher (#​54739)
• Public download urls can reach the limit of url length (#​51813)
• Implicitly joinable column groups cannot be distinguished (#​46845)
• Metrics calculated with filters end up in having conflicts among them (#​25455)
• Clicking column name when dropdown menu is open should close menu (#​16789)

Visualization

• Error message is ugly & unhelpful when rendering a map visualization where the custom geojson has been deleted (#​39134)
• Currency label options text not displayed (#​58727)
• Visualization's row count wraps needlessly when the view port is <~1060px wide (#​55518)
• Pivot tables don't show the totals for series that have a unique value (#​52333)
• Conditional formatting won't display on subscriptions when it is applied to multiple columns (#​58234)
• Gauge visualization is nonsensical when using a time unit breakout (#​55728)
• Changing decimal values of a measure directly impacts the y-axis scale values (#​35046)
• "Save as default view" in map visualization does not save card (#​20263)

Reporting

• Subscription filter values displays technical values for date, which can be difficult to read for humans (#​24651)
• Formatting issues in the xlsx export (#​54498)
• Min, Max, Average, Distinct values are aggregated as Sum for subtotals and grand total in the xlsx export (#​54497)
• Columns with the "Avatar IMG URL" Semantic type will display the url instead of an image when sent out in Subscriptions (#​40189)
• Columns are sorted in JSON export, when there more than 8 columns (#​12247)