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

No problems upgrading the Docker container with a Docker compose yaml file and by means of Watchtower infrastructure with dependency update facilitated by Mend's Renovate Bot.

This MR contains the following updates:

Release Notes

v0.54.1: Metabase 54.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.54.1.x
JAR download: https://downloads.metabase.com/v0.54.1.x/metabase.jar

Metabase Enterprise

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

Changelog

Breaking changes

• Embedding SDK saveToCollection is deprecated. Use targetCollection instead (#​54983)

New features

Querying

• New custom expression editor (#​54253, #​54084, #​55537, #​55102, #​55164)
  • Multi-line expressions, auto-format, function library.
• Support BigInteger values (#​53326, #​53630)

New custom expressions

• date() to cast string to date (Postgres only for now) (#​55435)
• integer() to cast string to an integer (Postgres only) (#​55364)
• text() to cast a value to string (Postgres only)
• splitPart() to split a string by separator and extract nth part (Postgres only) (#​55429)
• path() to extract URL path (#​55375)
• DistinctIf() to compute the number of distinct values satisfying a condition (#​55131, #​55129)

Visualizations

• New and improved table visualization (#​54775, #​54703, #​54399)
  • Add text wrapping, alignment, row indexes.

Embedding

• Let embedders select which entities to expose in data picker (#​55463)
  • Expose only models, or models and tables, etc.

Alerts

• Add Cron scheduling for alerts (#​3846)
• Add 'by the minute' scheduling option for alerts (#​55184)

Enhancements

• Simplified data picker for embedding (#​54489)

Databases

• Make Clickhouse driver official (#​54740)
• Make Starburst driver official (#​55123)
  • Can also be used with Trino
• Reduce cost of initial field scanning (#​53387)
• Add hostname support to BigQuery (#​51948)

Querying

• Allow text-like filters on MongoDB UUID fields (#​55792)
• New multi-stage filter picker when viewing a visualization (#​55052)
• Better native query editor (CodeMirror) (#​50249)

Alerts

• Slack integration should be able to send images to private channels (#​53319)
  • No longer require a public channel to store images
• Slack integration should list private channels (#​44798)
• Allow users with settings permissions to create alerts with webhooks (#​53210)

Dashboards

• Make table pagination on dashboard into a visualization setting (#​55735)
• Duplicated dashboard cards load immediately after duplication (#​55256)

UI improvements

• Respect whitelabeling when showing the instructional video (#​55987)
• Show a more user-friendly error message when there are incompatible types (#​55927)
• Update some function names to match modern casing (#​55672)
• Add hover effect for dirty query state (#​55627)
• Hide unused semantic types (#​55327)
• Press Escape to close Entity Picker (#​55549)
• Improve empty states for features to provide more context (#​54438, #​54157, #​54136), #​54101
• Add upsells for Pro features (#​53080, #​53566, #​53632,#​53720, #​53727, #​53495, #​52974, #​52955, #​53099, #​53951)
• Make sure elements support ARIA attributes (#​53270)
• Allow zooming and scaling on mobile devices (#​53483)
• Remove legacy setup checklist from Admin (#​54599)

Other

• Make cruft patterns configurable (#​49320)
• Add is_verified and task status to usage analytics (#​55908)
• More logging for subscriptions and alerts (#​55751)
• Add index to query_execution_id column on field_usage table (#​55712)
• Fix compilation of case with clauses that need pre-processing (#​55958)
• X-rays generate questions that are saved in a dashboard (#​52462)
• Use SDK-specific ID types and reconcile the changes (#​55448)
• fix warning about missing ref on forwardref for FullWidthContainer (#​54252)
• Add Slovenian Localization + Synchronize Translations (#​55307)
• Add Slovenian Language Support. (#​54420)
• Migrate Chinese site & user locales from zh to zh_CN (#​55287)
• [pivot] Optimize CLJC pivot export for csv files (#​55235)
• Scrap the ability to resolve table names, just use ids (#​54839)
• Table Data Editing APIs (#​54651)
• [mbql] Use more efficient keywordize-keys during normalization (#​53432)
• Hash session ID in core_session table (#​53266)
• Healthcheck API endpoint for databases (#​54446)
• Track notification wait time and total send time (#​54080)
• Deadline-based priority queue for notifications (#​54647)
• Fix task history report when channel failed to send and we skip it (#​55312)
• Dedup send queue (#​54320)
• Alert refactor (#​50766)

Bug fixes

Administration

• Custom property won't appear for sandboxing when more than 1000 users (#​55647)
• Metabase should run field value scanning on Metabase analytics views (#​46540)
• Password reset causes too much confusion when the email is mistyped (#​12987)

Database

• Bigquery STRUCT types break in the GUI for nested layers (#​55562)
• Different results using between on Mongo comparing to other drivers (#​55302)
• SQL errors on Databricks return a full stack trace (#​53539)
• I/O error during migration does not cleanly abort migration (#​50212)
• Can't use relative date filters with Snowflake varchar -> ISO8601 daytime columns (#​49907)
• [SQLite] Trend widget only work with group by year, not work by quarter,month,day.... (#​12388)

Embedding

• Sdk is changing the color theme of the host app (#​54835)
• Type errors on Nextjs (and possibly others) "'MetabaseProvider' cannot be used as a JSX component." (#​53767)

Querying

• Dropdown filters behave like Search when there's too many unique values (#​34726)
• Auto-complete in custom column fails to append after inserting newline character (#​31964)
• Navigation issue when navigating back to a model (#​55158)
• The column filter component cannot search for double quotes (#​53737)
• Custom column and escaping problematic characters (#​53527)
• It's not possible to switch to MongoDB in native query editor (#​53299)
• Converting a model to SQL and adding a variable doesn't let you change variable type (#​50662)
• Select none is shown and checked when all the found options are checked in the filter (#​50070)
• Autocomplete suggestions reset users choice on load (#​48712)
• Handle failing requests better when part of the notebook editor can still be rendered (#​48562)
• Empty section title rendered in dashboard filter column mapping (#​47218)
• Multiple bucketing menus can be opened simultaneously (#​45036)
• Missing and incorrect brazilian localization for date filters (#​36549)
• We're incorrectly pluralizing table names in some non-English languages (#​28559)
• Filter text not translated correctly depending on period (#​13188)
• Floating-point rounding errors in UI for very large integers (JS stores all numbers as 64-bit floats) (#​5816)

Visualization

• Pivot Grand Totals Incorrect if Aggregate Column Name Contains Special Characters (#​55415)
• Average, Distinct values are aggregated as Sum for subtotals and grand total in the CSV export of Pivot tables (#​54496)
• Long column names overflow in data viz settings on cartesian charts (#​52975)
• "Display a column as a link" not functional in Detail visualization type (#​48915)
• Non-clickable items appearing to be clickable in Details view (#​48356)
• Scatter Plot randomly interprets long numbers as dates moving Axis Scale from Linear to Timeseries (#​30102)
• Table visualization settings are not applied in subscriptions(#​29277)
• Resizing Number Visualization adds a decimal even if Minimum number of decimal places is set to 0 (#​25791)
• We should only accept positive numbers in the inputs for minimum decimal places (#​24333)
• Disable dragging columns in "raw data" view of a non-table visualization (#​19817)

Dashboards

• Dashboard loading kills the tab (#​55880)
• Decimal formatting sometimes not respected on dashboards (#​54063)
• Text in the page is selected when dragging cards in dashboard edit mode (#​53842)
• "Info" icon is showing in dashboard edit mode when it shouldn't (#​46085)

Uploads

• Failure to upload CSV to ClickHouse (#​55265)
• Failure to update, append to CSV uploaded models with date time data in ClickHouse (#​55199)
• Cannot change the type of a column in uploaded csv (#​48662)

Notifications

• Notifications limit result to 2k for raw and 10k for aggregate questions (#​55522)
• Missing translations in subscriptions (#​33901)

Other

• The drop down when filtering to choose "is empty" is very squished (#​54196)
• Inconsistent dropdown item hover effect (#​53818)
• Bookmark and collection highlighted in the sidebar when creating new native question (#​52809)
• [Notification] We shouldn't retry sending slack if it has error "channel_not_found" (#​49647)
• App partially crashes during navigation (#​55162)
• Filtering the semantic types list is super annoying (#​53595)
• Text cut off in FK target dropdown (#​45409)
• Empty Help tooltip (#​55082)
• Persisting hover state on sidebar icon after closing / opening (#​54365)
• [Bug Report] Incorrect icon size (#​54181)
• Custom expression input is not autofocused for filters and aggregations (#​54722)
• Filter dropdown visual regressions (#​54412)
• Select misaligned in horizontal forms (#​54325)
• It's not possible to close data reference sidebar in native query editor (#​54124)
• Resize handle misplaced in Notebook view (#​53817)
• Add column popover is cut off (#​53170)
• Variable type picker covered by field picker (#​52811)
• Unable to focus search input with keyboard in Filter Modal (#​52733)
• Card reference in a native query with a long title does not wrap (#​53171)
• Documentation link does not work (#​54638)
• Text doesn't wrap on the visualization "warning" popover (#​54431)
• Clicking outside of data download popover doesn't close it (#​54361)
• Clicking on "Add or remove columns" creates bad looking box around CTA (#​54360)
• Dashcard viz settings modal: chart height is limited with the settings sidebar height (#​54357)
• In dashcard viz settings chart tooltips are below the modal (#​54354)
• [Bug Report] Data setting dropdowns for charts have grey background in Firefox (but not in Chrome) (#​54115)
• Text overflows dashcard tooltips (#​54405)
• Visibility explanation copy is the same across all 3 options (#​56077)
• "Welcome to Metabase" logo is tiny (#​41687)
• The example for the Offset function is wrong (#​55940)
• Broken expression suggestions dropdown styling when metric has a long name (#​55984)
• field entity-id backfill doesn't produce correct results (#​55929)
• Custom expression hints disappear if there's an exact match (#​55686)
• Gear icon for visualization settings is too light (#​56138)
• View as image column breaks table row height (#​55939)
• Text wrapping breaks when wrapped column has display-as url (#​55881)
• Excessive gap above the sql results table (#​55876)