Metabase v0.49.2

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v0.49.2 JAR:

3e67f360f9df2055fdd88d2d9d726865adc474e17b105a396dcd13f5ba386d2d

Changelog

Enhancements

• Sort official collections first in API endpoints (#40598)
• Increase rate limit of actions from 1 to 10 per second (#40527)
• Order of collection should be the same as the collection sidebar (#39965)
• Show more billing info on license and billing settings page (#38497)

Bug fixes

• LDAP no longer works on OSS (#40704)
• model indexes error when values are removed (#40639)
• Common Metrics gone after Summarising by some other column (#40553)
• Attaching CSV files to a subscription leads to a NullPointerException (#40472)
• If there are new columns in the data source after the question was saved, they are hidden by default (#40435)
• Cannot save a question based on another question after converting to SQL (#40422)
• Field filter breaks native question on dashboard (#40383)
• postgresql tables that are visible through column grants aren't available for simple questions (#40338)
• Specific date filter shifts dates by one day (#40332)
• Group managers cannot view all people (#40328)
• Exporting date values changes the year (#40306)
• Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
• Parameter filter widget jumps and doesn't allow to pick a value (#40232)
• Trend viz might not appear correctly on alerts (#39854)
• Filtering by a Specific Date in Snowflake will bring inaccurate results (#39769)
• Whitespace symbol breaks suggestions (#39622)
• Model Caching stuck in "pending" state not cleared out by next scheduled refresh (#39138)
• Duplicate column name error when exploring results of native query with join (#39098)
• Getting errors in the truncate log task Caused by: java.lang.ClassNotFoundException: metabase.task.truncate_audit_log.TruncateAuditLog (#38235)
• Scrolling issue in sort dropdown with many values (#36074)
• Fix missing columns after query fields update (#40398)
• Fix N+1 in checking write permission for collection (#40345)
• Dashcards from other tabs show up in the first one after entering and leaving editing mode (#40695)
• fix normalized chart crashes when trend lines enabled but there is no insights data (#40624)
• Fix unable to migrate to 49 due to v49.00-059 migration (#40547)
• Often SLO won't be setup on the IdP but we should still delete the session. (#40459)
• Redshfit: sync tables with partial select permission (#40421)
• Restore logo margin (#40417)
• Formatter Gives correct year for dates near start/end of Year (#40410)
• funnel chart does not work in static viz (#39743)
• Include filters when exporting dashboard to PDF (#38231)
• [MLv2] [BE] [Bug] returnedColumns does not handle columns with the same name (#37517)
• Export to PDF should have the filter values that were used on the dashboard (#35475)

Metabase® Enterprise Edition™ v1.49.2

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v1.49.2 JAR:

d28690c2f930c99013e6b2324e64c9ed4a43ac12f63bfb14325a9d8a6ca53fe9

Changelog

Enhancements

• Sort official collections first in API endpoints (#40598)
• Increase rate limit of actions from 1 to 10 per second (#40527)
• Order of collection should be the same as the collection sidebar (#39965)
• Show more billing info on license and billing settings page (#38497)

Bug fixes

• LDAP no longer works on OSS (#40704)
• model indexes error when values are removed (#40639)
• Common Metrics gone after Summarising by some other column (#40553)
• Attaching CSV files to a subscription leads to a NullPointerException (#40472)
• If there are new columns in the data source after the question was saved, they are hidden by default (#40435)
• Cannot save a question based on another question after converting to SQL (#40422)
• Field filter breaks native question on dashboard (#40383)
• postgresql tables that are visible through column grants aren't available for simple questions (#40338)
• Specific date filter shifts dates by one day (#40332)
• Group managers cannot view all people (#40328)
• Exporting date values changes the year (#40306)
• Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
• Parameter filter widget jumps and doesn't allow to pick a value (#40232)
• Trend viz might not appear correctly on alerts (#39854)
• Filtering by a Specific Date in Snowflake will bring inaccurate results (#39769)
• Whitespace symbol breaks suggestions (#39622)
• Model Caching stuck in "pending" state not cleared out by next scheduled refresh (#39138)
• Duplicate column name error when exploring results of native query with join (#39098)
• Getting errors in the truncate log task Caused by: java.lang.ClassNotFoundException: metabase.task.truncate_audit_log.TruncateAuditLog (#38235)
• Scrolling issue in sort dropdown with many values (#36074)
• Fix missing columns after query fields update (#40398)
• Fix N+1 in checking write permission for collection (#40345)
• Dashcards from other tabs show up in the first one after entering and leaving editing mode (#40695)
• fix normalized chart crashes when trend lines enabled but there is no insights data (#40624)
• Fix unable to migrate to 49 due to v49.00-059 migration (#40547)
• Often SLO won't be setup on the IdP but we should still delete the session. (#40459)
• Redshfit: sync tables with partial select permission (#40421)
• Restore logo margin (#40417)
• Formatter Gives correct year for dates near start/end of Year (#40410)
• funnel chart does not work in static viz (#39743)
• Include filters when exporting dashboard to PDF (#38231)
• [MLv2] [BE] [Bug] returnedColumns does not handle columns with the same name (#37517)
• Export to PDF should have the filter values that were used on the dashboard (#35475)

Metabase v0.49.1

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v0.49.1 JAR:

a32876e61e7db9d7f0b8ba992789e01982feb6ea7d1845a07a071335bd0f7871

Changelog

Enhancements

• Improve homepage experience for embedding users (#40168)
• Highlight the selected data source in the notebook editor (#39542)
• Snowflake alternative hostname implementation (#22133)

Bug fixes

• QB header jumps when switching between a simple and a notebook modes (#40334)
• There is an additional border between the notebook and the query builder header (#40333)
• Cannot save a question based on another question after converting to SQL (#40422)
• Add Dimension field error handling (#40300)
• Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
• Allow running native queries with required parameters and no defaults (#40250)
• Wide logos cover the icon to collapse the sidebar (#40153)
• PNG dashboard card download doesn't do anything in MacOS Safari (#40095)
• Inconsistent spacing around table and schema divider (#39999)
• Data source is not initially highlighted for nested questions and models once their source is moved to a different collection (#39812)
• Can't enlarge preview section while creating a model (#39628)
• Getting fields in (Redshift) is slow (#38492)
• Null values applied to filters with empty values in custom url from Click Behavior (#38489)
• Zoom in from dashboard change visualization (#38307)
• Updated native models may lose their result set metadata (#37009)
• Can't use drag bar between editor and result pane while editing a model (#33982)

Metabase® Enterprise Edition™ v1.49.1

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v1.49.1 JAR:

dfd8089f2c2a801e5211640ffae68d2e5c323bfd235090e4ded1c1c5d707bdf5

Changelog

Enhancements

• Improve homepage experience for embedding users (#40168)
• Highlight the selected data source in the notebook editor (#39542)
• Snowflake alternative hostname implementation (#22133)

Bug fixes

• QB header jumps when switching between a simple and a notebook modes (#40334)
• There is an additional border between the notebook and the query builder header (#40333)
• Cannot save a question based on another question after converting to SQL (#40422)
• Add Dimension field error handling (#40300)
• Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
• Allow running native queries with required parameters and no defaults (#40250)
• Wide logos cover the icon to collapse the sidebar (#40153)
• PNG dashboard card download doesn't do anything in MacOS Safari (#40095)
• Inconsistent spacing around table and schema divider (#39999)
• Data source is not initially highlighted for nested questions and models once their source is moved to a different collection (#39812)
• Can't enlarge preview section while creating a model (#39628)
• Getting fields in (Redshift) is slow (#38492)
• Null values applied to filters with empty values in custom url from Click Behavior (#38489)
• Zoom in from dashboard change visualization (#38307)
• Updated native models may lose their result set metadata (#37009)
• Can't use drag bar between editor and result pane while editing a model (#33982)

Metabase v0.48.9

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

Notes

SHA-256 checksum for the v0.48.9 JAR:

aff114f0754e3d042be35357fb6e375c43099c1384ad00eb2164c186447335f9

Changelog

Bug fixes

• Breakout by an unfolded JSON column now works correctly (#35636, #34930)
• Fix custom columns that have same name as existing columns causing error (#25931 , #39059)
• Chain filters do not respect inactive fields (#39618)
• Enabling "don't send if there aren't results" in a subscription now sends the text cards (#39190)
• Metabase v48+ does not run on Windows on H2 (#39040)
• Interactive embedding dashboard with multiple tabs and parameter header=false will not load (#39002, #38429)
• Custom expression interface will not show in usage pop-ups for unsupported functions (#35156)

Metabase® Enterprise Edition™ v1.48.9

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

Notes

SHA-256 checksum for the v1.48.9 JAR:

0e3fdcbc49d251a9512fbc51607c6190310a6a85a049ed66c222fd5369282722

Changelog

Bug fixes

• Breakout by an unfolded JSON column now works correctly (#35636, #34930)
• Fix custom columns that have same name as existing columns causing error (#25931 , #39059)
• Chain filters do not respect inactive fields (#39618)
• Enabling "don't send if there aren't results" in a subscription now sends the text cards (#39190)
• Metabase v48+ does not run on Windows on H2 (#39040)
• Interactive embedding dashboard with multiple tabs and parameter header=false will not load (#39002, #38429)
• Custom expression interface will not show in usage pop-ups for unsupported functions (#35156)

Metabase v0.49.0

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v0.49.0 JAR:

7766e2fa3120bd11224dae33e7b23eeaf759e49af0088e025c9e24b87347f3d2

Changelog

Enhancements

Dashboard improvements

• Make dashboard filters global or tab specific (#31621)
• Add Sections (pre-defined layout of empty dash cards) to a dashboard (#38209, #38575)
• Let creators duplicate dashboards tabs and cards (#38208)
• Let creators swap out dashboard questions with a different question (#36497)
• Add "Replace question" action to dashboard cards (#36744)
• Let creators make dashboard and native query filters required (#36524, #18097, #39159, #5320, #37709)
• Default dashboards to a fixed width to give creators a more predictable canvas (#36358, #10364)

Trend charts improvements #33411

• Increase design control over Big Numbers (#31951)
• Smart Numbers: chose the unit of the lag displayed (#11200)
• Smart numbers: configurable lag (#9510)
• Smart Number visualization wording (#8919)
• Trend text not translated correctly depending on period (#25670)
• Support arbitrary date comparison (#35551)

Allow appending more data to CSV uploads (#35614, #38837, #37220, #36640, #13358)

Remove Models from Browse data (#40108, #40037)

• Models in Browse Data (#37707, #38560, #38661, #38730, #38704, #38635, #38518, #38107, #38126)

Serialization API (#36843, #36240, #20632, #38359, #38804)

API Authentication method (#2699, #36593, #37607, #36347, #37051)

• Write a GET /api/api-key endpoint to list API keys (#37000)
• Write a PUT /api/api-key/:id/regenerate endpoint to regenerate an existing API key (#36999)
• Write a PUT /api/api-key/:id endpoint to update API key names/groups (#36998)
• Remove API bits from ApiKey model (#37085)
• Return group instead of just group_name for ApiKeys (#37061)- Add last_name to ApiKey users (#37234)
• Avoid failing call to /api/model-index (#37284)

Add connection impersonation to Redshift (#38445, #32388)

Embedding improvements

• Setup flow for Static and Public embedding, and embedding feature discoverability (#35961, #36048, #36481, #36170)
• Modified setup flow for admins who want to start embedding (#38233)
• Fix public links refer to null when question is new (#39154)
• Sticky filters on embedded and Public dashboards (#24726)
• Enable default public-sharing for new instances (#38609)

White-labeling

• Customize or hide “Help” link; hide links to metabase.com outside of admin settings (#35915, #36966)
• Fix white-labeled icon colors of official collections and verified models (#39238)
• Add anonymous usage tracking for relevant white-labeling (#37656)

Metabase Library v2 (#28689)

• Include implicit joins for breakout/order on models (#40027)
• joinable-columns on a Join sets source and alias (#39529)
• Ensure :name is unique on returned columns in the FE (#39118)
• Handle Object.isFrozen() legacy columns as input (#39032)
• Custom columns testing plan (#37173, #36235)
• Migrate setDefaultDisplay to MLv2 (#37172)
• Migrate _syncStructuredQueryColumnsAndSettings to MLv2 (#37171)
• Migrate sourceTableId, sourceTable to use sourceTableOrCardId from MLv2 (#37170)
• Migrate databaseId, database to use databaseID from MLv2 (#37169)
• Add caching for the common case of visible-columns w/o options (#38409)
• Cache JS -> CLJS metadata conversion (#38375)
• Add tests and fix a special case for fk-filter drills (#38297)
• fk-details drill should preserve := filters for other PKs (#38296)
• Drill-thru coverage: Add a structured column and fix that case (#38295)
• Fix some edge cases and add more unit tests for zoom in drills (#38275)
• Add description and fingerprint to displayInfo for columns (#38476)
• New "canned" queries and clicks for drill-thru testing (#38210)
• Add isTemporalExtraction flag to displayInfo (#37889)
• Add aggregation-column and breakout-column (#37873)
• Look up FK columns in visible-columns, not metadata (#37771)
• Make query= treat missing :base-type as matching (#37727)
• findColumnIndexForColumnSetting and findColumnSettingIndexForColumn (#37677)
• Add display-info for queries (#37675)
• Add legacy-column->metadata for converting DatasetColumn (#37648)
• Migrate data reference (#37629)
• Migrate object detail (#37628)
• Add compatible-type? wrapper that handles JS DatasetColumns (#37609)
• Remove aggregate, breakout, filter methods from Question (#37509)
• Migrate supportsImplicitActions (#37507)
• Migrate QuestionDataSource (#37396)
• Migrate initializeQB (#37391)
• Make displayInfo for column groups straightforward to use (#37369)
• Remove unused legacy MLv2 functions (#36988)
• Notebook steps (#36983, #36516)
• Add a flag to displayInfo(query, stageIndex, temporalBucket) indicating it's for an extraction temporal unit (#36978)
• Drop redundant :fields clauses from stages and joins (#36959)
• Track drill-thru unit test coverage (#36601)
• Unskip FE integration tests for automatic-insights drills (#36529)
• Fix pivot drills integration with the FE (#36509)
• Implement automatic-insights drill (#36443)
• Migrate suggest.ts to use MLv2 for computing columns (#36233)
• Support changing expressions in the query w/o removing parts depending on the original (#36211)
• View - remove BreakoutPopover usage (#36737)
• View - remove AggregationPopover usage (#36736)
• Reorder column filter and distribution drills (#36700)
• Add support for segment and metric in legacyFieldRef (#36699)
• Add sourceTableOrCardId(query) (#36672)
• fk-filter drills should not appear on native queries (#36660)
• Fix an edge case where a join-alias is needed on a field ref (#36871)
• Add breakoutColumn and aggregationColumn APIs to simply columns retrieval from these clauses (#37120)
• Resolve a string :fk-field-id to a numeric ID if possible (#37079)
• Migrate functions used in ExpressionEditorTextfield to MLv2 query (#36254)
• Convert ExpressionStep to MLv2 (#35982)
• Expressions in FilterPicker without legacy query (#35948)
• Expressions in AggregationPicker without legacy query (#35947)

Misc:

• Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
• Add the timestamp to the filename in the subscription attachment (#39120)
• Add intermittent test solver (#38159)
• Add BE for routing billing status (#38153)
• Add Creator Sentiment Email task (#38787)
• Add stress testing workflow for frontend unit tests (#38081)
• Add a banner to the top of locales.clj (#37877)
• Allow toggling of the dashboard subscription sidebar from the icon (#36244)
• Bigquery: Sync required partition column (#36668, #36677, #36892)
• [chain filters] should not be using inactive fields for joins (#39635)
• Compute results of timestamp/current-date functions during query processing (#21518)
• Consistent Date and Time Formatting for metabase.formatter.datetime (#36559)
• Count :model/User, not :core_user (#36985)
• Create a unified rendering pipeline for formatting (#36015)
• Delete all pruned persisted info records (#39219)
• Don't delete "off" persisted_info records (#39272)
• Download Updated Translations for v49 (#40086)
• Elevate selected filter field values (#40055)
• Ensure consistent percentage formatting across FE and pulses (#36327)
• Ensure results metadata is applied to standalone cards in pulse HTML output (#36323)
• Ensure results metadata is applied to csv files in pulse exports (#36320)
• Error if DB downgrades are required (#37239)
• Export to PDF should have the filter values that were used on the dashboard (#35475)
• Faster sync-fks for Redshift (#38970) (#40062)
• Filter picker search free input (#38907)
• Fix permissions graph performance (#36610, #36797, #36543)
• Fix confusion of expressions with the same name as columns (#39526, #39255)
• Fix isNavigationAllowed (#38703)
• Fix TableBrowser flex (#38324)
• Flaky QueryBuilder.unit.spec.tsx (#37184)
• Format SQL Query option in the Native Query Editor (#9142)
• Hitting enter doesn't save filter changes (#6552)
• Honey SQL 2 Migration (#28684, #28396, #28156, #28165, #28161)
• Introduce describeWithSnowplowEE (#39623)
• Join performance issues (#39633)
• Kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
• Load analytics only when changed using a checksum (#38280)
• Let admins disable user provision on SSO (#36371)
• Migrate the FieldInfo card to Mantine so it can be reused (#38432)
• Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
• Merge viz settings correctly (#36154)
• Merge metadata correctly (#36153)
• Monger does not support Atlas Serverless (#27385)
• Make effective use of Snowflake's query result caching (#20988)
• No view logging for OSS (#39957)
• Only return helpText for supported features (#39766)
• Optimize autocomplete query (#38080)
• Port LastEditInfoLabel (#38109)
• Query metadata within comments leads to cache misses in AWS Athena (#29615)
• Remove unused global css (#39220, 39020, #39531)
• Remo...

Metabase® Enterprise Edition™ v1.49.0

Metabase 49 release announcement

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

Notes

SHA-256 checksum for the v1.49.0 JAR:

126a449a2f301744bc542392fca360dc8a2c562faadf6831539cafc0e973db48

Changelog

Enhancements

Dashboard improvements

• Make dashboard filters global or tab specific (#31621)
• Add Sections (pre-defined layout of empty dash cards) to a dashboard (#38209, #38575)
• Let creators duplicate dashboards tabs and cards (#38208)
• Let creators swap out dashboard questions with a different question (#36497)
• Add "Replace question" action to dashboard cards (#36744)
• Let creators make dashboard and native query filters required (#36524, #18097, #39159, #5320, #37709)
• Default dashboards to a fixed width to give creators a more predictable canvas (#36358, #10364)

Trend charts improvements #33411

• Increase design control over Big Numbers (#31951)
• Smart Numbers: chose the unit of the lag displayed (#11200)
• Smart numbers: configurable lag (#9510)
• Smart Number visualization wording (#8919)
• Trend text not translated correctly depending on period (#25670)
• Support arbitrary date comparison (#35551)

Allow appending more data to CSV uploads (#35614, #38837, #37220, #36640, #13358)

Remove Models from Browse data (#40108, #40037)

• Models in Browse Data (#37707, #38560, #38661, #38730, #38704, #38635, #38518, #38107, #38126)

Serialization API (#36843, #36240, #20632, #38359, #38804)

API Authentication method (#2699, #36593, #37607, #36347, #37051)

• Write a GET /api/api-key endpoint to list API keys (#37000)
• Write a PUT /api/api-key/:id/regenerate endpoint to regenerate an existing API key (#36999)
• Write a PUT /api/api-key/:id endpoint to update API key names/groups (#36998)
• Remove API bits from ApiKey model (#37085)
• Return group instead of just group_name for ApiKeys (#37061)- Add last_name to ApiKey users (#37234)
• Avoid failing call to /api/model-index (#37284)

Add connection impersonation to Redshift (#38445, #32388)

Embedding improvements

• Setup flow for Static and Public embedding, and embedding feature discoverability (#35961, #36048, #36481, #36170)
• Modified setup flow for admins who want to start embedding (#38233)
• Fix public links refer to null when question is new (#39154)
• Sticky filters on embedded and Public dashboards (#24726)
• Enable default public-sharing for new instances (#38609)

White-labeling

• Customize or hide “Help” link; hide links to metabase.com outside of admin settings (#35915, #36966)
• Fix white-labeled icon colors of official collections and verified models (#39238)
• Add anonymous usage tracking for relevant white-labeling (#37656)

Metabase Library v2 (#28689)

• Include implicit joins for breakout/order on models (#40027)
• joinable-columns on a Join sets source and alias (#39529)
• Ensure :name is unique on returned columns in the FE (#39118)
• Handle Object.isFrozen() legacy columns as input (#39032)
• Custom columns testing plan (#37173, #36235)
• Migrate setDefaultDisplay to MLv2 (#37172)
• Migrate _syncStructuredQueryColumnsAndSettings to MLv2 (#37171)
• Migrate sourceTableId, sourceTable to use sourceTableOrCardId from MLv2 (#37170)
• Migrate databaseId, database to use databaseID from MLv2 (#37169)
• Add caching for the common case of visible-columns w/o options (#38409)
• Cache JS -> CLJS metadata conversion (#38375)
• Add tests and fix a special case for fk-filter drills (#38297)
• fk-details drill should preserve := filters for other PKs (#38296)
• Drill-thru coverage: Add a structured column and fix that case (#38295)
• Fix some edge cases and add more unit tests for zoom in drills (#38275)
• Add description and fingerprint to displayInfo for columns (#38476)
• New "canned" queries and clicks for drill-thru testing (#38210)
• Add isTemporalExtraction flag to displayInfo (#37889)
• Add aggregation-column and breakout-column (#37873)
• Look up FK columns in visible-columns, not metadata (#37771)
• Make query= treat missing :base-type as matching (#37727)
• findColumnIndexForColumnSetting and findColumnSettingIndexForColumn (#37677)
• Add display-info for queries (#37675)
• Add legacy-column->metadata for converting DatasetColumn (#37648)
• Migrate data reference (#37629)
• Migrate object detail (#37628)
• Add compatible-type? wrapper that handles JS DatasetColumns (#37609)
• Remove aggregate, breakout, filter methods from Question (#37509)
• Migrate supportsImplicitActions (#37507)
• Migrate QuestionDataSource (#37396)
• Migrate initializeQB (#37391)
• Make displayInfo for column groups straightforward to use (#37369)
• Remove unused legacy MLv2 functions (#36988)
• Notebook steps (#36983, #36516)
• Add a flag to displayInfo(query, stageIndex, temporalBucket) indicating it's for an extraction temporal unit (#36978)
• Drop redundant :fields clauses from stages and joins (#36959)
• Track drill-thru unit test coverage (#36601)
• Unskip FE integration tests for automatic-insights drills (#36529)
• Fix pivot drills integration with the FE (#36509)
• Implement automatic-insights drill (#36443)
• Migrate suggest.ts to use MLv2 for computing columns (#36233)
• Support changing expressions in the query w/o removing parts depending on the original (#36211)
• View - remove BreakoutPopover usage (#36737)
• View - remove AggregationPopover usage (#36736)
• Reorder column filter and distribution drills (#36700)
• Add support for segment and metric in legacyFieldRef (#36699)
• Add sourceTableOrCardId(query) (#36672)
• fk-filter drills should not appear on native queries (#36660)
• Fix an edge case where a join-alias is needed on a field ref (#36871)
• Add breakoutColumn and aggregationColumn APIs to simply columns retrieval from these clauses (#37120)
• Resolve a string :fk-field-id to a numeric ID if possible (#37079)
• Migrate functions used in ExpressionEditorTextfield to MLv2 query (#36254)
• Convert ExpressionStep to MLv2 (#35982)
• Expressions in FilterPicker without legacy query (#35948)
• Expressions in AggregationPicker without legacy query (#35947)

Misc:

• Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
• Add the timestamp to the filename in the subscription attachment (#39120)
• Add intermittent test solver (#38159)
• Add BE for routing billing status (#38153)
• Add Creator Sentiment Email task (#38787)
• Add stress testing workflow for frontend unit tests (#38081)
• Add a banner to the top of locales.clj (#37877)
• Allow toggling of the dashboard subscription sidebar from the icon (#36244)
• Bigquery: Sync required partition column (#36668, #36677, #36892)
• [chain filters] should not be using inactive fields for joins (#39635)
• Compute results of timestamp/current-date functions during query processing (#21518)
• Consistent Date and Time Formatting for metabase.formatter.datetime (#36559)
• Count :model/User, not :core_user (#36985)
• Create a unified rendering pipeline for formatting (#36015)
• Delete all pruned persisted info records (#39219)
• Don't delete "off" persisted_info records (#39272)
• Download Updated Translations for v49 (#40086)
• Elevate selected filter field values (#40055)
• Ensure consistent percentage formatting across FE and pulses (#36327)
• Ensure results metadata is applied to standalone cards in pulse HTML output (#36323)
• Ensure results metadata is applied to csv files in pulse exports (#36320)
• Error if DB downgrades are required (#37239)
• Export to PDF should have the filter values that were used on the dashboard (#35475)
• Faster sync-fks for Redshift (#38970) (#40062)
• Filter picker search free input (#38907)
• Fix permissions graph performance (#36610, #36797, #36543)
• Fix confusion of expressions with the same name as columns (#39526, #39255)
• Fix isNavigationAllowed (#38703)
• Fix TableBrowser flex (#38324)
• Flaky QueryBuilder.unit.spec.tsx (#37184)
• Format SQL Query option in the Native Query Editor (#9142)
• Hitting enter doesn't save filter changes (#6552)
• Honey SQL 2 Migration (#28684, #28396, #28156, #28165, #28161)
• Introduce describeWithSnowplowEE (#39623)
• Join performance issues (#39633)
• Kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
• Load analytics only when changed using a checksum (#38280)
• Let admins disable user provision on SSO (#36371)
• Migrate the FieldInfo card to Mantine so it can be reused (#38432)
• Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
• Merge viz settings correctly (#36154)
• Merge metadata correctly (#36153)
• Monger does not support Atlas Serverless (#27385)
• Make effective use of Snowflake's query result caching (#20988)
• No view logging for OSS (#39957)
• Only return helpText for supported features (#39766)
• Optimize autocomplete query (#38080)
• Port LastEditInfoLabel (#38109)
• Query metadata within comments leads to cache misses in AWS Athena (#29615)
• Remove unused global cs...

Metabase v0.49.0-RC2

Note

This is a release candidate, we do not recommend you run this in production directly without testing it first

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

Notes

SHA-256 checksum for the v0.49.0-RC2 JAR:

17ef1ea9f544129ecbe8d05230afcc9d8170cef8b57fe2db4108af8de04347ba

Changelog

Enhancements

Dashboard improvements

• Add Sections (predefined layout of empty dash cards) to a dashboard (#38209, #38575)
• Add ‘Replace’ button to dashboard edit mode to let creators swap out dashboard questions with a different question (#36497, #36744)
• Let dashboard creators duplicate tabs and cards (#38208)
• Let creators make dashboard and native query filters required (#18097, #36524, #37709, #39159)
• Let creators make dashboard filters global or tab specific (#31621)
• Default dashboards to a fixed-width to give creators a more predictable canvas (#36358, #10364)
• Tightened up visual design of charts (#36991)

Trend chart improvements (#33411, #9510, #11200, #35551, #8919, #31951, #25670)

Append data to CSV uploads (#35614, #36640, #37220, #38837, #38435)

• CSV upload support for Redshift (#36166)

Serialization via API (#36843, #36240, #38804, #38359, #20632)

Authentication with API key (#2699, #36593, #37234, #37607, #37000, #36999, #36998, #37284, #37085, #37061, #37051, #36347)

Add connection impersonation to Redshift (#38445, #32388)

Embedding improvements

• Let white-labeling admins remove links to metabase.com outside of admin settings, and customize or hide ‘Help’ link (#36966, #35915)
• Setup flow for Static and Public embedding, and embedding feature discoverability (#35961, #36048, #36170)
• Embedding settings cleanup and surface interactive embedding Quick Start guide (#36481)
• Modified setup flow for admins who want to start embedding (#38233)
• Enable public sharing default for new instances (#38609)
• Remove unused global css (#39220, #39020, #39531)
• Add anonymous usage tracking for relevant white-labeling (#37656)
• Add sticky filters on embedded and Public dashboards (#24726)

Models added to Browse Data (#37707, #38730, #38704, #38560, #38661, #38661, #38635, #38518, #38518, #38126, #38107)

Sync column index information (#36452, #36462, #36624)
Let admins disable user provision on SSO (#36371)
Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
Add new audit content to Metabase Analytics (#38524, #38474)
Create a unified rendering pipeline for formatting (#36015, #36559, #36555, #36554, #36327, #36154, #36153, #36323, #36320)
Honey SQL 2 Migration (#28684, #28396, #28165, #28161, #28156)
Bigquery: Sync required partition column (#36668, #36677, #36892)

Metabase Library v2 (#28689)

• Custom columns (#30513, #37173 #36254, #36406, #36717, #36235, #36233, #35982, #35947, #35948, #36710, #36639, #36211, (#36699)
• Computing clauses and columns in the query builder (#36108, #37509, #37507, #37396, #37391, #36978, #37677, #36737, #37629, #37628, #37172, #37171, #37170, #37169, #36736, #37120)
• Filters (#34112, #37369, #36988)
• Notebook steps (#36983, #36516, #36672)
• Add description and fingerprint to displayInfo for columns (#38476)
• Add isTemporalExtraction flag to displayInfo (#37889)
• Add legacy-column->metadata for converting DatasetColumn (#37648)
• Add compatible-type? wrapper that handles JS DatasetColumns (#37609)
• Add aggregation-column and breakout-column (#37873)
• Add tests and fix a special case for FK-filter drills (#38297)
• Add caching for the common case of visible-columns without options (#38409)
• Add display-info for queries (#37675)
• Cache JS <> CLJS metadata conversion (#38375)
• Drop redundant :fields clauses from stages and joins (#36959)
• Drill-through coverage: Add a structured column and fix that case (#38295)
• Ensure :name is unique on returned columns (#39118)
• Fix an edge case where a join-alias is needed on a field ref (#36871)
• Fix pivot drills integration with the FE (#36509)
• Fix white-labeled icon colors of official collections and verified models (#39238)
• fk-filter drills should not appear on native queries (#36660)
• FK-details drill should preserve := filters for other PKs (#38296)
• Fix some edge cases and add more unit tests for zoom in drills (#38275)
• Handle Object.isFrozen() legacy columns as input (#39032)
• Implement automatic-insights drill (#36443)
• joinable-columns on a Join sets source and alias (#39529)
• Look up FK columns in visible-columns, not metadata (#37771)
• Make query= treat missing :base-type as matching (#37727)
• Resolve a string :fk-field-id to a numeric ID if possible (#37079)
• Reorder column filter and distribution drills (#36700)
• Track drill-through unit test coverage (#36601, #38210, #36529)

More stuff

• Add a banner to the top of locales.clj (#37877)
• Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
• Add intermittent test solver (#38159)
• Add SegmentedToggle component from mantine (#37007)
• Add Creator Sentiment Email task (#38787)
• Add stress testing workflow for frontend unit tests (#38081)
• Add junit.xml to .gitignore (#36627)
• Add new AWS global bundle certs for RDS (#32017)
• Add percentage type to metadata (#35124)
• Allow toggling of the dashboard subscription sidebar from the icon (#36244)
• Better UX for required missing parameters on dashboards (#5320)
• Compute results of timestamp/current-date functions during query processing for Redshift (#21518)
• Count :model/User, not :core_user (#36985)
• Delete all pruned persisted info records (#39219, #39272)
• Error if DB downgrades are required (#37239)
• Flaky QueryBuilder.unit.spec.tsx (#37184)
• Filter picker search free input (#38907)
• Fix confusion of expressions with the same name as columns (#39526)
• Fix isNavigationAllowed (#38703)
• Fix permissions graph performance (#36610, #36797, #36543)
• Fix confusion of expressions with the same name as columns (#39255)
• Format SQL Query option in the Native Query Editor (#9142)
• Fix TableBrowser flex (#38324)
• Kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
• Load analytics only when changed using a checksum (#38280, #38622)
• Migrate the FieldInfo card to Mantine so it can be reused (#38432)
• Make effective use of Snowflake's query result caching (#20988)
• Monger does not support Atlas Serverless (#27385)
• Optimize autocomplete query (#38080)
• Port LastEditInfoLabel (#38109)
• Query metadata within comments leads to cache misses in AWS Athena (#29615)
• Refactor drills unit tests structure, split huge file by drill type (#35883)
• Remove Pulses (#34147, #35841)
• Show more billing info on license and billing settings page (#38497, #38153)
• Specify one more guava more explicitly (#38173)
• Switch back to ring-jetty-adapter to address security issue (#39321)
• Test some modals more semantically (#37028)
• Type routing in State (#38645)
• Unify type of timestamp columns (#33577)
• Update deps with security issues (#39286, #37789)
• Update graalvm (#38218)
• Update required parameter reset icon (#39068)
• Update Enterprise readme to 2024 (#37207)
• Use the alias for unfolded JSON columns from previous stages (#39446)
• Wrap literals around expression refs (#38886)
• When updating an alert, don't also update the question (#36866)

Bug fixes

• Autosuggestion in native queries peaks the CPU on instances with > 1M fields (#30588)
• Aurora Serverless v2 fails to verify CA due to RDS Combined CA Bundle not importing all certificate chains (#27790)
• Admin > People header "jumps" when switching from active and deselected users views (#37129)
• Between filter errors out with min > max (#16745)
• Bug when using custom columns to do filters for the past one day/month/year (#37165)
• Bookmark icon should be correct size; and should be filled when an item is bookmarked (#34327)
• Cannot "filter by this column" (#38034)
• Changing groups or databases on data permissions after saving a value causes the client to falsely believe that someone else edited the perm graph (#37811)
• CSV exports of timestamps at midnight (00:00:00) is truncated to date (#14504)
• Custom Column in Models doesn't respect filtering when binning is applied (#26202)
• Canceled Queries are retried with Bigquery Driver (#36623)
• Custom columns that have same name as existing columns cause failure (#39059)
• “contains” and “does-not-contain” returned for the wrong fields (#36856)
• column-filter should come before other column drills (#36674)
• Dashboard Email Subscription seems to cache incorrect settings (#30314)
• drill-thru/pk drill should be returned for query that has multiple PKs on non-PK columns click (#35618)
• Date filter selection from the chart footer is glitchy and results in wrong selection (#22973)
• Datetime filter not working correctly (on mysql) (#8762)
• Date filtering on time-series viz is not available when the second grouping field is not a category type (#34690)
• Date filtering on time-series viz only works if time is added as a first grouping category (#34688)
• Dashboard filters are slow (#37285)
• Extreme slowness while editing parameters on a dashboard (#38225)
• Exports should include formatting everywhere (#17753)
• Error calculating di...

Metabase® Enterprise Edition™ v1.49.0-RC2

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-enterprise:v1.49.0-RC2
Download the JAR here: https://downloads.metabase.com/enterprise/v1.49.0-RC2/metabase.jar

Notes

SHA-256 checksum for the v1.49.0-RC2 JAR:

db8a6d159a541e22cca40ad60db809c33112efdced3d42a1ec98205764a1a66a

Changelog

Enhancements

Dashboard improvements

• Add Sections (predefined layout of empty dash cards) to a dashboard (#38209, #38575)
• Add ‘Replace’ button to dashboard edit mode to let creators swap out dashboard questions with a different question (#36497, #36744)
• Let dashboard creators duplicate tabs and cards (#38208)
• Let creators make dashboard and native query filters required (#18097, #36524, #37709, #39159)
• Let creators make dashboard filters global or tab specific (#31621)
• Default dashboards to a fixed-width to give creators a more predictable canvas (#36358, #10364)
• Tightened up visual design of charts (#36991)

Trend chart improvements (#33411, #9510, #11200, #35551, #8919, #31951, #25670)

Append data to CSV uploads (#35614, #36640, #37220, #38837, #38435)

• CSV upload support for Redshift (#36166)

Serialization via API (#36843, #36240, #38804, #38359, #20632)

Authentication with API key (#2699, #36593, #37234, #37607, #37000, #36999, #36998, #37284, #37085, #37061, #37051, #36347)

Add connection impersonation to Redshift (#38445, #32388)

Embedding improvements

• Let white-labeling admins remove links to metabase.com outside of admin settings, and customize or hide ‘Help’ link (#36966, #35915)
• Setup flow for Static and Public embedding, and embedding feature discoverability (#35961, #36048, #36170)
• Embedding settings cleanup and surface interactive embedding Quick Start guide (#36481)
• Meet embedders at the door (#38233)
• Enable public sharing default for new instances (#38609)
• Remove unused global css (#39220, #39020, #39531)
• Add anonymous usage tracking for relevant white-labeling (#37656)
• Add sticky filters on embedded and Public dashboards (#24726)
• Fix icon colors of official collections and verified models (#39238)

Models added to Browse Data (#37707, #38730, #38704, #38560, #38661, #38661, #38635, #38518, #38518, #38126, #38107)

Sync column index information (#36452, #36462, #36624)
Let admins disable user provision on SSO (#36371)
Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
Add new audit content to Metabase Analytics (#38524, #38474)
Create a unified rendering pipeline for formatting (#36015, #36559, #36555, #36554, #36327, #36154, #36153, #36323, #36320)
Honey SQL 2 Migration (#28684, #28396, #28165, #28161, #28156)
Bigquery: Sync required partition column (#36668, #36677, #36892)

Metabase Library v2 (#28689)

• Custom columns (#30513, #37173 #36254, #36406, #36717, #36235, #36233, #35982, #35947, #35948, #36710, #36639, #36211, (#36699)
• Computing clauses and columns in the query builder (#36108, #37509, #37507, #37396, #37391, #36978, #37677, #36737, #37629, #37628, #37172, #37171, #37170, #37169, #36736, #37120)
• Filters (#34112, #37369, #36988)
• Notebook steps (#36983, #36516, #36672)
• Add description and fingerprint to displayInfo for columns (#38476)
• Add isTemporalExtraction flag to displayInfo (#37889)
• Add legacy-column->metadata for converting DatasetColumn (#37648)
• Add compatible-type? wrapper that handles JS DatasetColumns (#37609)
• Add aggregation-column and breakout-column (#37873)
• Add tests and fix a special case for FK-filter drills (#38297)
• Add caching for the common case of visible-columns without options (#38409)
• Add display-info for queries (#37675)
• Cache JS <> CLJS metadata conversion (#38375)
• Drop redundant :fields clauses from stages and joins (#36959)
• Drill-through coverage: Add a structured column and fix that case (#38295)
• Ensure :name is unique on returned columns (#39118)
• Fix an edge case where a join-alias is needed on a field ref (#36871)
• Fix pivot drills integration with the FE (#36509)
• fk-filter drills should not appear on native queries (#36660)
• FK-details drill should preserve := filters for other PKs (#38296)
• Fix some edge cases and add more unit tests for zoom in drills (#38275)
• Handle Object.isFrozen() legacy columns as input (#39032)
• Implement automatic-insights drill (#36443)
• joinable-columns on a Join sets source and alias (#39529)
• Look up FK columns in visible-columns, not metadata (#37771)
• Make query= treat missing :base-type as matching (#37727)
• Resolve a string :fk-field-id to a numeric ID if possible (#37079)
• Reorder column filter and distribution drills (#36700)
• Track drill-through unit test coverage (#36601, #38210, #36529)

More stuff

• Add a banner to the top of locales.clj (#37877)
• Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
• Add intermittent test solver (#38159)
• Add SegmentedToggle component from mantine (#37007)
• Add Creator Sentiment Email task (#38787)
• Add stress testing workflow for frontend unit tests (#38081)
• Add junit.xml to .gitignore (#36627)
• Add new AWS global bundle certs for RDS (#32017)
• Add percentage type to metadata (#35124)
• Allow toggling of the dashboard subscription sidebar from the icon (#36244)
• Better UX for required missing parameters on dashboards (#5320)
• Compute results of timestamp/current-date functions during query processing for Redshift (#21518)
• Count :model/User, not :core_user (#36985)
• Delete all pruned persisted info records (#39219, #39272)
• Error if DB downgrades are required (#37239)
• Flaky QueryBuilder.unit.spec.tsx (#37184)
• Filter picker search free input (#38907)
• Fix confusion of expressions with the same name as columns (#39526)
• Fix isNavigationAllowed (#38703)
• Fix permissions graph performance (#36610, #36797, #36543)
• Fix confusion of expressions with the same name as columns (#39255)
• Format SQL Query option in the Native Query Editor (#9142)
• Fix TableBrowser flex (#38324)
• Kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
• Load analytics only when changed using a checksum (#38280, #38622)
• Migrate the FieldInfo card to Mantine so it can be reused (#38432)
• Make effective use of Snowflake's query result caching (#20988)
• Monger does not support Atlas Serverless (#27385)
• Optimize autocomplete query (#38080)
• Port LastEditInfoLabel (#38109)
• Query metadata within comments leads to cache misses in AWS Athena (#29615)
• Refactor drills unit tests structure, split huge file by drill type (#35883)
• Remove Pulses (#34147, #35841)
• Show more billing info on license and billing settings page (#38497, #38153)
• Specify one more guava more explicitly (#38173)
• Switch back to ring-jetty-adapter to address security issue (#39321)
• Test some modals more semantically (#37028)
• Type routing in State (#38645)
• Unify type of timestamp columns (#33577)
• Update deps with security issues (#39286, #37789)
• Update graalvm (#38218)
• Update required parameter reset icon (#39068)
• Update Enterprise readme to 2024 (#37207)
• Use the alias for unfolded JSON columns from previous stages (#39446)
• Wrap literals around expression refs (#38886)
• When updating an alert, don't also update the question (#36866)

Bug fixes

• Autosuggestion in native queries peaks the CPU on instances with > 1M fields (#30588)
• Aurora Serverless v2 fails to verify CA due to RDS Combined CA Bundle not importing all certificate chains (#27790)
• Admin > People header "jumps" when switching from active and deselected users views (#37129)
• Between filter errors out with min > max (#16745)
• Bug when using custom columns to do filters for the past one day/month/year (#37165)
• Bookmark icon should be correct size; and should be filled when an item is bookmarked (#34327)
• Cannot "filter by this column" (#38034)
• Changing groups or databases on data permissions after saving a value causes the client to falsely believe that someone else edited the perm graph (#37811)
• CSV exports of timestamps at midnight (00:00:00) is truncated to date (#14504)
• Custom Column in Models doesn't respect filtering when binning is applied (#26202)
• Canceled Queries are retried with Bigquery Driver (#36623)
• Custom columns that have same name as existing columns cause failure (#39059)
• “contains” and “does-not-contain” returned for the wrong fields (#36856)
• column-filter should come before other column drills (#36674)
• Dashboard Email Subscription seems to cache incorrect settings (#30314)
• drill-thru/pk drill should be returned for query that has multiple PKs on non-PK columns click (#35618)
• Date filter selection from the chart footer is glitchy and results in wrong selection (#22973)
• Datetime filter not working correctly (on mysql) (#8762)
• Date filtering on time-series viz is not available when the second grouping field is not a category type (#34690)
• Date filtering on time-series viz only works if time is added as a first grouping category (#34688)
• Dashboard filters are slow (#37285)
• Extreme slowness while editing parameters on a dashboard (#38225)
• Exports should include formatting everywhere (#17753)
• Error calculating display info on filtering with a model (#36400)
• Export formatting for Longitude & Latitude (#38419)
• Execute an Action on embedded Dashboard...