Metabase - Package Updates

[nebulon]

[1.17.0]

• Update Metabase to 0.46.0
• Full changelog
• Metabase can now write to your database with actions. Admins: enable Model Actions on your Postgres or MySQL database. Create a new action from the + New menu, or from the new Model details page.
• Upgraded MongoDB driver, including a smarter schema sync process to handle variable keys, support for models, fast joins, custom expressions, additional aggregations, and more.
• Improved sync and fingerprint performance, reducing the load on your database and costs for your data warehouse.
• New dropdown options in dashboard filters.
• A new model details page: view a list of questions using the model, the model's schema, and its actions.
• Smarter tooltips are more useful in multi-series charts with totals and percentages, time series with days of the week, and more
• More static viz improvements for subscriptions and alerts.
• New link cards for dashboards.
• New visualization type: Detail (displays a row as an easy-to-read card).
• The Clickhouse partner driver is here and available for Metabase Cloud.
• Deprecation notice: we're deprecating Google Analytics 3, and will remove the driver from our future releases after it stops accepting new events (in July of 2023). We don't have plans of supporting GA4. (But link to an article explaining how to use it with BigQuery.)

[girish]

[1.17.1]

• Update Metabase to 0.46.1
• Full changelog
• Fix implicit actions not created in a deterministic order (#29605)
• Currency list: Add Mauritania ouguiya (MRU) as currency (#29545)
• drill-through not working correctly in legend for stacked charts (#29840)
• SSO mapping: users are removed from groups that are not mapped (#29718)
• Date Filter (Specific Dates) doesn't show first days of the month (#29692)
• Big xslx file downloaded from BigQuery are corrupted in v0.45.3 and were not in v0.45.1 (#29118)
• Infinite loop, logging at warn level, filling disk for a GCP BigQuery connection (#28868)
• Dashboard sticky filter incorrectly positioned, when moving between dashboards (#26230)
• Unable to properly filter on an aggregation (#22230)

[nebulon]

[1.17.2]

• Update Metabase to 0.46.2
• Full changelog
• Include checklist task to migrate off h2 (#30126)
• Users with No Access to the Collection Our Analytics are not able to define a dropdown list from models/questions (#30355)
• MongoDB Custom Column SUM with arithmetic operation producing wrong MongoQL (#30262)
• Race condition after deleting the Sample Database (#30152)
• [Snowflake] Syntax error: unexpected "?" when using filters inside window frames, or inside INTERVAL syntax (#30103)
• Revision history erratically loads and removes historic changes (#30030)
• "People can pick" ->multiple values in dashboards and custom dropdown filter don't go together (#29997)
• Changing column order on model view then almost saving without preview breaks model with custom columns (#29951)
• Metric tooltip description gets cut (#29862)
• Metadata is required when trying join on an SQL based questions (#29795)
• Adding more than one field filter blows up the frontend in Mongo and MySQL (#29786)
• Filter values no longer work inside single quoted strings (#29690)
• Serialization v1 errors when trying to load an instance with actions (#29528)
• Cannot get into a card from a dashboard on "no self-service" permissions (#29076)
• "First day of the week" not changing calendar widget on filters (#13899)

[nebulon]

[1.17.3]

• Update Metabase to 0.46.3
• Full changelog
• This release fixes a security issue where native models enabled people without SQL permissions to create and edit SQL snippets. For more info, see our security advisory.
• Could not read SSL key file when attempting to connect to Postgres DB with SSL using PKCS8 DER key file (#30717)
• Tables in reference section are not ordered alphabetically (#30727)
• "Bulk select" checkbox selects all collection items (pinned items included) (#30571)
• Invalid query generated in v46 with BigQuery (#30648)
• Field custom mappings not working on (public) embedding (#29346)
• Custom mappings are broken (#29347)
• Fix custom mapping doesn't work on dashboard (#30217)
• User session interferes with signed embedding if non-admin user has sandboxed permissions (#30535)
• Incorrect query on nested questions in BigQuery (#30610)
• Snowflake sync is consuming more resources than necessary (#26054)
• Can't turn off "Also change sub-collections" settings and apply permission changes only for the selected collection (#30494)
• dump command fails to serialize toucan2 records (#29322)
• When changing collection permissions "include subcollections" doesn't work (#20911)
• Chart Settings allows you to drag fields when there is only 1 item in the list (#28973)
• Link for Cloud firewall docs renders incorrectly (#30317)
• SmartScalars should aggregate the same way as Scalars (#25637)

[girish]

[1.17.4]

• Update Metabase to 0.46.4
• Full changelog
• This release removes the activity feed from Metabase. The /activity page displayed recent things people had made in Metabase: new questions, dashboards, etc. This activity page, however, failed to account for group permissions when displaying these items, so anyone could see what anyone else was making. We may reintroduce the activity page in the future, but we're removing it for now to address this metadata visibility issue.
• Link Cards that link to internal entities should open the object in the same iFrame in Full-App embedding (#30851)
• Activity feed leaks metadata (#30695)
• Mongodb won’t work if version does fall into the “semantic-version-gte” pattern (Percona) (#29678)
• 46 regression: datetimeAdd is apparently supposed to allow non-integer amounts (#29638)
• If you bring the sample dataset back then go to 'Browse Data' it does not appear unless you refresh the page (#29496)

[nebulon]

[1.17.5]

• Update Metabase to 0.46.5
• Full changelog
• MySQL default timeout needs to be increased (#31102)
• Make the "save" modal context-aware (#28802)
• When setting/resetting password, sign in with your new password shouldn't make you retype your password again (#5063)
• Cannot run native queries against MongoDB unless explicitly selecting the table (#15946)
• Add to Dashboard/Save Question Menu doesn't respect Collection Alphabetical order as in Main Menu (#31425)
• Downloading data from cards in dashboards does not respect download limit (#31393)
• Respect alphabetical order of collections in "Move" modal (#31294)
• Attempting to upload RSA private key (PEM PK8) to connect to Snowflake fails with Private key provided is invalid or not supported (#31273)
• Dump broken on 46.x on instances with more than 65K categorical fields (#31230)
• Question with source query containing aggregation and sorting by that aggregation fails on mongodb (#30874)
• Upgrade to 1.46 fails due to invalid state in permissions table (#30872)
• Reverting to an earlier version of a dashboard creates an erroneous event in revision history (#30776)
• Model caching not working anymore in 0.46.x with MySQL if query takes more than 29 seconds (#30723)
• Question breaks after trying to create pivot table and edit on aggregated results that are not grouped (#30711)
• Not able to Enable/Disable Actions when Choose when syncs and scans happen is Enabled (#30699)
• Native editor buttons are incorrectly rendering on top of model metadata screen (#30680)
• Unable to summarize models (#30112)
• Sporadic "we're a little lost..." pop-up when scrolling up and down my query after expanding a row (#30039)
• Basic actions (CUD) display order is non-deterministic (#29593)
• Do not offer to save database changes if there were none (#29388)
• There is no confirmation when running an action without parameters in dashboards (#28981)
• SSO does not respect Metabase subpath (#28650)
• MB_SESSION_TIMEOUT behavior does not match documentation (#28454)
• Doing "Zoom in" from dashboard drops fields from joined tables (#27380)
• Google Sign-in ignores "Notify admins of new SSO users" toggle (#24381)
• Drill-through to questions with add columns (implicit join) causes no filtering to be defined (#23293)
• Better error message/validation if SAML Keystore has no private key (#19500)

[girish]

[1.17.6]

• Update Metabase to 0.46.6
• Full changelog
• Remove task snowplow event (#31156)
• Incorrect query on nested questions in BigQuery (#30610)
• Snowflake won't sync without password (user using only private key) (#30376)
• Don't auto-run sql questions when there's an edit (#30165)
• Error custom column "only binary :- is supported" (#29858)

[nebulon]

[1.17.7]

• Update Metabase to 0.46.6.1
• Full changelog

[girish]

[1.17.8]

• Update Metabase to 0.46.6.2
• Full changelog

[girish]

[1.17.9]

• Update Metabase to 0.46.6.4
• Full changelog

[girish]

[1.17.10]

• Update Metabase to 0.46.7
• Full changelog
• Prevent open redirects for JWT/SAML (#32816)
• Certain invalid URL causes error response from Jetty (#23277)
• Very Inefficient query causing Metabase DB load to go to 100% [v0.46.6.4] (#32737)
• LDAP Attribute sync no longer works (#32243)
• "Expected native source query to be a string, got: clojure.lang.PersistentArrayMap" on nested queries (#32121)
• Snowflake won't sync without password (user using only private key) (#30376)
• Resizing columns in pivot tables in serialization breaks the card on load (#30130)

[nebulon]

[1.18.0]

• Update Metabase to 0.47.0
• Full changelog
• cancels ongoing cards when saving a dashboard
• refactor: change from stub to spy so that we can also see in the inspector that the request has been cancelled
• test that the data will eventually be displayed

[girish]

[1.18.1]

• Update Metabase to 0.47.1
• Full changelog
• Switch pulse email sending to use bcc instead of sending a seperate email (#33604)
• Show new syncing tables as greyed out in data reference page (#33152)
• Bottom corner radius on buttons looks weird on new dashboard grid (#31587)
• Update default and min size constraints for dashboard cards (#31408)

[girish]

[1.18.2]

• Update Metabase to 0.47.2
• Full changelog
• Clear cache when performing version upgrades (#33457)
• Performance improvement in notebook editor (#33676) (#12378)
• Metabase will not let you update the cert if it was rotated (#33452)
• Some table columns are unable to be rendered (#33279)
• Download results (.csv, .json, .xlsx) request does not include subpath when deploying on subpath (#33244)

[nebulon]

[1.18.3]

• Update Metabase to 0.47.3
• Full changelog
• Use HTTPS when getting version-info (#34310)
• Better deduplication for entities loader api queries (#34174)
• Fix CSV uploads aren't possible when native query editing is disabled (#33990)
• bad gateway 502 for API via reverse proxy (POST request ignores 'location' v0.47.2) (#33910)
• Provide a heads up when Metabase is upgraded with what’s new (#33165)
• Can't apply category filters when a question has grouping and aggregation (#34279)
• Summarizing or sorting in query editor after Exploring results in a SQL question and creating a Custom Column breaks query editor (#34247)
• Other count displays incorrect value when Language set to Arabic or Arabic (Saudi Arabia) (#34236)
• Date filters - inconsistent filter values displayed when a question is opened from a filtered dashboard (#34129)
• UI suggests it's possible to delete an archived collection (#33996)
• CSV uploads aren't possible when native query editing is disabled (#33971)
• Search bar font size is too small on Safari (#33930)
• Summarizing by custom date column does not allow date grouping (#33504)
• Custom ranges in conditional formatting don't work (#33229)
• After hiding column in table settings on question based on another question, all joined columns unchecked in notebook editor when still selected (#32374)
• Unable to add joined columns in table settings after removing through notebook editor on nested Question (#32373)
• Inputting some values into Whitelabel "Landing Page" can cause the entire frontend to break (#18004)

[girish]

[1.18.4]

• Update Metabase to 0.47.4
• Full changelog
• Implement unreturnedConnectionTimeout in c3p0 in an env var (#34377)
• load-from-h2 fails on master with Command failed with exception: ERROR Clearing default entries created by Liquibase migrations... (#34505)
• DashboardTab missing from copy command (#34411)
• Dashboard loses effective filter values when auto-apply is turned off (#34382)
• We don't seem to be updating certificates when updating the connection (#33116)
• Hardly visible expand icon on collection hover (#31394)

[girish]

[1.18.5]

• Update Metabase to 0.47.5
• Full changelog
• Fix SQL autocomplete is hard to use because keywords are shown instead of tables and columns (#34601)
• Replace java-time namespace with java-time.api (#34506)
• Snowflake Database Setting allows you to input small caps role but breaks connection afterwards (used to work for both in 1.46.8) (#34829)
• 404 when downloading results on embedded questions on sub-paths (#34634)
• Splitting multidimension questions that only have 1 metric (#34618)
• The slack token is logged in plain text (#34616)
• Event Icon for "Balloons" is a cake (#34581)

[nebulon]

[1.18.6]

• Update Metabase to 0.47.6
• Full changelog
• Error: Field X is not present in the Query Processor Store. (#34950)
• Selecting filter on date, then going back and selecting expression results in error (#34794)
• Auto pivot is freezing query editor on high cardinality fields (#34677)
• JavaScript TypeError when removing dashboard filter (#33826)
• Can't go back with browser back button from "Table metadata" (#33784)
• Large column names should wrap in the sidebar (#31086)

[girish]

[1.18.7]

• Update Metabase to 0.47.7
• Full changelog
• Disable auto-commit (enable transactions) for read-only connections (#35268)
• Adding check for column before getting friendly name (#34761)
• Support subtracting intervals (#23423)
• Graphing chart with date filter at 24 months is broken (#35129)
• Serialization v2 export doesn't include parameter_card entity_ids which breaks the import (#35097)
• Dashboard reversion should skip cards that have been deleted or archived (#34884)
• Serialization v2 duplicates entities loaded with serialization v1 on old versions (#34871)

[nebulon]

[1.18.8]

• Update Metabase to 0.47.8
• Full changelog
• Fix exporting dashboard with configured click_behavior (#35913)
• Fixing bad performance due to massive pprint statements (#35895)
• Fix serdes of click_behavior on dashcards (#35717)
• avoid calling fetchCardData in undoRemoveCardFromDashboard for virtual cards (#35545)
• restore correct position when undoing dashcard tab movement or deletion (#35502)
• Respect "enable nested queries" setting and database's "nested queries" feature (#35490)
• Add an option in the /admin/settings/email to opt-in to CC recipients (#34293)
• Export throws a Unexpected character ('b' (code 98)) (#35880)
• Export throws a NullPointerException (#35855)
• API returns 500 instead of 404 when visiting an non-existing card (#35692)
• A big warning that if you use CSV uploads in the sample database in the cloud, your data will disappear (#35638)
• Serialization import doesn't remove dashboardcards in the target instance (#35420)
• Filters blink when there are many lines of filters in an embedded context with headers=false (#35078)
• Users with read-only permissions to collections are shown "edit question" option in dashboard cards (#35077)
• Text weirdly wrapped in column dropdown in Polish language (#35047)
• Pivot viz fails on a nested question (#35025)
• '-' sign misplaced in shortened visualization of currency type (#34242)
• Log why Serialization v2 fails when trying to export a dashboard that contains cards in outside collections (#33882)
• Click behavior: dashboard and saved question links are not preserved during export / import (#33699)
• Don't offer to create models or use nested questions on 3rd party drivers which don't support it (#33401)
• e.some is not a function breaks the FE on the filter modal (#32985)
• Linked fiters won't work if you use a question to populate filter values (#31218)
• Disabled "Nested Queries" setting is not always respected (#28908)
• Filter dropdown not showing remapped values on the dashboard (#21528)