What's new in Metabase 0.49.5
Apr 11, 2024
- When exporting to CSV (or JSON or XLSX) from an embedded report, the file only contains 'Unknown parameter :format_rows.' (#41240)
- Downloading results of an embedded question (via iframe) fails because of "Unknown parameter :format_rows" (#40959)
- Notebook query preview exists even before the data source is selected (#40608)
- Incorrect results from SQL query referencing saved question with more than 1,048,575 rows (#24969)
- Fix naming a filter offset or limit breaks dashboards (#40821)
New in Metabase 0.49.4 (Apr 10, 2024)
- Enhancements:
- Asynchronously load libraries for png and pdf exports
- Bug fixes:
- Fix "instace analytics" typo
- Signed Embedding without Title will remove all the tabs of a dashboard as well
- SQL generated for datetime "is empty" filter on MSSQL is not correct
- Casting integer to Datatime via Table Metadata makes column unusable
- "No method in multimethod 'coerce-temporal' for dispatch value: [nil java.time.LocalDateTime]" when evaluating null datetimes
- Bigquery: Can't search field values for required partition tables
- Iframe embedding overflow widgets issue
- GUI model joining native ones break with column not found error
- Waiting for result tab title contains js code
- State of the FE gets lost on detail views when there are multiple joins to the same tables
- Manually choosing Axis in chart settings will break subscription
- Embedding height is not dynamic
- View Details: "is connected to:" uses wrong PK for query with join
New in Metabase 0.49.2 (Mar 28, 2024)
- Enhancements:
- Handle invalid file drop (#40690)
- 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)
New in Metabase 0.49.1 (Mar 21, 2024)
- 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)
New in Metabase 0.48.9 (Mar 19, 2024)
- 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)
New in Metabase 0.49.0 RC 2 (Mar 11, 2024)
- 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 display info on filtering with a model (#36400)
- Export formatting for Longitude & Latitude (#38419)
- Execute an Action on emb...
New in Metabase 0.48.8 (Mar 5, 2024)
- Bug fixes:
- Forcefully reload table/card metadata when there are no fields (yet) (#39311)
- Hide the default maps (#39079)
- Add entity-id to Serdes v1 as an optional flag (#38961)
- Allow official collections inside personal collections (#38823)
- Include filters when exporting dashboard to PDF (#38231)
- Export to PDF should have the filter values that were used on the dashboard (#35475)
- Enabling "don't send if there aren't results" in a subscription won't send the text cards (#39190)
- Currency Data Type Is Not Inferred in Summarized Visualizations (#38022)
- Default values are not respected for pinned questions in collections in v48 (#37831)
- Pie chart wedge hover incorrectly displays total for wedges smaller than 0.30% (#33342)
- Minimum slice percentage effects actual values on Pie charts (#32430)
- Subscriptions will fail when parameter doesn't exists (#30100)
- Cannot connect to Snowflake via SSH (#17663)
New in Metabase 0.48.7 (Feb 23, 2024)
- Bug fixes:
- We should never run get-field-values on a dashboard load if the field does not have field values in the metabase_fieldvalues table (#38826)
- Date filtering change between v0.48.3 and v0.48.4. looks timezone related (#38248)
- Relative date filter with time works in Field Filters different for SQL variables than for GUI (#38037)
- Change native SQL datetime range field filters to be inclusive of the end minute (#33492)
- Date filters giving inconsistent results, depends on filter mode (#30454)
- Update group-by-week-test to use database timezone id (#38805)
New in Metabase 0.48.6 (Feb 13, 2024)
- Bug fixes:
- Analytics should load only when changed, via checksum (#38627)
- Load analytics only when changed using a checksum (#38564)
- Newly added MySQL DB tables not showing up, but old ones do show up (#38499)
- Don't instrument any namespaces for mu.fn/fn in production (#38482)
- Remove impersonation feature from Redshift driver (#38393)
- Ability to customize table row limit in subscriptions (#32165)
- Custom Destination to Public Dashboard URLs is broken on Static Embeds (#38640)
- X-Ray failure with message "Cannot determine source table..." (#38618)
- ClassCastException: class clojure.lang.Keyword cannot be cast to class java.lang.Throwable (#38516)
- Some relative date filters don't work for custom expression columns (#35373)
- Date filters giving inconsistent results, depends on filter mode (#30454)
- Metabot 2.0 failing when context length exceeded (#29932)
New in Metabase 0.49.0 RC 1 (Feb 12, 2024)
- Enhancements:
- Models In Browse Data Follow Up (#38635)
- Analytics should load only when changed, via checksum (#38622)
- Default enable-public-sharing to false for existing instances, and true for new ones (#38609)
- add section icon and use in dashboard edit mode (#38575)
- Add filters to Browse models (#38560)
- Update auditv2 content for 49 (#38524)
- Improve look of models in Browse data (#38518)
- Show more billing info on license and billing settings page (#38497)
- Add a link to Metabase Analytics -> Question overview / Dashboard overview in the question/dashboard detail page (#38474)
- Add connection impersonation to Redshift (#38445)
- FE: add UI for uploading from collections list (#38435)
- Send a Snowplow event to track Serialization (#38359)
- Fix TableBrowser flex (#38324)
- Load analytics only when changed using a checksum (#38280)
- Meet embedders at the door - minimal edition (#38233)
- Update graalvm (#38218)
- Add Sections (pre-defined layout of empty dash cards) to Dashboard (#38209)
- Let creators duplicate dashboards tabs and cards (#38208)
- specify one more guava explicitly (#38173)
- Add BE for routing billing status (#38153)
- More tidying prior to Models in Browse Data (#38126)
- Port LastEditInfoLabel (#38109)
- Initial tidying before Models in Browse Data (#38107)
- Optimise autocomplete query (#38080)
- Add a banner to the top of locales.clj (#37877)
- Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
- update deps (#37789)
- Required parameters: add to native queries (#37709)
- Basic version of Models in Browse Data (#37707)
- Add anonymous usage tracking for relevant white-labeling (#37656)
- Delete API keys when their group is deleted (#37607)
- Avoid failing call to /api/model-index (#37284)
- Error if DB downgrades are required (#37239)
- Add last_name to ApiKey users (#37234)
- CSV appends: append through model page (#37220)
- Update enterprise readme to 2024 (#37207)
- Admin > People header "jumps" when switching from active and deselected users views (#37129)
- RFC: kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
- Oops - remove API bits from ApiKey model (#37085)
- Return group instead of just group_name for ApiKeys (#37061)
- Add a DELETE endpoint for API Keys (#37051)
- Test some modals more semantically (#37028)
- Add SegmentedToggle component from mantine (#37007)
- GET /api/api-key endpoint to list API keys (#37000)
- PUT /api/api-key/:id/regenerate endpoint to regenerate an existing API key (#36999)
- PUT /api/api-key/:id endpoint to update API key names/groups (#36998)
- Tighten visual design of charts (#36991)
- count :model/User, not :core_user (#36985)
- Help white-labeling admins remove links to metabase.com outside of admin settings (#36966)
- Bigquery sync partitioned fields (#36892)
- When updating an alert, don't also update the question (#36866)
- Serialization API (#36843)
- FE support partial permissions graph (#36797)
- Fix dashcard-filter connection edge cases (#36760)
- Add "Replace question" action to dashboard cards (#36744)
- FE: address the issue with segments in suggest.ts once products/QP provides a fix (#36710)
- Bigquery sync table require filter (#36677)
- Bigquery: Sync required partition column (#36668)
- Add junit.xml to .gitignore (#36627)
- Sync index info: mongo (#36624)
- Fix permissions graph performance (#36610)
- Auth with API Key (#36593)
- Consistent Date and Time Formatting for metabase.formatter.datetime (#36559)
- Apply Consistent Formatting to Excel Artifacts (#36555)
- Apply Consistent Formatting to JSON Artifacts (#36554)
- adding perm-graph filtering on db or group id (#36543)
- Let creators make dashboard and native query filters required (#36524)
- Let creators swap out dashboard questions with a different question (#36497)
- Embedding settings cleanup and surface interactive embedding Quickstart (#36481)
- Sync index info (#36462)
- Sync column index information (#36452)
- Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
- Default dashboards to a fixed width to give creators a more predictable canvas (#36358)
- Write a POST /api/api-key endpoint to create an API key (#36347)
- 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)
- FE- Migrate functions used in ExpressionEditorTextfield to MLv2 query (#36254)
- Allow toggling of the dashboard subscription sidebar from the icon (#36244)
- Create a test to prevent serialization bugs with new settings (#36240)
- Second stage shows the wrong name (Total: binned) (#36235)
- FE - Migrate suggest.ts to use MLv2 for computing columns (#36233)
- Create the Embed Modal (#36170)
- Merge viz settings correctly (#36154)
- Merge metadata correctly (#36153)
- Milestone 1 - Refactor Public Links and Static Embed Flow (#36048)
- Create a unified rendering pipeline for formatting (#36015)
- Setup flow for static/public embedding & embedding feature discoverability (#35961)
- FE - Expressions in FilterPicker without legacy query (#35948)
- FE - Expressions in AggregationPicker without legacy query (#35947)
- White-labeling: Customizing or hiding “Help” link (#35915)
- Refactor drills unit tests structure, split huge file by drill type (#35883)
- Migration to remove the legacy pulses (#35841)
- Support arbitrary date comparison (#35551)
- Add percentage type to metadata (#35124)
- Unify type of timestamp columns (#33577)
- Trend chart improvements (#33411)
- Add new AWS global bundle certs for RDS (#32017)
- Query metadata within comments leads to cache misses in AWS Athena (#29615)
- Metabase Lib v2 (#28689)
- Honey SQL 2 Migration, Continued [47-49] (#28684)
- Remove Honey SQL 1 as a dependency (#28396)
- Migrate :sqlserver driver to Honey SQL 2 (#28165)
- Migrate :presto and :presto-jdbc drivers to Honey SQL 2 (#28161)
- Migrate :bigquery-cloud-sdk driver to Honey SQL 2 (#28156)
- Option to rollback changes in failed serialization load (#20632)
- Allow to configure mandatory filters in Dashboards (#18097)
- Format SQL Query option in the Native Query Editor (#9142)
- Hitting enter doesn't save filter changes (#6552)
- Better UX for required missing parameters on dashboards (#5320)
- Remove Pulses while warning customers about it (#34147)
- Bug fixes:
- Instance Analytics titles drop after page load (#38566)
- Export formatting for Longitude & Latitude (#38419)
- Unsaved dashcards with mapped params error when switching tabs (#38245)
- Extreme slowness while editing parameters on a dashboard (#38225)
- Cannot "filter by this column" (#38034)
- Changing groups or dbs on data permissions, after saving a value causes the client to falsely believe that someone else edited the perm graph (#37811)
- Refreshing after setting a table to be sandboxed causes an error (#37774)
- Make query= ignore absense of base-type and effective-type in field references (#37659)
- Pie chart legend percentages are vertically not aligned with their label (#37635)
- Question filters are not being updated if there are breakout clauses for the same column (#37463)
- Support constants in expressions (#37461)
- Dashboard filters are slow (#37285)
- filter-args-display-name doesn't handle exclude date filters (#37219)
- “contains” and “does-not-contain” returned for the wrong fields (#36856)
- removeClause throws "Cannot remove the final join condition" error (#36690)
- column-filter should come before other column drills (#36674)
- Cancelled Queries are retried with Bigquery Driver (#36623)
- When modyfing the "fields" clause, remove the clause entirely if it becomes equivalent to not having the clause at all (#36574)
- "View details" (PK) drill thru on non-PK value for a row with multiple PKs only adds a filter for one of the PKs, nondeterminiate (#36426)
- Error calculating display info on filtering with a model (#36400)
- zoom-in.timeseries isn't returned in all known cases (#36173)
- MongoDB nested fields not showing in v0.47.x (#35938)
- drill-thru/pk drill should be returned for query that has multiple PKs on non-PK columns click (#35618)
- SAML auth page is weird when set by env vars (#33264)
- Autosuggestion in native queries peaks the CPU on instances with > 1M fields (#30588)
- Joining on aggregated dates via the editor generates "No matching signature for function TIMESTAMP" (#27969)
- Pivot table with the filter on a date column breaks dashboard sending (#27941)
- Aurora Serverless v2 fails to verify CA due to RDS Combined CA Bundle not importing all certificate chains (#27790)
- Date filter selection from the chart footer is glitchy and results in wrong selection (#22973)
- On Date filter returns no results on a summarized question (#18769)
- Renamed columns in CSV/JSON exports (#18572)
- Exports should include formatting everywhere (#17753)
- Between filter errors out with min > max (#16745)
- [result_metadata] Implicit binning on longitude from SQL question results in error (#16672)
- CSV exports of timestamps at midnight (00:00:00) is truncated to date (#14504)
- Grid Map "Zoom In" broken for "Custom Questions" (#11210)
- Datetime filter not working correctly (on mysql) (#8762)
New in Metabase 0.48.5 (Feb 6, 2024)
- Enhancements:
- Add Hebrew Language Support (#38045)
- CSV/Excel attached file in Pulses is truncating to 2000 rows. (#7622)
- CSV uploads: Expand valid date formats to include one digit days (#38276)
- Bug fixes:
- [MLv2] Add caching for all the foo-columns functions (#37586)
- Not able to switch between databases after a question is created (#38354)
- Dashboard subscription for auto generated dashboards is broken (#38350)
- Reverting a query that has parameters to a previous version does not use the parameters on the reloaded dataset (#38176)
- Trend chart gives misleading output for some date combinations (#38122)
- Mongo sessions do not work with hidden member deployments (#37713)
- Metabase problem with directConnection connection setting for MongoDB (#37209)
- MB_UNAGGREGATED_QUERY_ROW_LIMIT is limiting in-product download queries (#37642)
- Summarizing timestamps by month handles time zones incorrectly in Snowflake (#37065)
- "Run selected text" in Native editor does not include filter widget value and can return incorrect results (#16584)
- Native query has 2000 limit even for aggregated data (#12729)
New in Metabase 0.48.4 (Jan 29, 2024)
- Bug fixes:
- Exclude metabase.sync* and metabase.upload* from malli instrumentation (#38206)
- switch to regenerator-runtime and update follow-redirects to silence Snyk warnings (#38124)
- CVE updates: lambdaisland/uri, aws sdk (for ions), specify guava for googleanalytics (#38118)
- 🤖 backported "Handle multiple date filters for the same template tag" (#38110)
- Field values cache needs to check permissions (#38104)
- Upgrade jsrsasign to v11.0.0 (#38075)
- Handle multiple date filters for the same template tag (#38070)
- Don't try to compute query-hash for cards without queries (#38007)
- Fix race-condition that could revert (un)subscriptions (#37954)
- Handle an error of building UI parameters during dashboard fetching (#37790)
- Add personal-only to collection endpoint (#37608)
- [MLv2] Add caching for all the foo-columns functions (#37586)
- [MLv2] [BE] Cache xxxColumns functions (#37573)
- Pass email and siteURL to metabase.com/help/connect (#37571)
- Missing databasechangelog index for new instances (#37552)
- [MLv2] Only allow implicit join on a column if its real ID is known (#37536)
- Exclude snippet and card template tags from parameters returned from BE endpoints (#37405)
- Update first_name and last_name when Google SSO used to login (#35628)
- Env var to disable SNI check in Jetty (#29660)
- NPE in metabase.driver.sync/schema-patterns->filter-fn* (#38156)
- Settings with default of false now return null (#38138)
- Metabase won't see schemas other than public or the default namespace of the user in snowflake (#38135)
- Dashboard Time Filters Don't Work for Cards with SQL Date Variables (#38012)
- Initializing MB from a config file is broken (#38009)
- Text filters shown as input box in embed instead as dropdown (#37914)
- We index the audit v2 views on instances that don't have the audit features (#37896)
- site-uuid changes (#37801)
- Unable to translate string "{0} database {1} default timezone is {2}" to fr (#37730)
- 0.48.3 : SQL Server dynamic ports (#37655)
- Database Permissions Display breadcrumbs don't handle schemaless DBs (#37650)
- Some filters not working in v0.48.x (#37623)
- Malli.fn :: Invalid input in query-hash and select-keys-for-hashing (#37345)
- Public native questions with snippets don't work (#37270)
- Sync takes a massive amount of time to start (#37250)
- Pivot visualization no longer displays after editing - 'invalid metadata returned' error (#37083)
- displayInfo returns unexpected result for a column group (#37067)
- Can't Edit/Download question on a dashboard when Title is removed (#36788)
- Search input in the filter modal gets focused on hover (#36734)
- qp.timezone/database-timezone-id returns nil for ::db-from-store (#36662)
- Unable to update user first and last name when Google SSO used (#35970)
- Split Axis not working for combo charts (#35727)
- Greeting page briefly loads before redirecting to custom homepage (#35454)
- Uncaught TypeError when setting custom click behavior for a question (#35354)
- Typing on search bar before dashboard has finished rendering gets the search bar in non-functional state (#35099)
- An alert set on a model reverts the models customized column names (#35091)
- Can't re-order tabs with long names (#34970)
- Visualization-specific question icons don't display on first load (#34850)
- Default click behavior does not have selected state (#34848)
- Ambiguous dashboard URL when filter is called "tab" (#34784)
- Better debounce the SQL editor (#34330)
- Custom homepage breaks search when used before redirect (#34226)
- CSV upload icon will be gone after enabling CSV upload for the first time then go back to the collection. (#34078)
- Turn model caching on succeed but UI button doesn't update the text (#26470)
- Discrepency in the unarchive UI between admins and non-admins (#26169)
- Pinning a native question that references another question will fail to render (#25022)
- Cursor didn't show pointer when passing the icon on mobile screen (#24160)
- Possible to config or resend Email on EOF Error (#23030)
- Pivot Table collapse/expand rows doesn't work for single question in Public/Embedding (#21847)
- Login redirects to root, if already logged in and visiting URL like /auth/login?redirect=.. (#14436)
- Time column ignore formatting and always shows 12h-style AM/PM (#11398)
New in Metabase 0.48.3 (Jan 12, 2024)
- Bug fixes:
- Restore GET /api/dashboard endpoint (#37455)
- Validate json settings during init (#36182) (#37313)
- Fixing case of invalid graph.dimension (#37279)
- CSV uploads: support more date formats (#37078)
- Updating honeysql alias in dev ns (#36758)
- Auditv2 prevented startup (#37480)
- [Serialization] Skip Metabase Analytics and Custom reports collections when exporting content (#37453)
- Embeded dashboard takes longer and longer to display. (#37289)
- Slack integration failure on dashboard subscription (#37266)
- Multi series questions won't get imported when using serialization (#37232)
- Fix hsql import in dev.clj (#36757)
- Invalid json for env variable settings breaks site (#36182)
- Setting all reports to hide with no results breaks dashboard subscription (#34777)
- Timestamp column be converted twice in 2-layer questions query (#33861)
- Number Visualisation show wrong field in dashboard subscription (#32362)
- Snowflake driver won't use JDBC options (#27856)
- Funnel charts with "Month of Year" type dimension and ordering can't render in Static Viz (#26944)
New in Metabase 0.48.2 (Jan 5, 2024)
- Bug fixes:
- Fix issue with model index search (#37308)
- Fix card loading state in different tabs when parameters change (#37134)
- show error and disable save button when create metric fails (#36874)
- CSV upload support for Redshift (#36166)
- Ability to customize table row limit in subscriptions (#32165)
- Subtracting two temporal values should yield an interval (#37263)
- Caching not working for (all) mongo questions (#37140)
- Malli warning in metabase.models.recent-views/update-users-recent-views! (#37030)
- Confusing copy in confirm modal when changing table data access to Sandboxed (#34911)
- We're not signaling when a card is loading if you change the filters on a dashboard and switch tabs (#33767)
- [Serdes v2] Error parsing JSON when exporting data model (#31553)
- SparkSQL driver doesn't work well with capital database-types (#27466)
New in Metabase 0.48.1 (Dec 20, 2023)
- Bug fixes:
- .48.0 upgrade: js front error regression on some questions (#36895)
- Cannot override location for /plugins/instance_analytics (#36845)
- Dashboard filter values causing card errors since update to v48 (#36841)
- Column mapping can overflow the sidebar when editing model metadata (#36163)
- Verified question icon doesn't update (appear/disappear) unless page reloads (#32505)
- Whitelabel landing page string allows whitespace which leads to "page not found" (#25482)
New in Metabase 0.48.0 RC 1 (Dec 5, 2023)
- The new Metabase analytics collection is only available for the Enterprise Edition. Including a summary here just as an FYI.
- Get a comprehensive audit log of what’s been going on in your Metabase, with investigative tools to take action when you need to. The expanded set of internal data points includes configuration data: no more mornings lost asking around to find out who turned off SSO, when, and why. You can trace it back in your usage analytics and see who you need to follow up with.
- Set up alerts on auditing questions
- See exactly who’s using Metabase, when they’re using it, how often they’re using it, what people are looking at most, and more.
- Make the most valuable dashboards, questions, and models more accessible on the Metabase home page, in official collections, or with subscriptions) so your data team isn’t tied up with ad hoc requests.
- Check your usage analytics for the slowest questions and dashboards, and see where you can speed things up by caching results, or retire something that’s not in use anyway.
- Better overviews for deactivating users, seeing where entity dependencies exist, and managing data migrations.
- Initially available only to Admins and people with the "Monitoring" application permission, you can grant permissions to view the Metabase analytics collection to other groups.
- Customize reports based on a set of models in the Metabase analytics collection.
- Other improvements:
- Auto-connecting dashboard filters. Connect one card to a filter, and Metabase will connect all other dashboard cards to that filter on the same field if the field is present).
- Move cards between dashboard tabs.
- Filter search results by collection type, person who edited, and more. Find stuff that’s been recently created or touched so you know it’s trustworthy.
- Add and remove columns in bulk in table settings.
- Auto-assign Primary Key to CSV uploads.
- If you have basic actions enabled on the model, update and delete items directly via their object detail.
- X-ray indexed records in a table or model.
- New admin setting for SameSite session cookies for authenticating embedding users across domains.
- Breaking changes and other notes:
- Metabase analytics:
- With the launch of new Metabase analytics, we’ll no longer write activity and view logs to Metabase Starter and Open Source; these logs will only be available on Metabase Pro and Enterprise.
- Query execution, Audit, and View logs will be truncated for queries over two years old. You can configure this with the environment variable MB_AUDIT_MAX_RETENTION_DAYS.
- API changes:
- We’ve renamed a couple of Dashboard entities:
- ordered_tabs key is now tabs.
- ordered_cards key is now dashcards.
- Pulses will be removed from Metabase 49
- Pulses gave way to dashboard subscriptions way back in Metabase 38. They’ve been chilling out in the background since then. We’ll remove them in the next major release 49).
- Audit v1 will be removed in a future release
- For the Enterprise Edition only: We’ll remove the previous Audit feature in the Admin settings in a later release, as the new Metabase analytics collection replaces them.
- Changes to database user roles:
- We’ve made some performance optimizations to our database driver code and will no longer enforce read-only connections as much as before although, it was never a given). You may not be affected, but we recommend checking out our guidance on managing database user roles and privileges in Metabase.
New in Metabase 0.47.9 (Dec 1, 2023)
- Bug fixes:
- Upload configuration is not deserialized (#36232)
- Remove divider in QueryBuilder/ViewHeader when it's not needed (#36128)
- Handle CVE in commons-compress and org.json/json (#36106)
- Syncs from Redshift failing since version 0.47.7 (#36040)
- Dashboards with pages sometimes appear blank when opened from bookmarks (#35959)
- Export throws a Unexpected character ('b' (code 98)) (#35880)
- Use the official MySQL latest image for drivers tests (#35641)
- Serialization will fail if there's a snippet on destination with an already existent name but different entity id (#35629)
- Blank strings in CSV uploads should be NULL in MySQL (#35606)
- Restore correct position when undoing dashcard tab movement or deletion (#35502)
- Dashboard subscription attachment does not take into account the dashboardcard visualization settings (#35437)
- Pivot viz fails on a nested question (#35025)
- Static/Public embeds fail to load dashboard when one of the cards fails to load due to missing filter value. (#34954)
- Exporting a child collection won't export the parent collection (#33900)
- Queries not getting cancelled in MongoDB when leaving the page (#32372)
- Creating/editing database connection with SSH tunnel fails silently, when SSH port is not filled out (#32234)
- Serialization won't respect column sorting in pivot tables (#30134)
- Pivot table with 2 group by's gets loaded incorrectly on serialization (#30133)
- Dashboard parameter without field mapping have double borders (#27365)
- Tables render slowly (#25274)
- Serialization: Table columns with "Display values"="Use foreign key" not always saved during dump (#15848)
New in Metabase 0.47.8 (Nov 17, 2023)
- Bug fixes:
- 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)
- 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)
New in Metabase 0.47.7 (Nov 8, 2023)
- Bug fixes:
- 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)
- Dashboard filter Apply button does not follow column structure and shows up to right of other elements instead of below them (#34385)
- MBQL v1 query breaks with boolean breakout (#34286)
- Inconsistent display of numbers in Arabic locales (#34271)
- Incorrect dialect is chosen for ClickHouse pretty SQL formatting (#34235)
- Bar Chart visualization settings show an error and do not allow changes to be made (#33936)
- Question in table view: Removing a field rearranges the entire table columns (#33348)
- The title of the pdf exported by the dashboard is garbled in Chinese (#33121)
- Custom expression that has a name consisting only of whitespace breaks the question (#32571)
- New custom columns won't appear in a dashboard card with reordered columns (custom viz settings) (#25592)
- Scrolling doesn't update dragging on Visible Column configuration (#14238)
New in Metabase 0.47.6 (Oct 26, 2023)
- Bug fixes:
- 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)
New in Metabase 0.47.5 (Oct 20, 2023)
- Bug fixes:
- 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)
- Pivot Table Viz shows different output and calls different endpoints when saved VS being created (#34278)
- d is not a function after latest update to v0.47.0 when enabling Show values on data points (#33725)
- View-only native SQL question should hide SQL when browser back button used (#32387)
- Error occurs when performing "Join data" with fields containing "." character (#32182)
- False "Cannot read properties" error appears sometimes when saving a question (#31766)
- logarithm function calculates wrong result in BigQuery because parameters backwards (#31153)
- Nested questions get confused around custom columns that are just columns (#28451)
- Click Behavior on ranges always parses single-date to destination question's filters (#17879)
New in Metabase 0.47.4 (Oct 11, 2023)
- Bug fixes:
- 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)
- Postgres Custom Query Actions require explicit CAST() for date fields (#29126)
- Spinners change color and fonts change on signed embedding while loading (#25638)
- Corrupted dashboard filter makes it impossible to view the question (unless removed) (#24500)
- Update Apache POI (#34539)
- Do not lose dashboard filters state on navigating back from Question (#34399)
New in Metabase 0.47.3 (Oct 3, 2023)
- Bug fixes:
- Use HTTPS when getting version-info
- Better deduplication for entities loader api queries
- Fix CSV uploads aren't possible when native query editing is disabled
- bad gateway 502 for API via reverse proxy (POST request ignores 'location' v0.47.2)
- Provide a heads up when Metabase is upgraded with what’s new
- Can't apply category filters when a question has grouping and aggregation
- Summarizing or sorting in query editor after Exploring results in a SQL question and creating a Custom Column breaks query editor
- Other count displays incorrect value when Language set to Arabic or Arabic (Saudi Arabia)
- Date filters - inconsistent filter values displayed when a question is opened from a filtered dashboard
- UI suggests it's possible to delete an archived collection
- CSV uploads aren't possible when native query editing is disabled
- Search bar font size is too small on Safari
- Summarizing by custom date column does not allow date grouping
- Custom ranges in conditional formatting don't work
- After hiding column in table settings on question based on another question, all joined columns unchecked in notebook editor when still selected
- Unable to add joined columns in table settings after removing through notebook editor on nested Question
- Inputting some values into Whitelabel "Landing Page" can cause the entire frontend to break
New in Metabase 0.47.2 (Sep 18, 2023)
- Bug fixes:
- 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)
- Table column is not visible in object detail view when its visibility is set to "only in detail views" (#32718)
- Not possible to include time when filtering dates in dashboards (#28188)
New in Metabase 0.47.1 (Sep 7, 2023)
- Enhancements:
- Switch pulse email sending to use bcc instead of sending a seperate email
- Show new syncing tables as greyed out in data reference page
- Bottom corner radius on buttons looks weird on new dashboard grid
- Update default and min size constraints for dashboard cards
- Bug fixes:
- Only log session cookie SameSite=None warning when connection is insecure
- Don't delete a connection impersonation policy when non-data perms are updated
- Remove unused "No changes to permissions will be made." confirmation in PermissionsEditBar
- Performance regression in how we parse query_metadata response leads to notebook being unusable
- Subscriptions should send a single email with all recipients in Bcc
- Wrong URL manipulation when configuring GTAPs when running on a sub path
- Change in Snowflake Driver adds a default role ACCOUNTADMIN instead of using user default
- Data Model Field Formatting settings should only show currency settings for currency fields
- Impersonated security: a user who does not have an attribute defined to access the database can see the data
- Role-based security at database level does not work if the role contains special characters such as the dot.
- Pie charts cut off in dashboard
- Link cards in dashboards shouldn't open in a new window unless you command+click them
- Question name not displayed when changing click behavior
- Invalid redirect URL when doing JWT SSO
- Redundant network requests triggered in object detail modal
- Some audit queries return empty results with an H2 application database
- Redundant separator displayed in table filter popup
- Empty column gets treated as series breakout in line chart
- Assert failed: No more than 1024 pending puts are allowed on a single channel
- Inconsistent icon position in pinned dashboard item loading state
- Duplicating a model creates a new model that uses the original model
- Formatting for field in Data Modeling is no longer working
- Keyboard active when object detail modal is open
- Stale UI for the Official collections menu
- Do not prompt non-admin users to configure email or Slack
- Broken added series on dashcard prevents you from editing the card
New in Metabase 0.47.0 (Aug 17, 2023)
- Dashboards are smoother, quicker, and more organized
- Download dashboards to PDF
- Tabbed navigation on dashboards
- Flow between dashboards and questions smoothly
- Guide your team to the most valuable info by setting your home page to dashboard
- Load dashboards faster with the option to turn off auto-apply filters
- More granular grid for more control over dashboard creation
- Keep dashboards organized with full-width headings
- Can hide cards that have no results
- Metabase now keeps track of the dashboards you’re working with
- Upload and analyze data from CSV
- Powered up Pro features
- Unlock git-based workflows with serialization 2.0
- Set table-specific SQL editing permissions with connection impersonation
- Search for specific records, not just tables
- Other things that got better
- Drill-through menus are more intuitive
- Model X-rays
- Fresh icons
- Enhancements:
- Show new syncing tables as greyed out in data reference pane (#32591)
- Enable parameter substitution to Heading text cards (#32341)
- Fade Link Cards in mapping mode (#32264)
- Change number card minimum size to 2x2 (#32206)
- Provide admins with more context as to where they can change their homepage (#32050)
- Bug fixes:
- Update CSV permission check for "Unrestricted" access on the schema rather than any table (#32265)
- Don't allow CSV uploads when sandboxing is enabled (#32263)
- Bugs on People tab (#32451)
- Native parameters defaults change chart type after save or load (#33208)
- X ray cards load bottom to top (#33085)
- Deep copy dashboard with questions appends -- Duplicate with two dashes to duplicated questions (#33080)
- Query actions won't work when the ID dashboard parameter linked with model ID and action parameter get values from the URL (#32974)
- Columns with long names cause the visualization options sidebar to scroll horizontally (#32964)
- Zero on axis not rounded, has many decimal places with single-row chart (#32815)
- Nothing happens when clicking on search results in a link card (#32603)
- Action not found on dashboard on serdes v2 (#32575)
- side_nav=true does not work when going straight to a dashboard (#32542)
- Basic model action names are not translated (#32358)
- Can't clear dashboard description (#32346)
- Metadata column formatting tab stopped working in v0.47.0-RC2 (#32345)
- Custom homepage search errors when previously set within the same session (#32337)
- Cannot read properties of undefined (reading 'name') when adding an incomplete card (#32231)
- Don't offer to add new questions/ask new in a dashboard in a read-only collection (#32227)
- Don't offer to create new items on read only collections (#32224)
- Charts in admin Audit section load infinitely (#32210)
- Cards that are 1-2 grid units tall look broken in dashboard filter mapping mode (#32204)
- Force migration is broken (#32115)
- Adding filter of summarized field grouped by latitude and longitude on a map changes visualization type (#32075)
- “Invalid :expression reference: no expression named …” on stats (#32055)
New in Metabase 0.46.7 (Aug 9, 2023)
- Bug fixes:
- Prevent open redirects for JWT/SAML (#32816)
- Certain invalid URL causes error response from Jetty (#23277)
- Migration from H2 to Postgres fails with Command failed with exception: ERROR: insert or update on table "metabase_table" violates foreign key constraint "fk_table_ref_database_id" (#32837)
- 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)
- :has_question_and_dashboard from api/user/current is always false (#29438)
- Basic actions become unusable if clauses are added to the model later (#28949)
- Cyclic load dependency when loading src/metabase/integrations/ldap.clj (#28751)
- snowplow events for task details can be too large (#28006)
- New interface Laggy and slow (#26534)
- Pulses with Conditional Formatting is displayed with black background, when value is above 999 (#13892)
New in Metabase 0.47.0 RC 3 (Aug 7, 2023)
- Enhancements:
- Enable parameter substitution to Heading text cards
- Update CSV permission check for "Unrestricted" access on the schema rather than any table
- Fade Link Cards in mapping mode
- Change number card minimum size to 2x2
- Provide admins with more context as to where they can change their homepage
- Shift date columns in original sample dataset tables
- Bug fixes:
- Don't allow CSV uploads when sandboxing is enabled
- Nothing happens when clicking on search results in a link card
- Action not found on dashboard on serdes v2
- side_nav=true does not work when going straight to a dashboard
- Basic model action names are not translated
- Can't clear dashboard description
- Custom homepage search errors when previously set within the same session
- Don't offer to add new questions/ask new in a dashboard in a read-only collection
- Don't offer to create new items on read only collections
- Charts in admin Audit section load infinitely
- Cards that are 1-2 grid units tall look broken in dashboard filter mapping mode
- Force migration is broken
- Adding filter of summarized field grouped by latitude and longitude on a map changes visualization type
- “Invalid :expression reference: no expression named …” on stats
- Field-sync issue with CSV upload on Stats
- Virtual Cards Switch Order at Narrow Screen Widths
- Fix add warning message when leaving an edited, existing SQL question
- When clicking on a chart series title, wrong series opens
- Cannot execute simple actions against the CSV uploaded model
- Apply draft filters when turning on dashboard auto-apply filters
- Fix no warning when leaving edited native questions
- Fix TextWidget inconsistent behavior when all chars are removed
New in Metabase 0.46.6.2 (Jul 25, 2023)
- Bug fixes:
- Google sign-in failing for some geolocations due to Google Identity Services (GSI) client issues (#32602)
New in Metabase 0.47.0 RC 2 (Jul 21, 2023)
- Notes:
- Dashboards are smoother, quicker, and more organized
- Download dashboards to PDF
- Tabbed navigation on dashboards
- Flow between dashboards and questions smoothly
- Guide your team to the most valuable info by setting your home page to dashboard
- Load dashboards faster with the option to turn off auto-apply filters
- More granular grid for more control over dashboard creation
- Keep dashboards organized with full-width headings
- Can hide cards that have no results
- Metabase now keeps track of the dashboards you’re working with
- Upload and analyze data from CSV
- Powered up Pro features
- Unlock git-based workflows with serialization 2.0
- Set table-specific SQL editing permissions with connection impersonation
- Search for specific records, not just tables
- Other things that got better
- Drill-through menus are more intuitive
- Model X-rays
- Fresh icons
- Enhancements:
- Markdown support in pinned items - improvements (#31816)
- Limit CSV uploads to 50mb (#31772)
- [MLv2] Expose external-op in Cljs/TS (#31677)
- [MLv2] Add JS wrappers for filter and filters (#31673)
- Show a spinner next to initially syncing tables in data selector (#31652)
- CSV: standardize error handling (#31604)
- Remove POST /api/database/:id/sync endpoint (#31544)
- Allow image URL preview in object detail (#31539)
- Adds audit v2 view migrations to liquibase (#31420)
- Bug fixes
- Fix dashboard description markdown overflow (#31534)
- Dashboard parameter connection overflows with new grid (#31586)
- Link card spacing isn't quite right on the new grid (#31701)
- Trend charts look very broken with new dashboard grid changes (#31628)
- "Edit question" popover on dashboards for native questions doesn't open up the SQL editor (#31718)
- With Whitelabel custom name, Metabase name is still shown multiple places in Admin Panel (#17043)
- Cannot create new Question from Dashboard empty state (#31848)
- Dashboard tabs has unnecessary right arrow on certain zoom levels (#31818)
- Grouping by a custom column that uses another custom column breaks the question (#31775)
- Broken revision pane on dashboard on firefox (#31710)
- Using x-rays in a question with segments breaks the FE (#31697)
- Newly added syncing tables in search results show as "inactive" but are still clickable (#31648)
- "Customize homepage" modal defaults to previously saved dashboard even if you don't select it (#31602)
- "Customize Homepage" modal's save button is enabled even without changes (#31601)
- Cannot download any question form the Audit tab (#31570)
- Adding a DB no longer does a full scan (#31569)
- Spinner appears on the top left on the sidebar (#31503)
- [MLv2] [Bug] aggregation-operator-columns doesn't mark bucketed columns as selected (#31555)
- [MLv2] [Bug] Infinite loop in breakoutable-columns for multi-stage query with a custom column (#31469)
- [MLv2] [Bug] Breakout columns with binning applied don't have breakoutPosition (#31437)
- [MLv2] [Bug] "Don't bin" bucket doesn't have selected flag when selected (#31399)
New in Metabase 0.46.6 (Jun 29, 2023)
- Enhancements:
- Remove task snowplow event (#31156)
- Bug fixes:
- 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)
New in Metabase 0.47.0 RC 1 (Jun 21, 2023)
- New:
- Dashboards are smoother, quicker, and more organized
- Download dashboards to PDF
- Tabbed navigation on dashboards
- Flow between dashboards and questions smoothly
- Guide your team to the most valuable info by setting your home page to dashboard
- Load dashboards faster with the option to turn off auto-apply filters
- More granular grid for more control over dashboard creation
- Keep dashboards organized with full-width headings
- Can hide cards that have no results
- Metabase now keeps track of the dashboards you’re working with
- Upload and analyze data from CSV
- Powered up Pro features
- Unlock git-based workflows with serialization 2.0
- Set table-specific SQL editing permissions with connection impersonation
- Search for specific records, not just tables
- Other things that got better
- Drill-through menus are more intuitive
- Model X-rays
- Fresh icons
- FYI / Breaking changes:
- We’ll soon be limiting the size of log tables (view logs and query execution) on all self-hosted instances in the next release (not this one)
- OSS instances will keep 30 days of log tables
- New Pro/EE instances will keep 720 days of history
- Existing Pro/EE instance won’t be changed but we recommend setting a limit of 720 days
- LDAP will soon only be available on Pro and Enterprise plans.
- The POST "/api/database/:id/sync" endpoint is being removed. If you’re using this endpoint to sync and scan your database, we recommend using POST "/api/notify/db/:id", or POST "/api/database/:id/sync_schema" followed by POST "/api/database/:id/rescan_values".
- The Google Analytics driver is being removed as GA3 will soon be retired and we’ve decided not to build a GA4 driver.
- Data Model in Admin Settings is now Table Metadata. This admin section was often confused with Models, so we renamed it.
- Data reference has been removed. We’re working on putting the relevant metadata into places where data is queried and consumed so it’s available when and where you need it.
- Enhancements:
- Remove POST /api/database/:id/sync endpoint (#31544)
- Adds audit v2 view migrations to liquibase (#31420)
- Allow table prefixes for postgres uploads, update defaults for mysql (#31396)
- Snowplow: Add instrumentation for "Turn into model" option on saved questions (#31381)
- Hydrate root-collection on card and dashboard (#31337)
- Autoload instance analytics content (when EE and avaliable) (#31314)
- [Safety Net] Hold on to query results when you go back-and-forth between dashboards and questions (#31289)
- [Safety Net] Bring consistency and simplicity to the custom expression editor popovers (#31287)
- [Epic] Nudge larger basic instances to Pro (#31264)
- Improve discovery for csv uploads (#31262)
- Force Audit DB sync + fix connection pool caching behavior (#31234)
- Update csv loading status when taking a long time (#31214)
- Force a sync to occur when installing audit-db (#31204)
- Remove /reference pages (#31203)
- Remove task snowplow event (#31156)
- Generically typed item picker (#31099)
- Present an informational toast to users when a homepage dashboard is set (#31097)
- Respect user-defined model metadata when allowing entity-indexing (#31017)
- [Epic] Really encourage admins to add a DB (#31015)
- Make Questions support special instance analytics type (icon) (#31014)
- Bug fixes:
- Fix dashboard description markdown overflow (#31534)
- Adding a DB no longer does a full scan (#31569)
- Dashboard description overflow (#31326)
- Export to PDF just exports the current tab (#31228)
- Application Table implicit_action doesn't have primary key (#31140)
- Moving dashboard to Our analytics collection creates a null revision description (#31109)
- When duplicating a dashboard with tabs, tabs are not brought to the new duplicated dash (#31077)
- Reverting cards doesn't include dashboard_tab_id (#31032)
- Reverting dashboard does not re-add text card properly (#31031)
- Update visualization settings of card does not create revision (#31018)
New in Metabase 0.46.5 (Jun 13, 2023)
- Enhancements:
- 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)
- Bug fixes:
- 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)
New in Metabase 0.46.4 (May 25, 2023)
- Bug fixes:
- 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)
- Add series modal pulls all cards and viz settings and it's unusable on big instances (#28045)
- /recent_views endpoint query uses non-indexed fields (#27216)
New in Metabase 0.46.3 (May 18, 2023)
- Security:
- 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.
- Bug fixes:
- 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)
New in Metabase 0.46.2 (May 1, 2023)
- Enhancements:
- Include checklist task to migrate off h2 (#30126)
- Bug fixes:
- 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)
New in Metabase 0.46.1 (Apr 6, 2023)
- Enhancements:
- Fix implicit actions not created in a deterministic order (#29605)
- Currency list: Add Mauritania ouguiya (MRU) as currency (#29545)
- Bug fixes:
- 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)
New in Metabase 1.46.0 Enterprise (Mar 29, 2023)
- Notes:
- 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.
- Yet more viz upgrades and polish:
- 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.)
- Enhancements:
- Ensure we use the ssh tunnel on action execution (#29228)
- Exclude non required PKs from implicit create action (#29110)
- Adding classname prop to ObjectDetail (#29032)
- Let users download questions as a PNG in-product (#28959)
- Offer question downloads from dashboard cards (#28958)
- Don't include auto-incremented fields in the implicit create action form if it's an auto increment ID (#28946)
- pulling out column title logic and sharing with settings (#28937)
- Chartsettings use custom column names (#28936)
- Remove personal collections from collection detail page (#28879)
- Standardize chart settings icon buttons (#28858)
- Updating Close Icon (#28815)
- Centering tab labels (#28811)
- Viz Charts don't support customisation of series with more than 20 groups (#28796)
- Fix exclusion of CLJS devtools from release builds (#28778)
- [Epic] Improve Upgrade CTA Tracking (#28731)
- Adding flex grow to card wrapper (#28728)
- update the row chart style (#28626)
- stack area chart with breakouts (#28625)
- open chart settings when clicking active display type (#28613)
- Keep filter and fields clauses in trivial nested queries (#28590)
- Bug fixes:
- Cannot save dashboard when using "Add a saved question" text (#29450)
- Under specific circumstances, when editing an existing sandbox, the "Parameter or variable" dropdown for a filter is incorrectly grayed out (#29143)
- Date Filter "Exclude" option fails on Dashboard if you are on a different language than English (#29122)
- Object Detail View is no longer scrollable inside Query Builder (#29023)
- "Pulse card query error" on user without native SQL permissions (#28947)
- Updated Column names are not present in Chart Settings (#28935)
- GUI Cached models that have joins will generate the query incorrectly and fail (#28902)
- The order of series in a visualization should match the order in the sidebar (#28772)
- Release script can stomp over root ./deps.edn dependencies and break the build (#28763)
- Personal collection shows up as a sub-collection of "Our analytics" (#28755)
New in Metabase 0.46.0 RC4 (Mar 27, 2023)
- Metabase can now write to your database with actionsAdmins: enable Model Actions on your Postgres or MySQL databaseCreate 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.
- Yet more viz upgrades and polish:
- 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.)
- Enhancements:
- Ensure we use the ssh tunnel on action execution (#29228)
- Exclude non required PKs from implicit create action (#29110)
- Adding classname prop to ObjectDetail (#29032)
- Let users download questions as a PNG in-product (#28959)
- Offer question downloads from dashboard cards (#28958)
- Don't include auto-incremented fields in the implicit create action form if it's an auto increment ID (#28946)
- pulling out column title logic and sharing with settings (#28937)
- Chartsettings use custom column names (#28936)
- Remove personal collections from collection detail page (#28879)
- Standardize chart settings icon buttons (#28858)
- Updating Close Icon (#28815)
- Centering tab labels (#28811)
- Viz Charts don't support customisation of series with more than 20 groups (#28796)
- Fix exclusion of CLJS devtools from release builds (#28778)
- [Epic] Improve Upgrade CTA Tracking (#28731)
- Adding flex grow to card wrapper (#28728)
- update the row chart style (#28626)
- stack area chart with breakouts (#28625)
- open chart settings when clicking active display type (#28613)
- Keep filter and fields clauses in trivial nested queries (#28590)
- Bug fixes:
- Cannot save dashboard when using "Add a saved question" text (#29450)
- Under specific circumstances, when editing an existing sandbox, the "Parameter or variable" dropdown for a filter is incorrectly grayed out (#29143)
- Date Filter "Exclude" option fails on Dashboard if you are on a different language than English (#29122)
- Object Detail View is no longer scrollable inside Query Builder (#29023)
- "Pulse card query error" on user without native SQL permissions (#28947)
- Updated Column names are not present in Chart Settings (#28935)
- GUI Cached models that have joins will generate the query incorrectly and fail (#28902)
- The order of series in a visualization should match the order in the sidebar (#28772)
- Release script can stomp over root ./deps.edn dependencies and break the build (#28763)
- Personal collection shows up as a sub-collection of "Our analytics" (#28755)
New in Metabase 0.46.0 RC2 (Mar 5, 2023)
- Notes:
- 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.
- Yet more viz upgrades and polish:
- 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.)
- Enhancements:
- Updating Close Icon (#28815)
- Fix exclusion of CLJS devtools from release builds (#28778)
- [Epic] Improve Upgrade CTA Tracking (#28731)
- Adding flex grow to card wrapper (#28728)
- update the row chart style (#28626)
- stack area chart with breakouts (#28625)
- open chart settings when clicking active display type (#28613)
- Keep filter and fields clauses in trivial nested queries (#28590)
- allow saving chart images (#28546)
- Area charts should default to Stack (#28515)
- Optimize binning expressions; misc QP test improvements (#28466)
- Offer question downloads from dashboard cards (#28351)
- [Epic] Migrate application database code to Honey SQL 2 (#28008)
- [Epic] MongoDB Improvements for 46 (#28005)
- Bump node to version 16 (#27970)
- Enable connecting to Oracle DBs using SSL cert auth (#27709)
- [Epic] Prevent users from accidentally deleting all their saved questions (#27702)
- Allowing users to hide logo on embedding (#27391)
- Generalize product-triggered survey emails (#27348)
- Offer a new full-app embedding url param for logo (#27293)
- Test snowflake throws on datetime-diff with time arg (#27277)
- Bug fixes:
- Release script can stomp over root ./deps.edn dependencies and break the build (#28763)
- Non-admin users can't run actions (#28425)
- Dashboard subscriptions are not working on dashboards with actions or links (#28424)
- Missing custom field metadata on a card breaks the frontend on the Notebook view (#28221)
- Collection pagination state is shared across multiple collections (#28010)
- Static viz doesn't respect y-axis range (#27927)
- Google Sign-in overflows on login page for smaller screens (#27431)
- Cancel button for cancelling dashboard filter edits not working (#27424)
- MongoDB does not support expressions inside aggregations (#27275)
New in Metabase 0.46.0 RC1 (Mar 1, 2023)
- 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.
- Yet more viz upgrades and polish:
- 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.)
- Enhancements:
- Fix exclusion of CLJS devtools from release builds (#28778)
- Adding flex grow to card wrapper (#28728)
- Update the row chart style (#28626)
- Stack area chart with breakouts (#28625)
- Open chart settings when clicking active display type (#28613)
- Keep filter and fields clauses in trivial nested queries (#28590)
- Allow saving chart images (#28546)
- Area charts should default to Stack (#28515)
- Optimize binning expressions; misc QP test improvements (#28466)
- Offer question downloads from dashboard cards (#28351)
- [Epic] Migrate application database code to Honey SQL 2 (#28008)
- [Epic] MongoDB Improvements for 46 (#28005)
- Bump node to version 16 (#27970)
- Enable connecting to Oracle DBs using SSL cert auth (#27709)
- [Epic] Prevent users from accidentally deleting all their saved questions (#27702)
- Allowing users to hide logo on embedding (#27391)
- Generalize product-triggered survey emails (#27348)
- Offer a new full-app embedding url param for logo (#27293)
- Test snowflake throws on datetime-diff with time arg (#27277)
- Refactor datetime-diff implementations: sqlserver, mysql, bigquery, redshift, snowflake, vertica, postgres (#27262)
- Bug fixes:
- Release script can stomp over root ./deps.edn dependencies and break the build (#28763)
- Non-admin users can't run actions (#28425)
- Dashboard subscriptions are not working on dashboards with actions or links (#28424)
- Missing custom field metadata on a card breaks the frontend on the Notebook view (#28221)
- Collection pagination state is shared across multiple collections (#28010)
- Static viz doesn't respect y-axis range (#27927)
- Google Sign-in overflows on login page for smaller screens (#27431)
- Cancel button for cancelling dashboard filter edits not working (#27424)
- MongoDB does not support expressions inside aggregations (#27275)
- The MongoDB driver uses zero-based indexing for substring (#27270)
New in Metabase 0.45.3 (Feb 22, 2023)
- Enhancements:
- Send "threads blocked" via Prometheus exporter (#28014)
- Make educational messaging in native questions less distracting (#27797)
- Fix "Powered by Metabase" badge partially invisible with transparent theme (#27796)
- Bug fixes:
- Pre-existing category filters were not migrated to new ones (#27393)
- Doing "Zoom in" from dashboard drops fields from joined tables (#27380)
- Links for the IDs are showing wrong objects when table join is in place (#27094)
- Column filters not working on Questions using custom columns (#25927)
- Drill-through to questions with add columns (implicit join) causes no filtering to be defined (#23293)
- Data selector not working in FullApp embedding if going directly from location that hasn't loaded /api/database yet (#21511)
New in Metabase 1.45.2.1 Enterprise (Jan 28, 2023)
- Bug fixes:
- This release patches two security issues:
- Dashboard subscription settings interface reveals list of recipients to sandboxed users
- Users can view data they don’t have privileges to view by adding themselves to dashboard subscriptions created by users with more data privileges
New in Metabase 0.45.2 (Jan 17, 2023)
- Enhancements:
- Relieve db pressure on api/health check (#27192)
- Update token check URL (#27036)
- Disable Athena driver IAM role-based auth in Cloud (#27014)
- Improve collection breadcrumbs with embedding parameters (#26838)
- unset MB_API_KEY for notify endpoint could use some feedback (#15157)
- Bug fixes:
- Log4j2.xml file not read on 0.45 (#27497)
- Cannot select fields for double aggregated metrics, and existing sections gets removed on change (#27462)
- Background color on hover for items in data picker looks off (#27449)
- Static viz fails when there's an unused column returned (#27427)
- "Something's gone wrong" error when moving between dashboards that has/hasn't filters (#27356)
- Changing sorting does not apply for X-axis anymore (#27279)
- Number filter with 0 (zero) as default value shows as empty in the widget (#27257)
- Static viz fails when date formatting contains day (#27105)
- "Replace missing values with" set to Zero or Nothing causes the line to become zeroed/hidden (#27063)
- Static viz fails when date formatting is abbreviated (#27020)
- Snowflake sync is consuming more resources than necessary (#26054)
- Click Behavior cannot handle absolute URLs outside of Metabase (#25953)
- Avoid updating dashboard cards unless filter changes (#25914)
- Using filter Contains on dashboard is case-insensitive, but on drill-through to question becomes case-sensitive (#25908)
- BigQuery data type BIGDECIMAL is recognized as mixed string/numeric (#25508)
- Text filter over a custom column in simple embedding expects a number (#25473)
- Comma separated filter value would not hand over from dashboard to question (#25374)
- Embedding Dashboard with Locked parameters does not allow numeric values (#25031)
- Column name auto-classification not working for _latitude (#24041)
- Corrupted question shows "Something's gone wrong" with no more info, and breaks "Add series" modal on the dashboard, and breaks Archive page (#15222)
New in Metabase 0.45.1 (Dec 8, 2022)
- Enhancements:
- Added support for the datetime-diff function for Snowflake
- Athena documentation
- Bug fixes:
- SQL Server driver not loaded in 0.45.0
- Fix incorrect datetime-diff results for bigquery on leap years
- Fix inconsistence temporal extract for timestamptz columns for h2
- Serdes v2: Correctly (de)serialize references to segments and native snippets
New in Metabase 0.44.6 (Nov 1, 2022)
- Bug fixes:
- Google Sign-in fails because of unannounced change by Google (#26184)
- Load in serialization with --mode update fails on upserts (#26043)
- Between() in custom filter expression switches min and max upon adding new filter (#26025)
- Collection list fails to display if there's an invalid parameter in a question (#25543)
- Inconsistent behavior when sending certain payloads to /permissions/graph (#25221)
- Loss of old translations in v0.44.1 (#24943)
New in Metabase 0.44.5 (Oct 19, 2022)
- Bug fixes:
- Slack request error leads to sensitive authorization token being logged (#25849)
- Synchronized tables that were initially marked as cruft has their initial_sync_status as incomplete (#25291)
- Cannot drill-through "View these ..." when aggregated results are filtered (#13504)
New in Metabase 0.44.4 (Sep 29, 2022)
- Enhancements:
- Bump Postgres driver to 42.5.0 (#25544)
- Inform admins if their account is in bad standing (#25161)
- Bump MinaSSHD to 2.9.1 (#25112)
- Envar to disable custom maps / GeoJSON (#19189)
- Metabase Prometheus Exporter (#12377)
- Bug fixes:
- When LDAP is enabled but password login is disabled, login doesn't work (#25661)
- 404 on loading models when instance is configured in another language (#25537)
- Loading spinners in filters don't appear anymore (#25322)
- MYSQL disable JSON unfolding doesn't work (#25068)
- MySQL unfolding of JSON fails for boolean and bigint attributes (#24720)
- Aggregation in Models causes the column name to incorrectly be parsed down to questions based on that Model (#23248)
- Changing filters on Simple question drops anything after first aggregation (#14193)
- Changing filters on Simple question drops aggregated filters (#11957)
- Drill through / underlying records action doesn't respect filters in metric definitions (#6010)
New in Metabase 0.44.3 (Sep 15, 2022)
- Enhancements:
- Slack files channel can be confusing after initial setup (#20936)
- Bug fixes:
- sessionStorage can become filled causing the frontend to throw errors until browser restart (#25312)
- Filters incorrectly showing as linked to all fields on combined charts (#25248)
- First created question not in Saved Questions inside Data Selector until page reload (#25144)
- Cannot change email From-name and Reply-to-address when environment variables are used for other settings (#25057)
- Column filters not working on multi-aggregation (#25016)
- Tooltip periods are not displayed nicely on SQL questions (#25007)
- Can't change filters via 'Show filters' (#24994)
- Bubble size not consistent across multiple series (#24936)
- A hidden Database Sync doesn't allow descriptions for tables or fields to be edited (#24900)
- Newly created Model not an option when creating a new question (#24878)
- Dashboard filter does not show Search widget when trying to workaround other filter issues (#24741)
- Chinese weekdays in calendar widget are incorrect (#22871)
- Field filter linked to Boolean column causes an error when refreshing a public question (#22591)
New in Metabase 0.44.2 (Sep 1, 2022)
- Enhancements:
- Always create new items in the current collection (#24986)
- Always display the original field name when editing metadata in when editing models (#24824)
- Bug fixes:
- Advanced FieldValues does not change if sandbox rule use a native query (#24966)
- Can't use segments in case function for custom columns value (#24922)
- Click-and-Drag filtering in dashboards has an offset if card is not touching the left wall (#24912)
- Click Behavior drops FullApp overrides (#24756)
- "Exclude" filter on dashboard breaks queries if you select a value to exclude, and then add it back (#24236)
- "Exclude" filter on dashboard doesn't show any value in filter widget when nothing is excluded (#24235)
- Form tabs blend in with the white background on hover (#23975)
- Sandboxing on linked table column with multiple dimensions and remapping, then "dirty" query fails (#15106)
New in Metabase 0.44.1 (Aug 17, 2022)
- Enhancements:
- Bump Postgres driver to 42.4.1 (#24709)
- Bump MariaDB (MySQL) driver to 2.7.6 (#24648)
- Bug fixes:
- Fix incorrect hash for Advanced fieldvalues (#24740)
- Confusing UX after performing password reset (#24700)
- Changing existing filters in Simple GUI will replace other existing filters (#24664)
- Cannot set caching duration to less than a second (#24657)
- Correct spelling of pulse setting notification-retry-randomizaion-factor (#24653)
- Dashboard filters are "floating" with default FullApp embedding (#24652)
- Dashboard card filter connection hides filter disconnect button until hovered (#24650)
- New filter modal is showing custom mapped values next to their original values (#24626)
- The "Browse data" in navigation sidebar is hidden in FullApp embedding (#24610)
- Improve the autocomplete query (#24452)
- UI performance regression since v43 when rendering certain visualizations on larger dashboards (#24291)
- Custom Expression references dropped, when field references are also used in breakout (#24126)
- There is no space in the screen of a mobile device to show data when a Question has several filters (#23983)
- Margins on Dashboard parameter filters are too small (#23870)
- Questions referencing another question with a GROUP BY on a custom column generate invalid SQL (#23862)
- Drill-through on "View these X" fails when date column is null (#23817)
- Not possible to filter native model using header cell context menu (#23091)
- Metabase thinks Database has unrun migrations on every launch (#22867)
- Multi-level nested questions with joins causes failed query because of incorrect column aliasing (#22859)
- Models does not respect the column visibility setting (#22520)
- Dashboard's "text/contains" filter is case-sensitive (#21359)
- Mongo Driver Timezone Issue When Grouping (#11149)
New in Metabase 0.44.0 (Aug 5, 2022)
- Enhancements:
- Bump jetty-server to 9.4.48.v20220622 (#24482)
- Bulk Filter Modal v3 (#23911)
- Add snowplow tracking for new records on TaskHistory (#23893)
- Bug fixes:
- Blank screen if user without permissions to view dashboard card tries to edit the dashboard filter (#24530)
- Click behavior to another dashboard/question makes the browser open the destination on a new window (#24451)
- False warning that No self-service means higher access than Block permissions (#24380)
- Bookmark icon not updated when question is converted to model and vice-versa (#24375)
- Scalars show short number before showing the full number (#24332)
- Default /api/collection/tree call does not include "exclude-archived=true" (#24329)
- Archive page does not render all items (#24213)
- Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
- Search returns irrelevant matches for non-native questions (#24132)
- Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
- CASE statements don't evaluate to False if using , False and nested CASE statements (#24100)
- "Custom..." model refresh setting does not work on first request (#24053)
- "Our analytics" appears on "Save question" collection search header even when user doesn't have access to it (#23981)
- Exports fail on specific date styles (#23980)
- Bubble size is scaling according to y-axis on scatter charts (#23977)
- Error sending emails when reply-to setting contains empty string (#23940)
- Email settings needs to use real password, not obfuscated password (#23919)
- Wrong username/password on Office365 for email settings has misleading error (#23918)
- Missing full-screen button on public dashboards (#23811)
- Primary color is not being used on background colors, so branding is not kept consistent (#23777)
- Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
- Dark primary color in data visualization makes icons almost disappear. (#23759)
- Primary color in text with dark backgrounds makes text hard to read (#23751)
- Relative Date filters on dashboard does not include the filter on drill-through (#23748)
- Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
- Items in the saved question picker are sorted case-sensitive (#23693)
- Sandboxed group managers can't see other users in the People tab (#23689)
New in Metabase 0.44.0 RC 3 (Aug 4, 2022)
- Enhancements:
- Bump jetty-server to 9.4.48.v20220622 (#24482)
- Bulk Filter Modal v3 (#23911)
- Add snowplow tracking for new records on TaskHistory (#23893)
- New date filter widget, "is empty" is under the "Eclude" section but is used for inclusion (#23677)
- Bug fies:
- Click behavior to another dashboard/question makes the browser open the destination on a new window (#24451)
- False warning that No self-service means higher access than Block permissions (#24380)
- Bookmark icon not updated when question is converted to model and vice-versa (#24375)
- Default /api/collection/tree call does not include "eclude-archived=true" (#24329)
- Archive page does not render all items (#24213)
- Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
- Search returns irrelevant matches for non-native questions (#24132)
- Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
- CASE statements don't evaluate to False if using , False and nested CASE statements (#24100)
- "Custom..." model refresh setting does not work on first request (#24053)
- "Our analytics" appears on "Save question" collection search header even when user doesn't have access to it (#23981)
- Eports fail on specific date styles (#23980)
- Bubble size is scaling according to y-ais on scatter charts (#23977)
- Error sending emails when reply-to setting contains empty string (#23940)
- Email settings needs to use real password, not obfuscated password (#23919)
- Wrong username/password on Office365 for email settings has misleading error (#23918)
- Missing full-screen button on public dashboards (#23811)
- Primary color is not being used on background colors, so branding is not kept consistent (#23777)
- Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
- Dark primary color in data visualization makes icons almost disappear. (#23759)
- Primary color in tet with dark backgrounds makes tet hard to read (#23751)
- Relative Date filters on dashboard does not include the filter on drill-through (#23748)
- Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
- Items in the saved question picker are sorted case-sensitive (#23693)
- Sandboed group managers can't see other users in the People tab (#23689)
- Dashboard parameter widget connected to template tag clears value after a few seconds (#23640)
New in Metabase 0.43.4.1 (Jul 29, 2022)
- Bug fixes:
- Set a timeout for isValidTimeout.
New in Metabase 0.44.0 RC 2 (Jul 27, 2022)
- Enhancements:
- Bulk Filter Modal v3 (#23911)
- Add snowplow tracking for new records on TaskHistory (#23893)
- New date filter widget, "is empty" is under the "Exclude" section but is used for inclusion (#23677)
- [Epic] Reconsider how we email new users when SSO is active (#23630)
- [Epic] Better communicate embedding options in Admin settings (#23498)
- Bug fixes:
- Archive page does not render all items (#24213)
- Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
- Search returns irrelevant matches for non-native questions (#24132)
- Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
- Exports fail on specific date styles (#23980)
- Bubble size is scaling according to y-axis on scatter charts (#23977)
- Error sending emails when reply-to setting contains empty string (#23940)
- Email settings needs to use real password, not obfuscated password (#23919)
- Wrong username/password on Office365 for email settings has misleading error (#23918)
- Missing full-screen button on public dashboards (#23811)
- Primary color is not being used on background colors, so branding is not kept consistent (#23777)
- Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
- Dark primary color in data visualization makes icons almost disappear. (#23759)
- Primary color in text with dark backgrounds makes text hard to read (#23751)
- Relative Date filters on dashboard does not include the filter on drill-through (#23748)
- Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
- Items in the saved question picker are sorted case-sensitive (#23693)
- Sandboxed group managers can't see other users in the People tab (#23689)
- Dashboard parameter widget connected to template tag clears value after a few seconds (#23640)
- Token check error floods the logs when there's no internet connection (#23588)
- Data point value style missing stroke, which makes it hard to read sometimes (#23529)
- Arbitrary recipient's email addresses are shown as empty values (#23527)
- Data reference in SQL editor does not list the correct tables if accessed directly (#23510)
- Models should not allow variables (#23505)
- Viewing archived questions causes bad error (#23501)
New in Metabase 0.44.0 RC 1 (Jul 12, 2022)
- Enhancements:
- [Epic] Reconsider how we email new users when SSO is active (#23630)
- [Epic] Better communicate embedding options in Admin settings (#23498)
- [Epic] Offer background and data download customization in public embeds (#23477)
- [Epic] Remove ability for users to edit SSO created user info (#23298)
- [Epic] Iterate on collections and sidebar (#23222)
- [Epic] Bring client-side SSL certs to Mongo (#22889)
- [Epic] Give users an expanded palette of colors to choose from (#22816)
- [Epic] Improve handling for user name null cases and syncs (#22754)
- Bug fixes:
- New date filter widget, "is empty" is under the "Exclude" section but is used for inclusion (#23677)
- defsetting setter functions should end in ! (#22799)
- Missing full-screen button on public dashboards (#23811)
- Primary color is not being used on background colors, so branding is not kept consistent (#23777)
- Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
- Dark primary color in data visualization makes icons almost disappear. (#23759)
- Primary color in text with dark backgrounds makes text hard to read (#23751)
- Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
- Items in the saved question picker are sorted case-sensitive (#23693)
- Sandboxed group managers can't see other users in the People tab (#23689)
- Dashboard parameter widget connected to template tag clears value after a few seconds (#23640)
- Arbitrary recipient's email addresses are shown as empty values (#23527)
- Data reference in SQL editor does not list the correct tables if accessed directly (#23510)
- Viewing archived questions causes bad error (#23501)
- Slack subscriptions UX is buggy (#23494)
- Allow sending Alerts to private Slack channel (#23483)
- Report timezone in date filter - exclude hours of day (#23461)
- "Your account is disabled" message overflows sign in modal (#23432)
- Certain visualization settings causes Models to crash frontend with a blank screen (#23421)
- Sandboxing on UUID columns causes error, when there's Custom Columns (#23354)
- "column reference "id" is ambiguous" when group managers want to see the group members (#23246)
- I18N: links on managing alerts not localized (#22835)
New in Metabase 0.43.4 (Jun 29, 2022)
- Bug fixes:
- Blank screen on questions with certain orphaned visualization settings (#23300)
- Metabase returns "No results!" when the SSH tunnel is down on a query (#23281)
- Changing account password to a non-complex password misleads the user with a success message even though the process fails (#23259)
- Relative "quarter" filter doesn't work in SQL queries (#23258)
- New Slack setup not working, because App isn't joining the files channel (#23229)
- Tooltips goes outside of iframe in some cases (#22970)
- "Can't pop empty vector" when binning JSON fields (#22967)
- Collection name under dashboard title wraps weirdly when viewport is narrow (#22776)
- Incorrect use of types during Postgres JSON unfolding (#22732)
- Cannot filter time columns unless using the QB Sidebar (#22730)
- Frontend incorrectly shows empty boolean values as false (#22621)
New in Metabase 0.43.3 (Jun 14, 2022)
- Enhancements:
- Bump google oauth version (#23165)
- Bug fixes:
- Slack setup doesn't work if channels cache was recently cleared (#23251)
- Custom Expression field is not respecting the modal size (#23223)
- Relative filter with a lower "Starting from" period is confusing (#23099)
- Cannot print large dashboards (multi page) (#23098)
- Sync of JSON columns fails in schemas where schema names contains system characters (#23027)
- Sync of fields fails, when table name contains uppercase characters (#23026)
- Preview function in Notebook does not respect the columns selected on base source (#23023)
- Viewing Metadata for a Model and cancelling can result in error, and further in blank screen (#23022)
- Do not offer "Explore results" unless the database supports it (#22822)
- Cannot view Object Detail of non-numeric IDs (#22768)
- Click Behavior not redirecting in some cases (#22702)
- Uploading certificates causes failure in TrustManager/KeyManager because of bad MIME-type (#22626)
- New Slack App does not allow selecting private channels for pulses (#20867)
- Query executions hitting the cache are not recorded (#18777)
- Pulse fails when there is a column type time (#15146)
New in Metabase 0.43.2 (Jun 1, 2022)
- Redesigned navigation and homepage, bookmarks, events and timelines, feature-level permissions, and more.
New in Metabase 0.43.0 (May 17, 2022)
- Docs - update login troubleshooting
- Show correct settings UI when MB_ENABLE_EMBEDDING env var specified
- Fix removing the field type in data reference
- Fix relative filters for non-english locale
- Update api docs
- Add permission change warnings
- Handle not available Notifications API
- Fix cancelling the native query via shortcut
- XLSX formatting for temporal breakout fields
- Updates docstring to correct formatting
- [E2E] Remove joins check from CCI
- Fix unescaped apostrophes in translated strings during .edn creation
- Remove misleading permissions tooltip
- Fix visualization and settings buttons are visible for questions that use blocked db
- Add a delay for showing tooltips for relative date filters
- Manual Backport: [E2E] Download permissions
- Fixes loading moment locale for zh locale
- Docs -fix missing link
- Use a different icon for tables on the homepage
- Fix pasting non-numeric values into numeric filters
- Make it possible to convert relative filters to expressions
- Fix toggle button alignment
- Extends ring.protocols/StreamableResponseBody to keywords
- Clear download perms when setting block perms
- Fix permission bugs
- Fix :Postgres :day-of-week extracts coming back as 0..6 instead of 1..7
- Pass parameter value to disabled TextWidget
- Add moderated_status icon to recents list
- Prevent channging visibility_type when updating table properties
- Fix issue with missing parameter options in cloned, targeted dashboard
- Backported "mbql.u/add-temporal-unit should ignore invalid units"
- Fix unneeded query nesting when removing all expressions
- Manual backport #22368
- Better logs for rotate encryption key + better command error messages…
- Bump snowplow-java-tracker
- Fix automagic dashboards for queries with source queries
- Fix redirects of group managers when they remove the last group they manage
- Fix invalid unit on dashboard relative date time filters
- Manual backport of
- Fix embedded dashboard is not being updated after changing params
- Manual backport of
- Fix a typo in the component name
- Turn on logging in quartz to watch for connection allocation
- Start task scheduler at end of startup.
- Clean up aggregation options getter
- Fix whitelabeled logo proportions
- Do not show restore sample database button to non-admins
- Upgrade Cypress to v9.6.1
- Backporting PR E2E Checks
- Don't reschedule syncs on startup
- Reduce sync query size for expedient amelioration of
- Record startup times
- Docs - updates api docs
- Repro #22700: Custom expression aggregation does not work in metrics
- Translations for x.43.1
- Fix inability to save to sub-collections when having no access to the parent
- Manual backport for No open redirects for enterprise SSO's
- Fix relative preview dates for past intervals
- Add nowrap to Cloud CTA link
- Fix smart scalar alignment
- Don’t enable Add Group button with string of white space as a group name
- Pass isNavBarOpen to BulkActionBar
- Tweak bulk action bar height
- Do not render value for null-related conditional formattings)
- URIDecode exported question filenames
New in Metabase 0.43.0 RC 1 (Apr 19, 2022)
- Enhancements:
- [Epic] Give users a chill and useful starting page (#21322)
- [Epic] Reduce waiting cost in slow dashboards (#21247)
- Admin troubleshooting page changes (#21206)
- Timeline event modal does not show selected icon (#20932)
- Creating a new dashboard from the New button in a collection should take me to that dashboard (#20638)
- [Epic] Sync multiple schemas, with controls (#20609)
- [Epic] Rethink Starting Points (Homepage and Collections) (#20605)
- Upgrade Liquibase (#20600)
- "SQL Query" in UI for MongoDB/Druid/GA native queries (#20499)
- Replace Clojure-land data migrations with Liquibase migrations (#20449)
- [Epic] Mention advanced permissions features in OSS edition (#20398)
- [Epic] General permissions (#20397)
- Bug fixes:
- Converting time series from GUI to SQL can cause frontend reload in some cases (#21615)
- Custom Expression validator too strict when field name is the same as a function (#21513)
- Pie chart series are not displayed correctly in the config (using timestamp instead of short date) (#21504)
- POST firing on each keystroke when changing series display name on cumulative calculations (#21452)
- Some strings not being translated in setup page (#21404)
- Setup should automatically detect locale and translate the UI (#21403)
- Dropdown filter list does not allow filtering for the FK remapped value (#21382)
- Superfluous stack traces logged when database does not have SSL support (#21278)
- Send email fails when <10 items rendered as table and custom (verbose) logging level (#21166)
- Combining question modal does not wrap long question names (#21056)
- Save fails on a question started from the new collection "New..." menu from Our Analytics (#21055)
- Native query preview overflow window when there are no space (#21018)
- Embedding Preview of questions does not limit the results in visualization, which can freeze the browser (#20938)
- Subdimensions/binnings do not exist for time column (#20882)
- Bad Field Filter references can cause the question to fail to load (#20865)
- Static visualization ignores granularity in X-axis ticks in some cases (#20807)
- Default timeline's icon is not used for new events (#20597)
- Restricting and unrestricting access to a table results in the DB-level permission still being "Granular" (#20436)
New in Metabase 0.42.4 (Apr 8, 2022)
- Enhancements:
- Disallow FDW connections in SQLite (#21525)
- Inform the user when a database driver isn't official (#21409)
- Bug fixes:
- Dashboard filter dates by Quarters fails, but works on the question (#21083)
- Custom Column aliasing can cause incorrect results or wrong alias on nested queries (#21131)
- "Invite someone" button overlaps activate/deactivate radio buttons on small screen widths (#16350)
- "Custom mapping" is only available, when "A list of all values" is set (and after a browser refresh) (#16322)
- Nan/Infinity in question's result aused .xlsx exporting fail (#21343)
- Nan/Infinity in question's result aused .xlsx exporting fail (#21343)
- Custom Column aliasing can cause incorrect results or wrong alias on nested queries (#21131)
- Dashboard filter dates by Quarters fails, but works on the question (#21083)
- Autocomplete flicker in SQL Editor (#21034)
- Cannot convert SQL question with Snippet to Model (#20963)
- Serialization does not remove cards from dashboard even with --mode update (#20786)
- Error when filtering date by current quarter in Postgres (#20683)
- Can't load uploaded CA certificate into the TrustManager on 0.42 (#20319)
- Serialization overlaps cards on load (#19762)
- [New question picker] Moved model's collection isn't displayed until page refresh (#19737)
- Date filter selection stays on the foreground when switching to notebook (#18079)
- Ignore empty strings in conditional formatting (#16822)
- "Invite someone" button overlaps activate/deactivate radio buttons on small screen widths (#16350)
- "Custom mapping" is only available, when "A list of all values" is set (and after a browser refresh) (#16322)
- "Replace missing values with" won't work when grouping by minutes (#16037)
- TIME are randomly cast with/without timezone depending on millisecond values (#15876)
- Zero showing as -0.0000...89 in chart x-axis (#15188)
- Mapped value shows random number for 0 instead of string in chart (#14218)
- Missing Filter Box in Mobile Size (#13726)
New in Metabase 0.42.3 (Mar 24, 2022)
- Enhancements:
- Upgrade MySQL/MariaDB JDBC driver to version 2.7.5
- "Show error details" in Query Builder should be toggleable
- Bug fixes:
- Comma Separate Numbers filter not working as it previously did
- Markdown parsing on backend doesn't support autolinks
- Subscription fails, when there's specific characters that causes Markdown failure
- Custom Column allows aggregation functions together with algebra, which fails on query
- Cannot connect Google Analytics because of deprecated OAuth OOB
- Postgres certificate SSL key reference incorrect
- Embedding with Locked parameters does not allow numeric values
- Models should not be shareable (embedding/public)
- BigQuery: Aggregating by a datetime in a saved question fails because of bad aliasing
- "Saved" overlay in data model UI in weird location on smaller screen
- "Compare to the rest" action in drill-through menu looks busted
- Autocomplete suggestions are not working for most of the database tables
- Permissions paths validation is GET API endpoints is too strict; causes numerous endpoints to 500 if unknown entry is present
- Main page loading spinner spins forever on API error
- Cannot use Data Selector when going directly to a question in new tab (or browser refresh)
- No visual feedback when setting column properties in Admin > Data Model
- QP/MBQL: [:relative-datetime :current] doesn't work inside [:between] filter
- Icon on empty activity page is misaligned
- Google Analytics updated Credentials aren't used for Connection
- Google Analytics database connection stopped working. (#14578)
- Binning not working in table with a single row (#13914)
- Fix error in send-abandonment-emails task (#12068)
- Can't change Google Analytics DB settings (#6613)
New in Metabase 0.42.2 (Mar 1, 2022)
- Bug fixes:
- Dashboards breaks when there's filters to cards that a user don't have permissions to view (#20656)
- Questions with Field Filter with widget type "None" will not show results (#20643)
- Can't combine saved questions on a dashboard card (#20637)
- Setting a filter to "Locked" in Embedding question is not possible (#20634)
- Nested queries with long Data Model names causes failing query with incorrect aliasing (#20627)
- Dropdown list filtering not working, when there's nulls (#20618)
- BigQuery - nested query generating bad aliases, when columns are renamed in Data Model (#20610)
- Summarizing with implicit join does not allow subsequent joins and nested query (#20519)
- Databases shows sync-spinner and doesn't allow to remove it or do a forced sync (#20283)
New in Metabase 0.42.1 (Feb 17, 2022)
- Enhancements:
- Remove unused dep on aleph (and thus unused transient dep on Netty) (#20342)
- Bug fixes:
- Filter dropdown only allows filtering on "starts with" (#20551)
- Unable to filter dashboards for dashboard subscription emails (#20516)
- Dashboard filter with defaults, doesn't work if values are removed, query fails (#20493)
- Pulse Question Alert to Slack sending cropped images (#20444)
- Cannot remove Google Sign-in setup (#20442)
- Embed dashboard Field Filter cannot work when choosing single option (#20438)
- Custom expression - Count needs parentheses, but deletes them afterwards (#20420)
- Cannot open Model sidebar in some cases (#20414)
- BigQuery incorrectly aliasing, which can make the query fail (#20413)
- Filtering on nested questions causes error in Public and Embedding (#20393)
- BigQuery nested query with ambiguous columns causes error (#20362)
- Setting a filter to "Locked" in Embedding is not possible (#20357)
- Oracle queries don't work when aliases (auto-generated or otherwise) contain double quotes or null characters (#20307)
- When no-data user views a nested question, then all editing options are exposed (#18978)
- When no-data user views a nested question, then "Ask question" and "Browse data" appears (#18977)
- Oracle fails queries on joins with tables with long display names (#15978)
- Pivot Table: Cannot change name of fields used for "values" (#15353)
New in Metabase 0.42.0 RC 2 (Feb 4, 2022)
- Enhancements:
- The Time picker AM and PM color can not be distinguished obviously (#20010)
- Alert Stopped email is Unhelpful (#19814)
- Clean up database guide usability during configuration (#19641)
- Add a way to return to previous page from sign in cases (#19476)
- Consolidate first db sync modal and X-ray selection (#19440)
- Migrate Slack implementation from Bot to App (#19435)
- Improve Filters (#19354)
- Clean Up Settings Navigation (#19348)
- Enable users to invite teammates with db credentials in set up (#19247)
- Bug fixes:
- Pins do not appear on pin map (#20090)
- "Explore results" shown for no-data users resulting in blank screen when clicked (#20044)
- Blank screen when accessing Models with no-data user (#20042)
- Licensing page goes into reload-loop if token is expired (#20020)
- Descriptions missing in search results (#20018)
- Horizontal scroll of pinned table doesn't work on Firefox (#19997)
- Metadata tooltip popup on colum header casues data table to reset for number columns that are all NULLs (#19976)
- Certain visualization_settings can cause empty/missing columns on export (#19889)
- Postgres unnecessarily casts timestamptz and date columns to timestamp inside date_trunc() (#19816)
- Exports ignore column ordering regression in v0.41.6 (#19796)
- Premature calls to to-sql inside sql.qp/->honeysql methods (#19753)
- Visualization "auto-viz" doesn't keep existing settings, when changing fields returned (#19747)
- Can't add a filter if the value isn't in the field filters dropdown (#19685)
- Defsetting :tag metadata should be on the arglists themselves, not the var (#19627)
- SQLite/Redshift/SQL Server/MySQL queries don't work correctly with multiple column aliases with same name but different case (#19618)
- Archived sub-collections are still showing in Permissions (#19603)
- XLSX exports are leaving temporary files, which can block instance from working (#19480)
- Disable "Nested queries" not honored in GUI data selector search or on SQL questions (#19341)
New in Metabase 0.42.0 RC 1 (Jan 21, 2022)
- Models:
- Models are a new fundamental building block in Metabase that let you create metadata-rich derived tables for people to explore. The idea is to make it easier to create starting points for people to ask questions, like a model that pulls together information about customers from multiple tables.
- To create a model, create a question using either the query builder or the native SQL editor, save it, and convert it to a model (from the sidebar). You can add metadata for each column (especially useful for models created from SQL questions), and edit the underlying query. People will be able to select models in the data picker as the starting point for new questions, and you can place models in collections for people to discover.
- Updated Slack integration:
- Metabase now uses the Slack app API to handle its Slack application (Slack had deprecated the previous bot integration).
- Revamped custom expressions editor:
- Writing custom expressions just got a lot snappier: lots of improvements under the hood. Autocomplete suggestions are much faster, and the functions, aggregations, and fields are labeled by type for easy scanning.
- Waterfall, area, progress, and combo charts added for dashboard subscriptions
- Continuing our work on improving dashboards subscriptions, we made two more charts available to email and Slack messages: waterfall and progress charts, and made sure charts with multiple series now display them all. We also added more polish to the formatting, colors, and fonts for the static charts Metabase sends.
- Improved summarize sidebar:
- When you close and reopen the Summarize sidebar in the query builder, it'll keep all of your summarizations and groupings in one place so they're easier to edit. We've also added some small UI touches to field selection that makes adding new summarizations and groupings more intuitive.
- Better revision histories for questions:
- We cleaned up the entries in questions so it's easier to see at a glance how a question has changed over time (and who changed it).
- Refined filters:
- We touched up our calendar date selector as well as the "between" date range selector for our filter widgets, and hardened the security on filters used with questions built with the query builder.
- New database setup interface:
- We spruced up the UI that walks people through connecting Metabase to a data source (like your PostgreSQL database).
- Option to disable animations:
- Animations can cause people with vestibular disorders to experience vertigo, so we made Metabase compatible with the Operating System setting prefers-reduced-motion.
- Connect to a secure PostgreSQL and Oracle database server using a truststore and/or keystore
- You can now provide a keystore and/or a truststore to connect to an Oracle or PostgreSQL database server that someone else (like your database administrator) has secured. Note that some cloud providers only support client authentication with a truststore, so keystores would have no effect. You can also take advantage of PostgreSQL's SSL-mode.
- More control over which BigQuery datasets to sync:
- We have added a new feature that gives more granular control over which BigQuery datasets will (or won’t) be synced.
- We've added Snowplow to help us collect anonymous data:
- For our opt-in anonymous data collection (which helps us improve and troubleshoot Metabase—thanks to those who opt in), we've added Snowplow to capture more in-app events.
- Here is the full list of enhancements and bug fixes:
- Enhancements:
- Add a way to return to previous page from sign in cases (#19476)
- Consolidate first db sync modal and X-ray selection (#19440)
- Migrate Slack implementation from Bot to App (#19435)
- Improve Filters (#19354)
- Clean Up Settings Navigation (#19348)
- Enable users to invite teammates with db credentials in set up (#19247)
- Select no columns in the custom question mode (#19186)
- Remind users to connect their data after set up (#19119)
- Offer contextual help for database connection inputs (#19099)
- Simplify additional options in set up flow db configuration (#19046)
- Support Postgres driver SSL certificates as secrets (#18939)
- Elevate most popular database options in set up (#18918)
- Bug fixes:
- Fix with-temporary-setting-values macro for settings with non-idempotent setters (#18835)
- Waterfall not showing as waterfall in slack static viz (#19025)
- Premature calls to to-sql inside sql.qp/->honeysql methods (#19753)
- defsetting :tag metadata should be on the arglists themselves, not the var (#19627)
- SQLite/Redshift/SQL Server/MySQL queries don't work correctly with multiple column aliases with same name but different case (#19618)
- Archived sub-collections are still showing in Permissions (#19603)
- Disable "Nested queries" not honored in GUI data selector search or on SQL questions (#19341)
- Model query results disappear after cancelling edit (#19180)
- Invalid $project - Path collision.... with mongo >= 4.4 (#19135)
- EMBEDDED_SESSION cookie does not have SameSite=None specified (#18822)
- Fix type of query_cache.results column in MySQL via new changeSet (#18815)
New in Metabase 0.41.6 (Jan 15, 2022)
- Enhancements:
- Broken layout on Data Model page on locales with longer text (#16267)
- Bug fixes:
- Specific visualization_settings can cause empty export (#19465)
- Cannot change Field Filter reference to another schema/table if viewing the question directly (#19451)
- Upgrade Log4j to 2.17.1 (#19420)
- Names of schemas or namespaces in the Data Model should wrap (#18584)
New in Metabase 0.42.0 Preview 1 (Dec 28, 2021)
- Datasets:
- Datasets are a new fundamental building block in Metabase that let you create metadata-rich models for people to explore. The idea is to make it easier to create starting points for people to ask questions, like a dataset that pulls together information about customers from multiple tables.
- To create a dataset, create a question using either the query builder or the native SQL editor, save it, and convert it to a dataset (from the sidebar). In the full release, you will be able to add metadata for each column (which is especially useful for datasets created from SQL questions), and edit the underlying query if you need to. People will be able to select datasets in the data picker as the starting point for a new question, and you can place datasets in collections for people to discover.
- Revamped custom expressions editor:
- Writing custom expressions just got a lot snappier: lots of improvements under the hood. Autocomplete suggestions are much faster, and the functions, aggregations, and fields are labeled by type for easy scanning.
- Waterfall, area, progress, and combo charts added for dashboard subscriptions
- Continuing our work on improving dashboards subscriptions, we made two more charts available to email and Slack messages: waterfall and progress charts, and made sure charts with multiple series now display them all. We also added more polish to the formatting, colors, and fonts for the static charts Metabase sends.
- Improved summarize sidebar:
- When you close and reopen the Summarize sidebar in the query builder, it'll keep all of your summarizations and groupings in one place so they're easier to edit. We've also added some small UI touches to field selection that makes adding new summarizations and groupings more intuitive.
- Better revision histories for questions:
- We cleaned up the entries in questions so it's easier to see at a glance how a question has changed over time (and who changed it).
- Refined filters:
- We touched up our calendar date selector as well as the "between" date range selector for our filter widgets, and hardened the security on filters used with questions built with the query builder.
- New database setup interface:
- We spruced up the UI that walks people through connecting Metabase to a data source (like your PostgreSQL database).
- Option to disable animations:
- Animations can cause people with vestibular disorders to experience vertigo, so we made Metabase compatible with the Operating System setting prefers-reduced-motion.
- Connect to a secure PostgreSQL and Oracle database server using a truststore and/or keystore
- You can now provide a keystore and/or a truststore to connect to an Oracle or PostgreSQL database server that someone else (like your database administrator) has secured. Note that some cloud providers only support client authentication with a truststore, so keystores would have no effect. You can also take advantage of PostgreSQL's SSL-mode.
- We've added Snowplow to help us collect anonymous data
- For our opt-in anonymous data collection (which helps us improve and troubleshoot Metabase—thanks to those who opt in), we've added Snowplow to capture more in-app events.
- Other Changes:
- Enhancements:
- Remove and convert flow types (#19207)
- Select no columns in the custom question mode (#19186)
- Remind users to connect their data after set up (#19119)
- Support Postgres driver SSL certificates as secrets (#18939)
- Elevate most popular database options in set up (#18918)
- Fix with-temporary-setting-values macro for settings with non-idempotent setters (#18835)
- Support multiple series for line/bar/area (#18783 and #18782)
- Support combo static viz charts (#18689)
- Implement combo static viz chart front-end (#18688)
- Support static viz area charts (#18687)
- Provide progress on initial data sync (#18675)
- ensure dataset tree api only returns nodes which contain leaves that are datasets (#18672)
- Make IP addresses visible for firewall Cloud users (#18670)
- Show datasets in search (#18657)
- Add to query source API (#18656)
- Remove user info field duplication during self-serve set up (#18469)
- Implement analytics events for product activation (#18291)
- Currency list: Add Papua New Guinean Kina (PGK) (#18233)
- Remove animation from <EntityMenu> when under 'reduce-motion' (#18198)
- Bug fixes:
- Disable "Nested queries" not honored in GUI data selector search or on SQL questions (#19341)
- Invalid $project - Path collision.... with mongo >= 4.4 (#19135)
- EMBEDDED_SESSION cookie does not have SameSite=None specified (#18822)
- Fix type of query_cache.results column in MySQL via new changeSet (#18815)
- Connecting a custom column to a dashboard parameter results in a front-end scripting error (#18747)
- Cookie metabase.DEVICE does not respect SameSite environment variable (#18553)
- Activity entries for dashboard-add-cards events using incorrect card permalink (#18547)
- Blank database appears in native question picker after saving a nested question (#18418)
- Unable to save a nested question in the "Our analytics" collection on master (#18364)
- Metabase doesn't respect Database name property when connecting to MongoDb (#18208)
New in Metabase 0.41.5 (Dec 16, 2021)
- Bug Fixes:
- Upgrade Log4j to 2.16.0 (#19371) - this addresses CVE-2021-45046
- XLSX export does not respect "Separator style" (#19006)
- One cannot change any of the LDAP Settings once it's been initially setup (#18936)
- Custom Expression coalesce is using wrong field reference when nested query (#18513)
- Custom Expression case is using wrong field reference when nested query (#17512)
- Dashboard causes permission error, when "Click Behavior" linking to dashboard/question without access (#15368)
- Site URL validation too strict, doesn't accept underscore (#14491)
- Reverse proxy reset email should use site URL in email body and not localhost (#14028)
New in Metabase 0.41.4 (Dec 11, 2021)
- Bug fixes:
- Addresses the CVE-2021-44228 security vulnerability by updating log4j2 to 2.15.0
New in Metabase 0.41.3.1 (Dec 2, 2021)
- Bug fixes;
- Static viz creates Picaso painting, when data is unordered Timeseries (#19098)
- Harmonize Google dependency versions, which could cause conflict between GA and new BigQuery driver (#19080)
- Saving/updating questions can take a very long time (seconds or minutes) on large instances (#19053)
- Funnel chart showing retained NaN% when all rows from aggregate column are zero (#18980)
- Changing a (old) pivoted table to less than 3 columns results in blank screen (#18976)
- Exports fails, when there's invalid visualization column_settings references (#18972)
- Cannot send test emails before creating subscription, when using non-default filter values (#18669)
- Native editor autocomplete suggestions makes object lookup without limit (#16736)
- Strip whitespace from Google sign-in client IDs (#15976)
- Validate Google sign-in client IDs (#15975)
- Dashboard causes permission error, when "Click Behavior" linking to dashboard/question without access (#15368)
- Clicking on legend in native question breaks the UI (#12439)
- Trend tile on dashboard differs from tile on full screen (#10786)
- BigQuery and Google Analytics drivers broken on x.41.3 (#19173)
- BigQuery connection error on 0.41.1 (#18788)
New in Metabase 0.41.2 (Nov 10, 2021)
- Bug fixes:
- Frontend crashes when opening admin database permissions page (#18829)
- Cannot access Notebook for questions that uses a Custom Column as joining column (#18818)
- Requests to GET /api/card/123 is making slow queries on larger instances (#18759)
- BigQuery can cause conflict with some column names like source (#18742)
- "Verify this question" button is shown even when content moderation feature is not enabled (#18740)
- New BigQuery driver with "Project ID (override)" defined causes different Field Filter references (#18725)
- Dashboard subscription send by Email fails with xlsx attachements (#18724)
- Textbox markdown links on images difficult to click (#18641)
- Some questions with old field dimensions or changed columns cannot be viewed, because of Javascript loop (#18630)
- Multi-column join interface defaults binning for numeric fields causing incorrect results (#18589)
- Sandboxing queries fails with caching is enabled (#18579)
- Changing redshift db details leads to closed or broken resource pool (#18499)
- Audit visualizations does not show correct information, when there's more than 1000 aggregated dates (#17820)
- "Set up your own alert" text needs padding (#17701)
- Dashboard Subscriptions are not deactivated, when dashboard is archived (#17487)
- ED25519 keys not working for built-in SSH tunnels (#15252)
- Pin Maps with more than 1000 results (LeafletTilePinMap) not working with native queries (#4394)
New in Metabase 0.41.1 (Oct 27, 2021)
- Enhancements:
- Tools for fixing errors problems with Postgres semantics of limits (blank display of error table) (#18432)
- Raise MB_DB_CONNECTION_TIMEOUT_MS to 10000 as default (#18354)
- Allow caching of fonts and images (#18239)
- Bug fixes:
- Not all endpoints are called, when doing FullApp embedding (#18552)
- XLSX export of large columns fails because of formatting limitations (#18531)
- Caching on 0.41.0 caches results for very long time (does not respect settings defined) (#18458)
- Exporting large amount of data can result in OutOfMemory (#18455)
- Chart descriptions (except table) is not shown in dashboards (#18454)
- Remapped (display value) columns are dropped in downloads (#18440)
- Filtering null-column via the drill-through action menu causes blank screen (#18386)
- Data Model shows blank page if there are any hidden tables in the database (#18384)
- Columns missing from exports, when viz settings are using older field dimensions (#18382)
- Pulses with rounded floats render a hanging decimal point in 0.41.0 (#18363)
- Pulse/Subscription table cards with two columns (string, integer) fail to render (#18352)
- [Add Database > Presto] Multiple JDBC field options (#18351)
- Impossible to choose fields from different schema on Field Filters (#18349)
- In email subscription, the original question title is shown instead of the curated title (v41) (#18344)
- Audit > Questions > Total runtime displays link instead of an actual time (#18317)
- KeyExchange signature verification failed for key type=ssh-rsa (#18316)
- Export to XLSX can fail, when there's a very high integer value (#18310)
- Questions -> all questions in Audit feature sorts by null values (#18271)
- Dashboard Subscription test email button does not show error messages (#18235)
- EE Audit App frontend does not display error messages if queries fail (#18124)
- Dashboard Textbox does not render links unless using Markdown (#18114)
- Pin map only containing null location results causes the frontend to constantly reload or blank page (#18061)
- X-Rays: Table field is shown as "null" in the title (#15737)
- Custom Column with the same name as a table column returns incorrect results when grouped (#14255)
- Adding data series to dashboard widget lags then sometimes hangs the UI (#13100)
New in Metabase 0.41.0 (Oct 7, 2021)
- Revamped Subscriptions and Alerts:
- We've heard your asks, and it's finally here: completely redesigned Dashboard Subscriptions and Alerts. Now they look and feel more like their in-Metabase counterparts, but easy to view in email or Slack.
- We're also giving everyone much more control over the Subscriptions and Alerts they receive, by letting you manage them from your account settings.
- For Pro and Enterprise plans, Admins can now see all subscriptions and alerts set up in their instance. Plus, Admins in these plans can now restrict the domains to which Subscriptions and Alerts can be emailed.
- Because Dashboard subscriptions are that much better, we're going to remove Pulses in favor of Dashboard Subscriptions in the next release (0.42). Pulses will still work in this release (and they look so much nicer!), but 0.41 will be Pulses’ final release. Don’t worry, when we release 0.42, we’ll provide you with tools to help migrate your existing Pulses to dashboard subscriptions, so you won't miss a beat.
- Fully redesigned permissions page (and a new permission level):
- We’ve revamped the Permissions section of the Admin Panel to make it easy to manage permissions in Metabases with lots of people and groups.
- Pro and Enterprise plans also now include a new Block Access permission, which ensures certain groups absolutely can not view content from specific databases, even if they have access to a collection with questions that use that database.
- Stay organized at scale:
- The flip-side of making it easy to ask questions is that your Metabase can fill up with a lot of questions. Pro and Enterprise plans now include tools to help large-scale organizations keep it all straight. To help you separate the data-team-blessed content from the ad hoc explorations from other folks, Admins can now mark collections as Official (they even get a ribbon!) and questions as Verified (they get a blue checkmark ?).
- Official and Verified items are clearly distinguishable throughout Metabase and get prioritized in search, so you can make sure people use the right dashboards and questions to make their decisions.
- Fully-formatted result downloads:
- Now, when you download the results of a question as Excel, Metabase honors all of the formatting you've defined in the question. Things like date and currency formats are kept throughout, as well as column ordering and visibility. Columns will even automatically resize in XLSX! And renamed columns are now honored in CSV and JSON as well.
- Since we were in that part of the code, we made sure filenames include a slug of the question title, so it's easier to distinguish between multiple, similar downloads.
- A better experience for questions with errors:
- We've improved the way we display SQL errors in the queries for many databases, so you can more easily debug them.
- In Pro and Enterprise plans, Admins can now go to one place ("Tools" in the Admin UI) to see all questions which returned as an error when last run, find the most viewed ones and go fix them. This is particularly useful after making schema changes.
- Find slow queries and optimize them:
- Sometimes queries are simply slow and heavy, but we want to help you make them faster (and help you save some big data warehouse bucks!).
- Pro and Enterprise plans now include tools to keep your Metabase lightweight and nimble. Now Admins in these plans can define precise result caching durations for individual questions and dashboards, and even at the database level. (which is great if you only load data into your warehouse once a day, for example.)
- And to figure out which queries need better caching (or rewriting), we built tools into the Audit experience to help you find slow and frequently used questions (you can also see if the cache for certain questions is being overridden too frequently).
- JOINs with multiple columns:
- You can now create more advanced queries while sticking to the Custom Question editor by using multiple column conditions for your JOINs. And now you can define the granularity of the JOIN criteria for dates—previously limited to just month and year.
- Lots of database driver improvements:
- We have a new, JDBC-based Presto driver, which supports Kerberos as an authentication scheme. If you're using Presto today, you'll see a message guiding you to upgrade.
- We also included a new, GCP-client-based BigQuery driver, which is faster and more stable than our previous one.
- More advanced authentications mechanisms are now supported for Oracle.
- And other improvements:
- If you have a chart with many series (e.g. monthly sales over time for every country in Central America), you'll now get a cleaner, scrollable legend, properly displaying the names for each series. And you can still hover them to highlight and click on them to drill down.
- Continuing on the improvements to dashboards in 41, when using filters, they stick to the top. So now when you scroll down, you can still see—and change—filter parameters without having to scroll up and down.
New in Metabase 0.41.0 RC (Oct 3, 2021)
- Revamped Subscriptions and Alerts:
- We've heard your asks, and it's finally here: completely redesigned Dashboard Subscriptions and Alerts. Now they look and feel more like their in-Metabase counterparts, but easy to view in email or Slack.
- We're also giving everyone much more control over the Subscriptions and Alerts they receive, by letting you manage them from your account settings.
- For Pro and Enterprise plans, Admins can now see all subscriptions and alerts set up in their instance. Plus, Admins in these plans can now restrict the domains to which Subscriptions and Alerts can be emailed.
- Because Dashboard subscriptions are that much better, we're going to remove Pulses in favor of Dashboard Subscriptions in the next release (0.42). Pulses will still work in this release (and they look so much nicer!), but 0.41 will be Pulses’ final release. Don’t worry, when we release 0.42, we’ll provide you with tools to help migrate your existing Pulses to dashboard subscriptions, so you won't miss a beat.
- Fully redesigned permissions page (and a new permission level):
- We’ve revamped the Permissions section of the Admin Panel to make it easy to manage permissions in Metabases with lots of people and groups.
- Pro and Enterprise plans also now include a new Block Access permission, which ensures certain groups absolutely can not view content from specific databases, even if they have access to a collection with questions that use that database.
- Stay organized at scale:
- The flip-side of making it easy to ask questions is that your Metabase can fill up with a lot of questions. Pro and Enterprise plans now include tools to help large-scale organizations keep it all straight. To help you separate the data-team-blessed content from the ad hoc explorations from other folks, Admins can now mark collections as Official (they even get a ribbon!) and questions as Verified (they get a blue checkmark ?).
- Official and Verified items are clearly distinguishable throughout Metabase and get prioritized in search, so you can make sure people use the right dashboards and questions to make their decisions.
- Fully-formatted result downloads:
- Now, when you download the results of a question as Excel, Metabase honors all of the formatting you've defined in the question. Things like date and currency formats are kept throughout, as well as column ordering and visibility. Columns will even automatically resize in XLSX! And renamed columns are now honored in CSV and JSON as well.
- Since we were in that part of the code, we made sure filenames include a slug of the question title, so it's easier to distinguish between multiple, similar downloads.
- A better experience for questions with errors:
- We've improved the way we display SQL errors in the queries for many databases, so you can more easily debug them.
- In Pro and Enterprise plans, Admins can now go to one place ("Tools" in the Admin UI) to see all questions which returned as an error when last run, find the most viewed ones and go fix them. This is particularly useful after making schema changes.
- Find slow queries and optimize them:
- Sometimes queries are simply slow and heavy, but we want to help you make them faster (and help you save some big data warehouse bucks!).
- Pro and Enterprise plans now include tools to keep your Metabase lightweight and nimble. Now Admins in these plans can define precise result caching durations for individual questions and dashboards, and even at the database level. (which is great if you only load data into your warehouse once a day, for example.)
- And to figure out which queries need better caching (or rewriting), we built tools into the Audit experience to help you find slow and frequently used questions (you can also see if the cache for certain questions is being overridden too frequently).
- JOINs with multiple columns:
- You can now create more advanced queries while sticking to the Custom Question editor by using multiple column conditions for your JOINs. And now you can define the granularity of the JOIN criteria for dates—previously limited to just month and year.
- Lots of database driver improvements:
- We have a new, JDBC-based Presto driver, which supports Kerberos as an authentication scheme. If you're using Presto today, you'll see a message guiding you to upgrade.
- We also included a new, GCP-client-based BigQuery driver, which is faster and more stable than our previous one.
- More advanced authentications mechanisms are now supported for Oracle.
- And other improvements:
- If you have a chart with many series (e.g. monthly sales over time for every country in Central America), you'll now get a cleaner, scrollable legend, properly displaying the names for each series. And you can still hover them to highlight and click on them to drill down.
- Continuing on the improvements to dashboards in 41, when using filters, they stick to the top. So now when you scroll down, you can still see—and change—filter parameters without having to scroll up and down.
New in Metabase 0.40.5 (Sep 21, 2021)
- Bug fixes:
- GeoJSON URL validation fix (#17991)
- Grid map causes frontend reload or blank screen, when hovering the grids if there is no metric (#17940)
- Cannot create more than 2 metrics, when UI language is Turkish - screen goes blank or displays "Something went wrong" (#16323)
- Visualizations with more than 100 series just shows a blank chart (#16000)Data point values uses formatting Style of first series on all series (#13095)
- Grid map causes frontend reload or blank screen, when hovering the grids if there is no metric (#17940)
- Cannot create more than 2 metrics, when UI language is Turkish - screen goes blank or displays "Something went wrong" (#16323)
- Visualizations with more than 100 series just shows a blank chart (#16000)
- Data point values uses formatting Style of first serie on all series (#13095)
New in Metabase 0.40.4 (Sep 10, 2021)
- Bug fixes:
- Dashboard filter autocomplete not working with mixed Search/Dropdown when dropdown has a null value (#17659)
- Not possible to delete Dashboard Subscription unless dashboard is in root collection (#17658)
- Possible to not input recipient of Subscription, which will then cause blank screen (#17657)
- Valid Email settings disappear on save, but re-appear after refresh (#17615)
- Unable to click "Learn more" on custom expression (#17548)
- Editing an alert causes it to be deleted in some circumstances (#17547)
- New databases with "This is a large database ..." still uses the default sync+scan settings (#17450)
- Adding cards to dashboard via search can cause the card to show spinner until browser refresh (#15959)
- Cannot login with OpenAM SAML since 1.38.3 (#15567)
- Native question "Filter widget type"="None" hides the filter widget even after changing it to something else (#13825)
New in Metabase 0.40.3.1 (Aug 31, 2021)
- This is a hotfix release to 1.40.3 to fix a UI issue.
New in Metabase 0.40.2 (Aug 4, 2021)
- Enhancements:
- Documentation improvements for 40.2 (#17303)
- Add Metabase Cloud link to admin settings for hosted instances (#17134)
- Fix dashboard card hovering buttons drag behaviour (#17130)
- Popover footer is displaced when using filter with a search input (#16830)
- Padding needed for button on map settings page (#16612)
- LDAP/Email settings gets cleared if validation fails (#16226)
- Modify instead of replace default EB nginx config (#5623)
- Bug fixes:
- Snippet folder permissions are always applied to root (#17268)
- Cannot start development in VS Code because of missing Node.js (#17233)
- Search widget on question builder hangs tab, API field search limit not respected (#17228)
- Only 50 groups are displayed (#17200)
- People search dropdown goes outside of the screen (#17186)
- Only 50 users shown in email autocomplete and "Other user's personal collection" (#17164)
- Dashboard - Adding ‘Click Behavior’ to an image field converts image to URL (#17161)
- Cannot upgrade to v0.40.x on AWS Elastic Beanstalk due to AWS Inspector not being available in certain regions (#17143)
- Elastic Beanstalk nginx config is not updated on latest EB docker images (#17115)
- Cannot deactivate users after the first 50 users (#17113)
- Tabs in the Audit section look broken (#17102)
- Duplication of the displayed table (#17060)
- Allow selecting text in Textbox cards, while dashboard is in edit-mode (#17039)
- Metabase on old AWS Elastic Beanstalk (Amazon Linux w/ old Docker) upgrade to 0.40 failed (#17012)
- Public Sharing footer is double-size because action buttons are stacked (#16798)
- Error when setting column type to Number in data model settings (#16781)
- Site URL can sometimes be incorrectly defined during startup (#16754)
- Serialization: Visualization column settings lost (#16150)
- Waterfall visualization does not work with ordinal X-axis (#15550)
- Clicking "Cancel" on collection archive modal should let you stay in that same collection (#15289)
- Snowflake Connector Requires Deprecated Region Id (#10142)
New in Metabase 0.40.1 (Jul 14, 2021)
- Enhancements:
- Remove Multi-Release from manifest (#17026)
- Global search suggestions dropdown appears behind the dataset search widget when starting a simple question (#16897)
- Clean up the user-facing strings for coercion options (#16547)
- Bug fixes:
- An error occurs when opening a public question with filters having default parameters (#17033)
- Questions filters does not work in Embedded/Public (#17019)
- Long titles in collections push out the last-edited-by and last-edited-at columns (#16991)
- Only first 50 databases are displayed (#16983)
- After hiding the column and then setting a required default value for SQL field filter (connected to that column) shows all fields as hidden and breaks SQL filters completely (#16914)
- Clicking Visualize in Notebook makes the question "dirty" even if no changes was made (#13470)
New in Metabase 0.40.0 (Jul 9, 2021)
- We're back with another big update to Metabase. Here's what's new.
- Dashboards just got a lot easier to build:
- We've outfitted the dashboard editing mode with two major upgrades:
- A new and improved way to add questions to your dashboards:
- Up until now, you've only been able to add questions to a dashboard one at a time. But now you can open up the sidebar to easily search for and add as many questions as you want. It's more satisfying than popping bubble wrap.
- Vastly improved reordering and resizing:
- When you move or resize a card, other cards float away to make room for the new card placement.
- A more intuitive way to start new questions from SQL results:
- One cool feature in Metabase is the ability to use the results of a saved question as the starting point for a new one. In particular, you can use SQL to wrangle some particularly unwieldy tables, save the query as a question, then let other people explore the results using the graphical query builder.
- With saved SQL questions, you'll now see a handy Explore results button that fires up the graphical query builder, with the SQL results loaded up as the starting data for your new question.
- Improved data selection:
- We've overhauled the search bar in the data picker for your new questions so that it now searches through all of your tables and saved questions instead of simply filtering the list.
- New in Metabase Enterprise Edition:
- Here are some new tricks we've added to the Enterprise edition to help you tame large Metabases.
- We've made it easy to find queries to optimize in the Audit tab:
- View query runs, average execution time, and total time running to help you track down and focus your optimization efforts on heavily-used queries.
- Better serialization:
- You can download your application metadata to take snapshots of your Metabase, or preload new Metabase instances with questions and dashboard. Serialization now captures customizations, like custom click behavior on dashboard cards, so your dashboards will be all wired-up and ready to go when you load them. Check out this article on serialization to learn more about what serialization can do, and how.
- Even more polish and enhancements:
- We've made a whole host of additional improvements to Metabase.
- Manage more people, faster: we've added search and pagination to the People tab in the Admin panel.
- Paginated search results (so you get results faster).
- Stronger password requirements (no more password123).
- Better human-friendly field names.
- URLs now show friendly names for databases, questions, dashboards, and collections. No links will break; we're just tagging on titles to the URL (e.g., "/question/123" becomes "/question/123-Orders-by-product")
- Better filter names.
- Metabase can now infer data types for custom columns, so it knows to show you the right filter options for that column.
- Date string formatting coercion.
- Links to docs to help you connect databases.
- Friendly custom expression error messages to help you debug faulty formulas.
- Better visibility into database connection pooling.
- Link settings for visualizations on columns (set up a link setting for a question once, so you don't have to redo it every time you add the question to a dashboard).
- Here is the full list of enhancements and bug fixes:
- Enhancements:
- Fix funnel appearance (#16626)
- Confusing UI when adding GeoJSON with no identifiers (#16613)
- Can't move item to "Our analytics" using drag-n-drop (#16498)
- Collections Metadata FE Implementation (#16356)
- Cannot filter only on longitude/latitude range - UX is forcing user to fill out values for both fields (#16291)
- Display link to database integration docs when connecting a new database (#16018)
- Infer the data type for Expression Dimension (custom column) (#15952)
- fix funnel dashboard card overflow (#15869)
- make TableInteractive cell more button-like (#15833)
- Bug fixes:
- Error message missing when logging in to a disabled account with Google sign-in (#16701)
- unix-timestamp->honeysql implementation for h2 is incorrect for microseconds (#16628)
- Better error handling when adding malformed GeoJSON (#16611)
- Can't archive a question from the Question page (#16512)
- Can't "Select All" collection items if all items are pinned (#16497)
- Bulk archive doesn't work (#16496)
- Selecting bin count on intermediate data question fails (#16379)
- Group by on a :Coercion/YYYYMMDDHHMMSSBytes->Temporal postgres column fails (#16335)
- Double binning menu for date fields when using Saved Question (Native) (#16327)
- Bug in values on data points for waterfall charts (#16246)
- Table view on Permissions shows error on browser refresh (#16237)
- Password login on SSO instance drops the redirect URL (#16216)
- No error is reported when adding SQLite database that doesn't exist (#16199)
- Specific combination of filters can cause frontend reload or blank screen (#16198)
- Dashboard Contains filter doesn't remain when clicking on Question title (#16181)
- Normal login errors are not surfaced if SSO is also active (#16122)
- Search endpoint breaks if single model asked for in postgres before 10 (#16059)
- Version info and hash missing in 'About Metabase' in master (#16045)
- Google sign-in client ID setting regularly fails to save (#15974)
- Surface password change error messages to users (#15954)
- Incorrect selection range leading to aggressive popover (#15851)
New in Metabase 0.40.0 RC 1 (Jun 30, 2021)
- A new and improved way to add questions to your dashboards:
- Up until now, you've only been able to add questions to a dashboard one at a time. But now you can open up the sidebar to easily search for and add as many questions as you want. It's more satisfying than popping bubble wrap.
- Vastly improved reordering and resizing:
- When you move or resize a card, other cards float away to make room for the new card placement.
- A more intuitive way to start new questions from SQL results:
- One cool feature in Metabase is the ability to use the results of a saved question as the starting point for a new one. In particular, you can use SQL to wrangle some particularly unwieldy tables, save the query as a question, then let other people explore the results using the graphical query builder.
- With saved SQL questions, you'll now see a handy Explore results button that fires up the graphical query builder, with the SQL results loaded up as the starting data for your new question.
- Improved data selection:
- We've overhauled the search bar in the data picker for your new questions so that it now searches through all of your tables and saved questions instead of simply filtering the list.
- New in Metabase Enterprise Edition:
- Here are some new tricks we've added to the Enterprise edition to help you tame large Metabases.
- We've made it easy to find queries to optimize in the Audit tab:
- View query runs, average execution time, and total time running to help you track down and focus your optimization efforts on heavily-used queries.
- Better serialization:
- You can download your application metadata to take snapshots of your Metabase, or preload new Metabase instances with questions and dashboard. Serialization now captures customizations, like custom click behavior on dashboard cards, so your dashboards will be all wired-up and ready to go when you load them. Check out this article on serialization to learn more about what serialization can do, and how.
- Even more polish and enhancements:
- We've made a whole host of additional improvements to Metabase.
- Manage more people, faster: we've added search and pagination to the People tab in the Admin panel.
- Paginated search results (so you get results faster).
- Stronger password requirements (no more password123).
- Better human-friendly field names.
- URLs now show friendly names for databases, questions, dashboards, and collections. No links will break; we're just tagging on titles to the URL (e.g., "/question/123" becomes "/question/123-Orders-by-product")
- Better filter names.
- Metabase can now infer data types for custom columns, so it knows to show you the right filter options for that column.
- Date string formatting coercion.
- Links to docs to help you connect databases.
- Friendly custom expression error messages to help you debug faulty formulas.
- Better visibility into database connection pooling.
- Link settings for visualizations on columns (set up a link setting for a question once, so you don't have to redo it every time you add the question to a dashboard).
- Enhancements:
- Fix funnel appearance (#16626)
- Confusing UI when adding GeoJSON with no identifiers (#16613)
- Can't move item to "Our analytics" using drag-n-drop (#16498)
- collections Metadata FE Implementation (#16356)
- Cannot filter only on longitude/latitude range - UX is forcing user to fill out values for both fields (#16291)
- Display link to database integration docs when connecting a new database (#16018)
- Infer the data type for Expression Dimension (custom column) (#15952)
- fix funnel dashboard card overflow (#15869)
- make TableInteractive cell more button-like (#15833)
- Bug fixes:
- Error message missing when logging in to a disabled account with Google sign-in (#16701)
- unix-timestamp->honeysql implementation for h2 is incorrect for microseconds (#16628)
- Better error handling when adding malformed GeoJSON (#16611)
- Can't archive a question from the Question page (#16512)
- Can't "Select All" collection items if all items are pinned (#16497)
- Bulk archive doesn't work (#16496)
- Selecting bin count on intermediate data question fails (#16379)
- Group by on a :Coercion/YYYYMMDDHHMMSSBytes->Temporal postgres column fails (#16335)
- Double binning menu for date fields when using Saved Question (Native) (#16327)
- Bug in values on data points for waterfall charts (#16246)
- table view on Permissions shows error on browser refresh (#16237)
- Password login on SSO instance drops the redirect URL (#16216)
- o error is reported when adding SQLite database that doesn't exist (#16199)
- Specific combination of filters can cause frontend reload or blank screen (#16198)
- Dashboard Contains filter doesn't remain when clicking on Question title (#16181)
- Normal login errors are not surfaced if SSO is also active (#16122)
- Search endpoint breaks if single model asked for in postgres before 10 (#16059)
- Version info and hash missing in 'About Metabase' in master (#16045)
- Google sign-in client ID setting regularly fails to save (#15974)
- Surface password change error messages to users (#15954)
- Incorrect selection range leading to aggressive popover (#15851)
New in Metabase 0.39.3 (May 28, 2021)
- Enhancements:
- LDAP settings form hitting wrong API endpoint on save (#16173)
- Fix Serialization P1s (#15756)
- Test LDAP settings before saving (#11446)
- Bug fixes:
- Feature flag causes problems with Number filters in Native query (#16218)
- Revoking access to users in multiple groups does not correctly cleanup GTAP (#16190)
- ExpressionEditor loses value when user resizes browser window (#16127)
- ExpressionEditor loses value when user clicks away from associated name input (#16126)
- Filter dropdown not working for non-data users, when field has 300+ distinct values. (#16112)
- Tooltip only shows first Y-axis value when X-axis is numeric and style is Ordinal/Histogram (#15998)
- Gauge visualization on small screens can cause frontend refresh on hover (#15980)
- Serialization: field-literal converted to field since 1.39.0 (#15971)
- Serialization dumps with static references instead of paths in 1.39.0 (#15812)
- Incorrect result + loss of user input when summarizing with Saved Question (#15725)
- Some places shows {0} placeholder instead of expected value (#15694)
- Serialization load-process does not update source-table in joins, leading to broken questions (#15283)
- Unchecking "Remember me" box has no effect -- close the browser and reopen, then go back to your MB instance and you're still logged in (#15223)
- Serialization dump includes Personal Collections (#15120)
- Serialization: Nested question references questions in other collection are moved and becomes corrupted (#14914)
- Serialization: Snippet folders and Collections collide on dump because of missing namespace separation (#14910)
- Serialization: Snippets are not transferred correctly, leading to incorrect references and broken queries (#14909)
- Serialization: Click Behavior not translating entitiy ID on dump, potentially referencing wrong entities on load (#14566)
- Wrong LDAP port input (non-numeric) can cause complete lockout (#13313)
- Nested queries using metric got wrong SQL (#12507)
- Cannot aggregate question with unix timestamp column that is converted/cast in Metabase (#12430)
- Nested queries using metrics need to include all columns used in metric filters (#8856)
New in Metabase 0.39.2 (May 18, 2021)
- Enhancements:
- Show right versions on enterprise custom builds (#15677)
- Not possible to select pinned collection item using checkbox (#15338)
- Collection tree loader causes UI jump (#14603)
- Need better instructions for setting up Google Auth (#9744)
- Bug fixes:
- Regression combining Druid date filters with dimension filters (#15903)
- Regression in filtering Druid table where greater than date (#15902)
- Variable Field Type after upgrade "Input to parse-value-to-field-type does not match schema" (#15901)
- Whitelabel favicon does not work correctly in all browsers (#15711)
- The new "contains" behavior for field value lookup doesn't work outside of dashboards (#15240)
- Cannot restore table visibility in Data Model, when database is down (#15165)
- LDAP user authorization failed with $ in password (#15145)
- Difficult to use some filters, when user has no data permissions [FE - Filter widget stops working if API endpoint returns 403] (#15119)
- Serialization: Dashboard cards are corrupted, when questions are outside of dashboard collection (#14912)
- Filters with dropdown lists uses query on the database (#13832)
- Login Failing for LDAP if user email isn't lowercase (#13739)
- Startup warning about unsupported class will impact performance (#13625)
- Auth Returns 400 Bad Request instead of 401 Unauthorized upon wrong credentials submission (#13140)
New in Metabase 0.39.1 (Apr 28, 2021)
- Enhancements:
- Table with multiple Entity Key columns incorrectly filtering on "Connected To" drill-through (#5648)
- Bug fixes:
- Tooltip shows incorrect values on unaggregated data with breakout (#15785)
- Can't use parentheses as expected in filter expressions (#15754)
- UI prevents adding 2 parameters to Percentile() function (#15714)
- Login logo is left-aligned on EE, when whitelabel features are enabled (#15713)
- No loading spinner when clicking a Collection on the home page (#15221)
- Tooltip on unaggregated data does not show summed value like the visualization (#11907)
New in Metabase 0.39.0 RC 2 (Apr 13, 2021)
- Enhancements:
- Add feature flag for the new 0.39.0 dashboard filter types (#15488)
- docs - add duplicate question section (#15421)
- docs - update search for 39 (#15419)
- Add an ENV var setting for typeahead search (#15379)
- Add missing "is" assertions to various tests (#15254)
- Custom Expression formula starts with high cursor placement on Firefox (#15245)
- Custom Expression filter not setting the "Done" button to current state of the formula until onblur (#15244)
- Normalize queries in URL fragments on FE (#15079)
- Support string and number filter operators in dashboard parameter filters (#15055)
- Allow users to more easiy explore saved SQL results (#15010)
- defsetting macro throw an Exception if you try to define a setting that's already defined in a different namespace (#15000)
- Fix render error when removing a dashboard parameter (#14999)
- Upgrade HoneySQL version to latest (#14934)
- Dashboard Filter Improvements (to support large-scale rollout) (#14930)
- SSH Connectivity Improvements (#14929)
- MBQL Refactor: Combine various Field clauses into one new clause (#14897)
- MongoDB shouldn't do an initial projection for :default date bucketing (#14838)
- Return richer API response for search (#14832)
- MongoDB & temporal filter query optimizations (#14829)
- Migrate Off Flow (#14802)
- Bug fixes:
- Pulse fails when visualization_settings is referring to a field-literal column (#15475)
- Login History not recording correct IP address (#15437)
- Questions based on Saved Questions is not using the same query for date filters leading to wrong results (#15352)
- Hitting return when modifying a custom expression incorrectly discards changes (#15241)
- metabase/metabase-enterprise-head Docker image doesn't have enterprise extensions (#15226)
- Custom expressions: UI is too wide when shown in the sidebar (#15217)
- Search: some results are as being in a folder which doesn't exist in the data reference (#15216)
- Error saving metric in data reference (#15127)
- Negative filter can not be converted to custom expression (#14880)
- Don't show stacktrace to users during SAML/JWT login (#14820)
New in Metabase 0.39.0 RC 1 (Apr 7, 2021)
- Enhancements:
- docs - add duplicate question section (#15421)
- docs - update search for 39 (#15419)
- Add an ENV var setting for typeahead search (#15379)
- Update MS SQL Server JDBC driver version (#15287)
- Fix Oracle SSL tests (#15260)
- Add missing "is" assertions to various tests (#15254)
- Custom Expression formula starts with high cursor placement on Firefox (#15245)
- Custom Expression filter not setting the "Done" button to current state of the formula until onblur (#15244)
- Only display schema in search results if there is more than one schema (#15230)
- Support string and number filter operators in dashboard parameter filters (#15055)
- Allow users to more easiy explore saved SQL results (#15010)
- defsetting macro throw an Exception if you try to define a setting that's already defined in a different namespace (#15000)
- Fix render error when removing a dashboard parameter (#14999)
- Upgrade HoneySQL version to latest (#14934)
- Dashboard Filter Improvements (to support large-scale rollout) (#14930)
- SSH Connectivity Improvements (#14929)
- MBQL Refactor: Combine various Field clauses into one new clause (#14897)
- Switch native query execution to use Statement instead of PreparedStatement (#14883)
- MongoDB shouldn't do an initial projection for :default date bucketing (#14838)
- Return richer API response for search (#14832)
- MongoDB & temporal filter query optimizations (#14829)
- Migrate Off Flow (#14802)
- Upgrade to React 16 (#14801)
- Semantic types pt 1 (special-type -> semantic-type rename) (#14780)
- Bug fixes:
- Hitting return when modifying a custom expression incorrectly discards changes (#15241)
- metabase/metabase-enterprise-head Docker image doesn't have enterprise extensions (#15226)
- Custom expressions: UI is too wide when shown in the sidebar (#15217)
- Search: some results are as being in a folder which doesn't exist in the data reference (#15216)
- Error saving metric in data reference (#15127)
- Negative filter can not be converted to custom expression (#14880)
New in Metabase 0.38.3 (Apr 2, 2021)
- Enhancements:
- Overflow text on Ask a question page (#15439)
- Frontend load issue: SMTP Email (#12692)
- Add Bitcoin as a unit of currency (#11406)
- Line chart dots don't have cursor: pointer when hovering (#5056)
- Bug fixes:
- Filtering on coerced column doesn't always know its coerced (#15317)
- Wrong series label in multiple series scatterplot (#15150)
- Dashboard Subscription fails for all SQL questions with a Field Filter on date column connected on dashboard (#15067)
- Dashboard Subscription Emails do not work with filtered Native Queries (#15066)
- Dashboard Subscription sidebar broken for Sandboxed users (#14990)
- Provide more logging information on permission errors when creating Cards (#14931)
- In Settings > Email, Save Changes is enabled even when there are no changes (#14749)
- Exports always uses UTC as timezone instead of the selected Report Timezone (#13677)
- Invalid Redirect Location After SAML Sign-in via Full App Embed (#13666)
- Cannot download XLSX if there's more than 1 million results (#13585)
- Pie chart sometimes does not show total (#12506)
- Users with collections "edit" permissions and no data access permissions can't edit question metadata (#11719)
- Column "Custom title" not working in tooltips (#11395)
- Schema sync does not update changes in column type case (#7923)
- Error on visualization change of a question with SQL queries view only permission (#6718)
New in Metabase 0.38.1 (Mar 9, 2021)
- Enhancements:
- Breadcrumbs can be confusing (the current one "seems" clickable when it's not) (#14879)
- Difficult to see which cells has "Click behavior" vs normal behavior (#13548)
- Bug fixes:
- Serialization dump of aggregated questions are not copied over on load (#15048)
- Serialization doesn't update Sub-Query variable reference (#15047)
- Oracle, BigQuery filtering by column with day-of-week bucketing not working (#15044)
- Pivot Table export not working on unsaved questions (#15027)
- Pivot Table does not work for users without data permissions (#14989)
- Pivot Table not working with Sandboxed user (#14969)
- BigQuery: Joins in the query builder generate invalid table aliases (#14933)
- BigQuery: Question Stays running until timeout when query is error in Native Query (#14918)
- Serialization: Archived items are included in dump (#14911)
- regexextract breaks query on sandboxed table (#14873)
- Multi-level aggregations fails when filter is the last section (#14872)
- Pivot queries aren't recorded to query execution log (#14765)
- Start of Week not applied to Field Filter in Native question, which can lead to incorrect results (#14294)
- In Safari 14, add-grouping button disappears randomly but consistently (#14131)
- Serialization does not initialize 3rd party drivers when loading a dump (#13614)
- Wrong day names are displayed when using not-Sunday as start of the week and grouping by "Day of week" (#13604)
- Object Detail previous/next buttons not working correctly (#13250)
- Global number formatting does not apply to percentages (#12659)
- Native question filter widget reordering doesn't work (#9357)
New in Metabase 0.38.0 (Feb 18, 2021)
- Enhancements:
- Pivot tables (#8572)
- Waterfall charts (#11904)
- Dashboard subscriptions (#13671)
- Collections Redesign Implementation (#13660)
- Restyled drill-through and actions popover (#13695)
- Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
- Add timeouts for both configurations (#13568)
- Add Swiss number formatting (Localization - Separator Style) (#13348)
- Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
- Don't set Site URL on requests from ELB HealthChecker (#12996)
- Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
- Docker image can not run as non-root (#9861)
- Add option to disable user ID/hash remark added to every SQL question (#8539)
- Add field descriptions to lists of fields in the Data Reference (#6316) — thanks to @rthouvenin!
- Support unix timestamps in microseconds (µs) (#1889)
- Add Special Type: DateTime String (ISO) (#1576)
- Write a smarter linter for our Liquibase migrations YAML file (#14092)
- Add a lightweight notify api endpoint (#14634)
- Allow usage of PKCS-12 certificates with Postgres connections (#14626)
- add cmd rotate-encryption-key (#14552)
- fix(rotate-encryption-key) settings-last-updated is not encrypted (#14769)
- Login page should automatically focus on the email input field (#14505)
- Bug fixes:
- Datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
- Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
- On startup sync, application says refingerprinting rather than fingerprinting (#14411)
- startup logging of database changes has null values in logs (#14409)
- "Automatically run queries" setting should default to ON when adding a new database (#14334)
- on startup sync, application says refingerprinting rather than fingerprinting (#14411)
- Startup logging of database changes has null values in logs (#14409)
- "Automatically run queries" setting should default to ON when adding a new database (#14334)
- Moved collections not being correctly included in api/collection/tree API response (#14280)
- Subcollection permissions not working right in sidebar on master (#14114)
- Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
- Custom GeoJSON files are not sorted in the dropdown (#14696)
- user@password JDBC connection strings for application DB no longer work (#14678)
- Shrunken bubbles shown in question for null values (#14662)
- Drilling down by a Region Map assigns the wrong value to the filter (#14650)
- Using "Reset to defaults" on textbox causes it to become a corrupted card on dashboard (#14644)
- Sandboxing on tables with remapped FK (Display Values) causes query to fail (#14629)
- dump-to-h2 does not return a non-zero exit code on failure (#14614)
- Bar chart x-axis positions can cause different spacing depending on the dates returned (#14605)
- dump-to-h2 with --dump-plaintext should check for presence of MB_ENCRYPTION_SECRET_KEY (#14588)
- Token check retry is too aggressive (#14514)
- Click Behavior with cross-filter sometimes does not list column options (#14473)
- Sandboxed question with case Custom Field doesn't substitute the "else" argument's table (#14859)
- Custom Expression using case() function fails when referencing the same column names (#14854)
- Filtering a Custom Column does not give correct results when using "Not equal to" (#14843)
- Cannot remove columns via QB sidebar, then query fails, but works if being removed via Notebook (#14841)
- Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
- Advanced Sandboxing using questions that return more/other columns than the sandboxed table is not possible anymore, but the errors are not helpful (#14612)
New in Metabase 0.38.0 RC5 (Feb 11, 2021)
- Enhancements:
- Add a lightweight notify api endpoint (#14634)
- Allow usage of PKCS-12 certificates with Postgres connections (#14626)
- Don't inform admins about MB cloud on EE instances (#14569)
- add cmd rotate-encryption-key (#14552)
- Add CTA to migrate to MB Cloud in admin panel (#14458)
- Bug fixes:
- Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
- Custom GeoJSON files are not sorted in the dropdown (#14696)
- user@password JDBC connection strings for application DB no longer work (#14678)
- Shrunken bubbles shown in question for null values (#14662)
- Drilling down by a Region Map assigns the wrong value to the filter (#14650)
- Using "Reset to defaults" on textbox causes it to become a corrupted card on dashboard (#14644)
- Sandboxing on tables with remapped FK (Display Values) causes query to fail (#14629)
- dump-to-h2 does not return a non-zero exit code on failure (#14614)
- Bar chart x-axis positions can cause different spacing depending on the dates returned (#14605)
- Custom Columns breaks Pivot Table (#14604)
- Pivot tables broken on dashboard after resize (#14591)
- dump-to-h2 with --dump-plaintext should check for presence of MB_ENCRYPTION_SECRET_KEY (#14588)
- Right alignment of pivot table value cells looks broken (#14574)
- Token check retry is too aggressive (#14514)
- Dashboard subscriptions including cards no longer in dashboard (#14497)
- UI should update when a collection changes parent (#14482)
- Click Behavior with cross-filter sometimes does not list column options (#14473)
- Pivot tables fail in dashboards (#14465)
- Pivot tables use the wrong public/embed endpoints (#14447)
- Error when opening child-collections on v0.38.0-rc2 (#14444)
- on startup sync, application says refingerprinting rather than fingerprinting (#14411)
- startup logging of database changes has null values in logs (#14409)
- Pivot tables can't handle pivoting when there's only a single grouping field (#14403)
- Dashboard subscriptions: broken dropdown when trying to set Slack subscription/pulse to Hourly (#14399)
- It's possible to create multiple dashboard subscriptions if the dashboard is slow due to slow viz types. (#14397)
New in Metabase 0.38.0 RC3 (Jan 27, 2021)
- Enhancements:
- Add CTA to migrate to MB Cloud in admin panel
- Pivot tables: numbers in cells should be right-aligned, not left:
- Dashboard subscriptions should respect dashboard filters' default values
- Pivot tables: subtotal rows missing when there are more than 2 fields in the "rows" bucket
- Add documentation for using saved questions as CTEs in the native SQL editor
- Pivot tables: visual polish
- Pivot tables should have standard drill-through actions
- Pivot tables: collapsable/expanding rows
- Document changes to collections layout
- Update docs with changes to drill-through/actions menus
- Bug fixes:
- Pivot tables fail in dashboards
- Pivot tables use the wrong public/embed endpoints
- Error when opening child-collections on v0.38.0-rc2
- on startup sync, application says refingerprinting rather than fingerprinting
- startup logging of database changes has null values in logs)
- Pivot tables can't handle pivoting when there's only a single grouping field Dashboard subscriptions: broken dropdown when trying to set Slack subscription/pulse to Hourly
- It's possible to create multiple dashboard subscriptions if the dashboard is slow due to slow viz types.
- Dashboard subscription emails shouldn't say "Pulse:" in subject line
- Sharing icon shouldn't appear on public dashboards
- Trying to visualize a SQL query's results as a pivot table locks up the UI
- App becomes nearly unusable after trying to visualize a pivot table with 3+ metrics and 3+ breakouts
- "Automatically run queries" setting should default to ON when adding a new database
- Moved collections not being correctly included in api/collection/tree API response
- Pivot tables are missing cells when there aren't records(?)
- Pivot Table creates failing query and never shows visualization
- Can't use a binned numeric dimension as a grouping in a pivot table
- The dashboard subscription sidebar should be the full height of the browser's viewport
- Results attachment settings for dashboard subscriptions don't persist
- Subcollection permissions not working right in sidebar on master
New in Metabase 0.38.0 RC2 (Jan 16, 2021)
- Enhancements:
- Dashboard subscriptions should respect dashboard filters' default values (#14291)
- Pivot tables: subtotal rows missing when there are more than 2 fields in the "rows" bucket (#14245)
- Add documentation for using saved questions as CTEs in the native SQL editor (#14198)
- Pivot tables: visual polish (#14177)
- Pivot tables: collapsable/expanding rows (#14171)
- Document changes to collections layout (#14098)
- Update docs with changes to drill-through/actions menus (#14095)
- Write a smarter linter for our Liquibase migrations YAML file (#14092)
- Document pivot tables (#14090)
- Document Waterfall charts (#14074)
- Pull in translations for new strings for 038 release (#14071)
- Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
- Restyled drill-through and actions popover (#13695)
- Collections Redesign Implementation (#13660)
- Add timeouts for both configurations (#13568)
- Bug fixes:
- on startup sync, application says refingerprinting rather than fingerprinting (#14411)
- startup logging of database changes has null values in logs (#14409)
- Dashboard subscriptions: broken dropdown when trying to set Slack subscription/pulse to Hourly (#14399)
- It's possible to create multiple dashboard subscriptions if the dashboard is slow due to slow viz types (#14397)
- Dashboard subscription emails shouldn't say "Pulse:" in subject line (#14395)
- Trying to visualize a SQL query's results as a pivot table locks up the UI (#14363)
- Custom expression errors are too verbose now (#14345)
- "Automatically run queries" setting should default to ON when adding a new database (#14334)
- Pivot tables are missing cells when there aren't records(?) (#14243)
- Pivot Table creates failing query and never shows visualization (#14148)
- Can't use a binned numeric dimension as a grouping in a pivot table (#14136)
- The dashboard subscription sidebar should be the full height of the browser's viewport (#14119)
- Results attachment settings for dashboard subscriptions don't persist (#14117)
- Subcollection permissions not working right in sidebar on master (#14114)
- datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
New in Metabase 0.38.0 RC1 (Dec 18, 2020)
- Enhancements:
- Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
- Restyled drill-through and actions popover (#13695)
- Collections Redesign Implementation (#13660)
- Add timeouts for both configurations (#13568)
- Add Swiss number formatting (Localization - Separator Style) (#13348)
- Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
- Don't set Site URL on requests from ELB HealthChecker (#12996)
- Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
- Docker image can not run as non-root (#9861)
- Add option to disable user ID/hash remark added to every SQL question (#8539)
- We should add field descriptions to lists of fields in the Data Reference (#6316)
- Support unix timestamps in microseconds (µs) (#1889)
- Add Special Type: DateTime String (ISO) (#1576)
- Bug fixes:
- datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
- Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
- axl_ini: support line continuation for values
- axl_gui: gui::Engine::writeClipboard should use sl::ArrayRef, not sl::Array
New in Metabase 0.37.4 (Dec 18, 2020)
- Bug fixes:
- Error in Query: Input to aggregation-name does not match schema (#14080)
- Exports always uses UTC as timezone instead of the selected Report Timezone (#13677)
- Between Dates filter behaves inconsistently based on whether the column is from a joined table or not (#12872)
New in Metabase 0.38.0 Preview (Dec 10, 2020)
- Enhancements:
- Restyled drill-through and actions popover (#13695)
- Collections Redesign Implementation (#13660)
- Add timeouts for both configurations (#13568)
- Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
- Don't set Site URL on requests from ELB HealthChecker (#12996)
- Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
- Docker image can not run as non-root (#9861)
- Add option to disable user ID/hash remark added to every SQL question (#8539)
- We should add field descriptions to lists of fields in the Data Reference (#6316)
- Add Special Type: DateTime String (ISO) (#1576)
- Bug fixes:
- Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
New in Metabase 0.37.0.2 (Oct 31, 2020)
- Note: v0.37.0.2 is the same as v0.37.0, but includes important bugfixes for BigQuery:
- BigQuery not working in 0.36.8/0.37.0
- Specify location on getQueryResults calls
New in Metabase 0.37.0.1 (Oct 24, 2020)
- Dashboard interactivity:
- Metabase 0.37 introduces some simple but powerful building blocks for adding interactivity to dashboards. You can combine these tools to build rich pathways through multiple dashboards to help users make sense of their data.
- Cross-filtering:
- You can now set up a chart on a dashboard to update the value of a filter in the dashboard when the chart is clicked.
- Linked dashboard filters:
- Say you have a State dashboard filter as well as a City one. In 0.37, you can now link the City filter to the State filter so that it only displays cities that make sense with the selected state.
- Custom click destinations:
- If you have a high level overview dashboard, you can now set things up so that clicking on a chart in that dashboard will send your users to another dashboard or saved question in Metabase, or to any other URL you'd like. To make it even better, you can also pass along values from the dashboard to the destination to filter it, or to customize the URL.
- Pick the first day of the week:
- Not everyone's week starts on Sunday, so Metabase now lets you pick what the first day of the week should be.
- Additional enhancements:
- Fix null handling in filters regression (#13570)
- Add translation for Bulgarian (#13558)
- Update translations for final 0.37 release (#13519)
- Only get substrings in fingerprinting when supported [ci drivers] (#13432)
- Suppress drag behavior when custom click behavior is set (#13414)
- Disable Done button in cases where click behavior target isn't specified (#13413)
- Interactivity summary tokens squashed on small dashboard cards (#13411)
- When mapping dashboard filters to columns, SQL questions should display the name of the column mapped to the field filter (#13376)
- Embedded versions of new chain filters endpoints (#13367)
- Update login layout and illustration. (#13099)
- Field Filter variables in SQL question don’t show table name when connecting filters in dashboard (#12792)
- Upgrade to log4j 2.x (#12719)
- SQL: sync only tables for which we have SELECT privilege (#10892)
- Option to limit tables/fields that are synced to specific schemas (#2591)
- We should have a way to check for table permissions when it affects schema visibility (#1654)
- Remove email case sensitivity from logins (#3047)
- We are now smarter about tagging state fields (#13512)
- To improve debugging, admin panel logs now show stacktraces (#12851)
- Bug fixes:
- Click behavior to Dashboard shown on Public/Embedded (#13551)
- NO_COLOR/MB_COLORIZE_LOGS does not remove all ansi codes (#13538)
- Filtering a joined table column by "Is not" or "Does not contain" fails (#13534)
- Monday week start displays incorrectly on bar chart (#13516)
- Linked filter showing all values (not filtering) (#13491)
- log4j should not output to file by default (#13422)
- weird edit state when saving a dashboard with incomplete click behavior (#13412)
- Hovering on custom map no longer displays region name, displays region identifier instead (#13410)
- "Click behavior" to URL for non-table card, doesn't show reference fields to use as variables (#13407)
- Variables from Saved Question are referencing the same question (#13406)
- Cannot create custom drill-through to dashboard (#13404)
- After clicking a custom link that passes a value to a param, clicking Back shouldn't bring that value to the original dashboard (#13380)
- Customizing a dashboard card's click behavior without specifying a destination causes strange behavior (#13375)
- Canceling the dashboard archive action takes you to the collection (#13374)
- "Does not contain" and "Is not" filter also removes nulls (#13332)
- Forward slash on table name causes ORA-01424 and blocks the sync step (#13225)
- MySQL grouping on a TIME field is not working (#12846)
- Presto not respecting SSL and always uses http instead of https (#13295)
- Don't try to sync Postgres schemas or tables current user has no perms for (#10139)
- Postgres sync not respecting SSH tunneling (#8396)
- Public dashboards does not show title in browser tab/window (#12227)
- Public Shared dashboard/question is missing description :info:-icon (#12015)
- Include Mouseover Description For Question Embeds (#8117)
- Public Link file format quick selector missing (#12406)
- Additional question column scrollbar issue in dashboard widget edit modal (#11129)
- SQL Server connector apparently using wrong port (#9226)
- Pulse sparklines with null in temporal column no longer fails (#12653)
- Creating an alert always no longer turns on email alerts when they are toggled off (#12349)
- Timeseries tick labels are now not always in English even when interface is another langage (#11319)
- Dashboard will no longer break after changing question variable that is already linked on dashboard (#9299)
- Fixes to Google Analytics and Segments (#13362)
- Many fixes to Excel (XLSX) and CSV export (#13447)
- Clicking on an ID field no longer shows an error (#13263)
- Fix to syncing with column type 'year' (#13203)
- Fix to permission paths with slash in schema names (#12450)
- Column title is no longer incorrect when joining by shared foreign key (#11452)
- You can now browse a BigQuery table when you have an integer column that's set as foreign key or entity key (#13475)
- Security improvements:
- Updated jetty to 9.4.32.v20200930 to address https://nvd.nist.gov/vuln/detail/CVE-2019-17638 (#13510)
New in Metabase 0.37.0 RC 3 (Oct 20, 2020)
- Bug fixes:
- Presto not respecting SSL and always uses http instead of https (#13295)
- Footer (with export/fullscreen/refresh buttons) on Public/Embedded questions disappears when using Premium Embedding (#13285)
- Postgres sync not respecting SSH tunneling (#8396)
- Partial remediation of OOM errors on syncing large columns/rows (#13288)
New in Metabase 0.36.7 (Oct 9, 2020)
- Presto not respecting SSL and always uses http instead of https (#13295)
- Footer (with export/fullscreen/refresh buttons) on Public/Embedded questions disappears when using Premium Embedding (#13285)
- Postgres sync not respecting SSH tunneling (#8396)
- Partial remediation of OOM errors on syncing large columns/rows (#13288)
New in Metabase 0.37.0 RC 2 (Oct 8, 2020)
- Enhancements:
- Update login layout and illustration. (#13099)
- Upgrade to log4j 2.x (#12719)
- SQL: sync only tables for which we have SELECT privilege (#10892)
- Remove email case sensitivity from logins (#3047)
- Option to limit tables/fields that are synced to specific schemas (#2591)
- Allow organizations to determine the start of their week (#1779)
- We should have a way to check for table permissions when it affects schema visibility (#1654)
- Bug fixes:
- Presto not respecting SSL and always uses http instead of https (#13295)
- Public Link file format quick selector missing (#12406)
- Public dashboards does not show title in browser tab/window (#12227)
- Public Shared dashboard/question is missing description :info:-icon (#12015)
- Additional question column scrollbar issue in dashboard widget edit modal (#11129)
- Don't try to sync Postgres schemas or tables current user has no perms for (#10139)
- SQL Server connector apparently using wrong port (#9226)
- Postgres sync not respecting SSH tunneling (#8396)
- Include Mouseover Description For Question Embeds (#8117)
New in Metabase 0.36.6 (Sep 16, 2020)
- Bug fixes:
- Custom Column not working on 0.36.5.1 (#13241)
New in Metabase 0.36.5.1 (Sep 12, 2020)
- Enhancements:
- Remappings should work on broken out fields (#5600)
- Bug fixes:
- Sync fails on Turkish system language on startup and crashes instance (#13102)
- LDAP auth doesn't support IPv6 addresses (#12879)
- Scheduled Jobs triggering on non-existant Database (#11813)
- Cannot use Saved Question, when original question uses "Display values"="Use foreign key" (#10474)
- Can't sync MariaDB System-Versioned tables (#9887)
- Floating-point rounding errors in UI for very large integers (JS stores all numbers as 64-bit floats) (#5816)
- Support unicode parameter names -- all non-ASCII characters are converted to _ when slugifying (#5313)
- Admin Settings page doesn't surface errors when saving settings (#4506)
- Trying to log in via Google Auth with a disabled account should display an error (#3245)
New in Metabase 0.36.4 (Aug 18, 2020)
- Enhancements:
- Handle large Slack channel lists (#11735)
- Bug fixes:
- Slack pulse issue with 0.36.0: Slack channel named metabase_files is missing & other channels missing from Pulse dropdown with > 1000 Slack channels (#12978)
- Only admins can search for tables via universal search. (#12332)
- MongoDB: Error filtering by ObjectId field with "Is empty" or "Not empty" options (#11134)
- BigQuery column of ARRAY type in results causes a casting exception (#10275)
New in Metabase 0.36.3 (Aug 5, 2020)
- Support for externally linked tables (#12741)
New in Metabase 0.36.2 (Jul 31, 2020)
- Bug fixes:
- Cannot setup new Metabase instance, when browser locale is different from available language (#13045)
- Cannot click some card titles on dashboard to go to question (#13042)
New in Metabase 0.36.1 (Jul 30, 2020)
- Bug fixes:
- Data Model Metrics shows error if using special combination of Custom Expressions (#13022)
- Dashboards with questions, that user doesn't haven't permissions to, breaks completely (#13005)
- Questions based on Saved Question joined with another Saved Question breaks Notebook (#13000)
- Field filters break SQL-type questions for Redshift data sources in v0.36.0 (#12984)
- Snowflake views stopped appearing (#12971)
- Can't use "Sum over time" or "Distribution" with nested question (#12568)
- Dashboard filter not working correctly when Field Type is Unix Timestamp (#12362)
- Filters are sometimes not applied when downloading data (#11557)
- Snowflake Tables Don't Show (#9511)
- "Custom Mapping" Display Value option is not available on tables with NULL entries (#8116)
- "Is empty" option filters out only NULL String (#5299)
New in Metabase 0.36.0 (Jul 22, 2020)
- 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:
- 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.
- Enhancements:
- Search: don't show inaccessible metrics & segments (#12916)
- Fix z-index for all auth wrappers (#12894)
- make jetty request header size configurable (#12683)
- Update data model nav (#12665)
- Improve error message when attempting to connect to Mongo with SSL (#12605)
- Don't complain about API endpoints/schemas missing docstrings when running linters (#12417)
- Bug fixes:
- :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)
- Download not working on revoking raw sql query access (#12745)
- Sync DB schema loses manual schema config (#12680)
- 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)
- Documentation links in app not correct (#12615)
- SQLite does not support Right or Full Outer joins (#12598)
- 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)
- Trend visualization fails, when results comes from cache (#12556)
- Column type of aggreated column in sql view is unkown (#12547)
- 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 on dashboard (#12455)
- Visualization type gets reset to "Table" (different scenarios) (#12361)
- 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)
New in Metabase 0.36.0 RC 2 (Jul 8, 2020)
- 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:
- 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
- Added support for SSH keys
- Added support for connection URIs for MongoDB and JDBC databases
- Jetty request header size is now configurable (#12683)
- You can now link dashboard filters to Custom questions with filtered aggregate data (#11007)
- 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 on dashboard (#12455)
- Visualization type gets reset to "Table" (different scenarios) (#12361)
- 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)
- Drill-through is broken on nested question (#11807)
- Visualization type cannot be saved when is only one result (#11675)
- 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)
New in Metabase 0.36.0 RC 1 (Jul 8, 2020)
- 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
- 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
- Added support for SSH keys
- Added support for connection URIs for MongoDB and JDBC databases
- Jetty request header size is now configurable (#12683)
- You an now link dashboard filters to Custom questions with filtered aggregate data (#11007)
- 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 on dashboard (#12455)
- Visualization type gets reset to "Table" (different scenarios) (#12361)
- 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)
- Drill-through is broken on nested question (#11807)
- Visualization type cannot be saved when is only one result (#11675)
- 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)
New in Metabase 0.35.4 (May 29, 2020)
- Custom column concat function errors on Amazon Redshift when using 3 or more parameters (#12544)
- Fingerprinting breaks on infinities (#12511)
- Custom columns failing when joined data has over about 30 columns (#12481)
- Fixed an issue where the Metabase logo was displaying too small (#12441)
- Adding custom field result in not being able to find columns from table (#12397)
- Create Slack Bot button has gone missing (#12382)
- Cannot view/edit table-level permissions for databases that are not schema-based (#12372)
- "Error reducing result rows" exception when downloading full results (#12339)
- Unable to create new personalized questions (#12323)
- Custom Column "ERROR: missing FROM-clause entry for table" Postgres (#12304)
- Upgrade to 0.35.0 release fails (#12223)
- Object Details (single record view) places the results outside of view (#11887)
- Zero-dates cause Pulses to fail (#11665)
- Cannot save question when results are empty (#11256)
- Line/area/bar charts are hiding x-axis labels too aggressively when scale is set to Timeseries (#11158)
- java.lang.NullPointerException when use TIMEDIFF (#10983)
- Not possible to restore visibility after setting "Do Not Include" in Data Model (#10297)
- Cannot read property 'lat' of null - Allow filter empty/not empty (like for dates) (#7361)
- Auto-refresh doesn't work for dashboards if redirected after login (#7244)
- Clicking link to unsaved question when logged out takes you to 404 page after login (#6317)
- Raw queries with "ON" date filter are broken for Druid [Regression] (#6290)
New in Metabase 0.35.3 (Apr 22, 2020)
- Enhancements:
- Improved error log messages on async responses (#12233)
- Bug fixes:
- Fixed a bug where homepage is missing sections (X-rays and Our data) on login with Google Signin (#12359)
- Fixed an issue where it was not possible to view or restore a table after setting Visibility to "Hidden" in Data Model (#12344)
- Corrected replace function name (#12306)
- Fixed an issue where saving native queries failed due to incomplete results_metadata (#12265)
- Fixed an issue where a query with the same column names didn't display properly (#12252)
- Fixed query failing on "Error reducing result rows" (#12251)
- Fixed regression with column not found error after adding a custom column (#12243)
- Fixed MBQL normalization bug (#11897)
New in Metabase 0.35.2 (Apr 11, 2020)
- Bug fixes:
- Improve form error handling (#12291)
- Fix email settings "Send test email" and "Clear" buttons (#12275, #12274)
- Fix "Premium embedding" setting (#12273)
- Cannot view/edit table-level permissions for databases that are not schema-based (#12269)
New in Metabase 0.35.1 (Apr 3, 2020)
- Bug fixes:
- This release fixes two high priority bugs that were in version 0.35.0
- Fixed a bug with date field filter variables in native queries and dashboards
- Fixed a bug that was preventing filtering on columns from manually joined tables
- 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.35.1
- Download the JAR here: https://downloads.metabase.com/v0.35.1/metabase.jar
- Notes:
- SHA-256 checksum for the 0.35.1 JAR:
New in Metabase 0.35.0 (Mar 31, 2020)
- Filter expressions, string extracts, and more:
- We've added filter expressions to let you write more complex filters that include ORs in them, and have also added a whole host of new spreadsheet-like functions to the custom column and custom metric formula editors.
- Reference saved questions in your SQL queries:
- You can now reference the results of saved questions in your SQL or native queries using syntax like with my_result as {{ #123 }} select * from my_result, where #123 is the ID number of a saved question.
- Performance improvements:
- We've refactored a number of things in this version, including how we handle the saved question "database" that allows you to use the results of saved questions as starting data for new ones. We hope you'll find that the net result is a much snappier loading times of pages throughout much of Metabase.
- Minor Enhancements:
- Replace util fns with ones from (updated) medley (#12061)
- Add background hover on bubble radio items (#12055)
- Add hover color to dash card titles (#12053)
- Add 'block' support to Select (#11894)
- Bug fixes:
- Improve chart value labels styling (#12160)
- Can't scroll columns list when creating a filter in the notebook (#12139)
- Cannot filter on joined/linked table when question has Custom Column (#12129)
- Expressions - Certain function text is impossible to read on hover (#12103)
- Homepage is missing sections (X-rays and Our data) on login (#12085)
- Public shared question does not show Y-axis (#12018)
- User with no data access are not allowed to see questions (#11932)
- Druid v0.17.0 Error for a simple query (#11925)
- Dashboard filter using boolean value sends string on browser reload (#11911)
- Cannot use mixed-type question filters on dashboard (#11882)
- Fixed a bug with date/range native query template tags for Unix timestamp columns (#11934)
- Don't use system command as alias with MySQL (#12098)
- Attempt to infer better base type for native queries (#12150)
- Fix some typos in docs (#12142)
New in Metabase 0.34.2 (Feb 7, 2020)
- Bug fixes:
- Fixed filtering on time fields in BigQuery (#11725)
- MongoDB single date/month field filters aren't working correctly (#11715)
- MongoDB single date field filters aren't working correctly (#11690)
- MongoDB Field filters variable in native query with nested fields not working (#11597)
- Native Query cannot be cancelled (#11713)
- Disappearing X-Axis in Scatter Plot (#11688)
- "Add to dashboard" popup shown when starting a new question (#11666) (#10672)
- Postgres "money" type breaks visualization (#11498)
- Postgres: Casting to Money is broken (#3754)
- Cannot click on some "Saved Questions" in personal collection (#11496)
- Diacritics in a user's name prevent a user's personal collection from being created via LDAP SSO (#10738)
- Text columns are converted aggressively to DateTime in charts (#11069)
- When report-timezone is set, Snowflake dates are returned from the day prior (#11036)
- Permission error messages are not showing (#10921)
- Don't abort on any 403 (#10816)
- Make MySQL metadata use utf8mb4 (#10691)
- Unexpected end of stream, read 0 bytes from 7 (#9885)
- Prefix "?" gets converted to "?" on save on RDS (#5192)
- Minor enhancements:
- We now log a warning when connecting to unsupported MySQL versions (#11767)
- We've updated the Google Analytics driver's Google dependency version (#11733)
New in Metabase 0.34.1 (Jan 14, 2020)
- Bug fixes:
- LDAP group sync broken on 0.34.0 (#11617)
- PermissionSQL questions cannot be viewed after granted "View access" (#11672)
- Unable to connect Presto in v0.34.0 (#11598)
- Can't edit segments (#11343)
- Charts not working with window smaller than 800px wide (#11619)
- Field filters mismatch Datetimes and Timestamps (#11578)
- Can't break out Google Analytics metrics by Date:Month (#11489)
- Metabase does not install new version of database plugins when upgrading (#11699)
- Fix issues where dates in Pulses could be formatted with wrong year (year of the start of the week instead of actual year) (#11692)
- Pulse charts don't honor custom column names (#11655)
- Boolean field filters don't work correctly for Oracle (#11693)
- MongoDB single date field filters aren't working correctly (#11690)
- Trend/SmartScalar visualization returns NaN when % growth over 1000 (#11630)
- Automagic dashboards fail on PeriodDuration.between (#11603)
- Native query on sql server with filter on bit column type throws exception- Invalid column name 'TRUE'. (#11592)
- Native/SQL editor displaces cursor one position to the right of mouse click (#11584)
- Interrupted typing when adding a SQL parameter (#11581)
- Native/SQL variable panel, cards jumps around when editing (#11580)
- Native questions shows Save-button without changing anything (#11572)
- Trend/Smart Number does not work when dates are descending (#11089)
- Enhancements:
- GeoJSON proxy response performance improvements and improved resource cleanup (#11706)
New in Metabase 0.34.0 (Jan 8, 2020)
- New features and enhancements:
- Added support for variables and field filters in native Mongo queries (#3653)
- Added option to display data values on Line, Bar, and Area charts (#4788)
- Improved behavior of SQL editor to no longer fade out previous results when editing a query (#10975, #11361)
- Improved the behavior when auto-visualizing GUI queries to persist the selected visualization (#10957)
- Dashboard cards now scroll the browser window when dragging to move them (#5333 — thanks @maxzheng!)
- Updated and optimized world and US states map files (#11436 — thanks @flamber!)
- Bug fixes:
- This release includes an overhaul of how Metabase handles timezones, and includes many fixes for timezone-related bugs and issues.
- Presto timezone bug (#10487)
- Date filter is not working correctly [MySQL] (#7968)
- TimeZone Problem [MySQL] (#6273)
- Datetime SQL parameters bug [MySQL] (#8567)
- Inconsistent timezone handling for time values (#10366)
- Zoom In for a table cell shows the values of the cell above, when using Group By Date Period (#11251)
- Google Analytics days/months/etc off by one (#4372)
- Google Analytics: Date filter "current" use wrong dates (#4492)
- Wrong Data fetched when using date Variables in query when using 'between' in where clause. (#8861)
- Bug: wrong date label displayed on line chart (#9366)
- Metabase uses UTC to determine current week for Google Analytics query filters (#9467)
- Google Analytics driver should use ga:yearWeek, not ga:isoYearIsoWeek in week segmentation (#9474)
- Google Analytics question shows days/weeks/months off by one (#9476)
- Google Analytics - Filter by Prior [X] Months Breaks "Last Month" (#10701)
- Additional fixes:
- Date filters throw error (BigQuery, v0.33.4) (#11222)
- Maximum call stack size exceeded opening a dashboard (#10127, #6701)
- Infinite loop on pie chart rendering (#11122)
- Cannot add more than one foreign key columns if primary columns are removed (#11499)
- Filter Equal with multiple IDs of Entity Key only shows Object Details of single ID (#11162)
- Column heading Filter does not load data options on first popup (#11120)
- Setup Page does not show any error messages (#10926)
- Docker Image Nearly Doubled in Size (#10771)
- French Guiana labelled as France in Map figures (#8609)
- Y-axis label requires manual entry (#10765)
New in Metabase 0.33.7.1 (Dec 15, 2019)
- Important security fix for Google Auth login
New in Metabase 0.33.6 (Nov 20, 2019)
- Bug Fixes:
- Fixed regression that could cause saved questions to fail to render (#11297)
- Fixed regression where No Results icon didn't show (#11282)
- Pie chart visual improvements (#10837)
- Fixed issue where changing table column order would prompt you to run the query again (#10466)
- Full list of closed issues is here.
- Notes:
- SHA-256 checksum for the 0.33.6 JAR:
New in Metabase 0.33.5.1 (Nov 14, 2019)
- New features
- Added Slovak translation (#11177)
- Bugfixes:
- Fixed support for MySQL 8 with the default authentication method (#9820)
- Fixed issues where timeline labels in timeseries charts chould show repeated months (#5916)
- Fixed errors with MySQL JSON columns (#9800, #9801)
- Fixed issues with X-axis label formatting in timeseries charts (#11113)
- Fixed issues with changing granularity in Google Analytics queries (#11137)
- Fixed missing data in tooltips in charts using the Linear Interpolation option (#11205)
- Fixed issue where Dashboards in mobile browsers did not render numbers in a human-friendly format (#10716)
- Fixed errors when syncing data warehouse columns whose type name is very long (#11002)
New in Metabase 0.33.5 (Nov 11, 2019)
- New features:
- Added Slovak translation (#11177)
- Bugfixes:
- Fixed support for MySQL 8 with the default authentication method (#9820)
- Fixed issues where timeline labels in timeseries charts chould show repeated months (#5916)
- Fixed errors with MySQL JSON columns (#9800, #9801)
- Fixed issues with X-axis label formatting in timeseries charts (#11113)
- Fixed issues with changing granularity in Google Analytics queries (#11137)
- Fixed missing data in tooltips in charts using the Linear Interpolation option (#11205)
- Fixed issue where Dashboards in mobile browsers did not render numbers in a human-friendly format (#10716)
- Fixed errors when syncing data warehouse columns whose type name is very long (#11002)
New in Metabase 0.33.4 (Nov 11, 2019)
- Enhancements:
- This release includes a number of improvements to custom columns and expressions:
- You can now reference joined columns in the custom column widget (#10759)
- Added support for custom expressions when using nested questions (#6164)
- Columns from joined tables now correctly show up inside a custom expression or custom column (#5775)
- Support for foreign keys in calculated columns (#2460)
- Bug fixes:
- Fixed bug where quotes in custom metrics were breaking Save button in Question Builder (#11054)
- Fixed a translation bug with Chinese when trying to select a date (#11014)
- Fixed a bug with converting Oracle questions to SQL timestamps (#11009)
- Fixed an issue where saving a question didn't work when using a mathematical operation in a custom expression (#10985)
- Fixed a bug where row charts were incorrectly displaying options to use line or area markings on the Display tab (#10974)
- Fixed an issue with filtering by month-of-year in MongoDB (#10954)
- Fixed an issue with resizing dashboard cards when clicking the resize corner (#10949)
- Fixed a bug where it was possible to run incomplete templated SQL queries (#10928)
- Fixed a tooltip bug with pie charts (#10914)
- Fixed a bug related to Internet Explorer 11 where charts were not correctly rendering (#10895)
- Fixed a bug where the x-axis on saved questions was being obscured (#10762)
- Fixed a bug with filtering by the current year in MongoDB (#10683)
- Fixed an issue AWS Elastic Beanstalk launch URL is broken (#10523)
- Fixed a bug where log scales weren't working in bar charts (#10384)
- Fixed an issue with field filters where default values weren't being correctly inserted for date widgets (#9489)
- Fixed a bug in pin maps where the draw-a-box-to-filter feature wasn't working (#9314)
- Fixed a pie chart bug where legends weren't displaying correctly as a percentage (#9004)
- Fixed a bug where you couldn't save added information in the Data Reference (#8443)
- Fixed a bug in dashboard edit mode where dragging on a time series would incorrectly trigger drill-through (#6888)
- Fixed a field filter category variable issue where you incorrectly had to specify a default value for optional clauses (#5541)
New in Metabase 0.33.3 (Nov 11, 2019)
- Enhancements:
- Chinese and Persian translations now available again
- Bug fixes:
- Fixed an issue here LDAP auth was not working for new users (#10291)
- Fixed an issue with tooltips not showing for some SQL questions (#10936)
- Fixed a problem where time-series were expecting the first row to be the date (#10818)
- Fixed a bug preventing pulses created by another admin to be deleted (#10859)
- Fixed a bug where month is displayed on line chart tooltips instead of week when grouped by week (#10841)
- Fixed an issue where updating Account Settings returned a permission error (#10810)
- Fixed a problem where the comma key works as comma even when it's not a comma in another keyboard layout (#10606)
New in Metabase 0.33.2 (Nov 11, 2019)
- Bug fixes:
- This update fixes a number of regressions that were inadvertently introduced by a bug fix that was included in version 0.33.1, as well as a regression with search results.
- Fixed bug where some line and bar visualizations were breaking (#10804)
- Fixed bug where saving new or existing questions resulted in an error (#10805)
- Fixed bug that was causing search results to load indefinitely (#10806)
- Fixed bug with numeric formatting (#10807)
- Fixed bug where pin map charts weren't loading (#10808)
New in Metabase 0.33.1 (Sep 5, 2019)
- Enhancements:
- Some UX improvements to the log-in screen (#10009)
- Pie charts are now centered on the screen (#10201)
- Bug fixes:
- Fixed conditional formatting not working (#10663)
- Fixed an issue where some previously saved column settings were not applied (#10703)
- Fixed an issue where pulses were not loading (#9891)
- Fixed the new metric query builder bar displaying "Invalid" (#10684)
- Fixed an issue where dashboard card viz settings weren't viewable in the Mac app or Safari (#10677)
- Fixed a bug that prevented viewing a dashboard without data access permission for fields connected to filters (#10656)
- Fixed an issue with migrations causing failures with multiple instances (#10651)
- Fixed Row Chart displaying incorrect data (#10580)
- Fixed an issue where the World Region map would freeze the question/dashboard window (#10483)
- Fixed intermittent errors when loading dashboards with filters (#9955)
- Fixed a bug with stacked bar chart drill-throughs being incorrect (#9361)
- Fixed a performance issue where dashboards in full screen were hanging Chromium and Firefox (#9359)
- Fixed an issue where not all the requested fields were showing up in tooltips(#8446)
- Fixed a bug where tables weren't loading when the Sample Dataset was removed (#8532)
- Fixed a display bug with Pulses where columns were being compressed (#8446)
- Fixed a column order problem with multi series breakouts (#6847)
- Fixed heatmap legends not being binned and overflowing (#6766)
- Fixed a bug where saved questions were incorrectly showing up as a "database" in the permissions screen (#5617)
- Fixed a pie chart display problem on mobile or small width on 0.33 (#10717)
- Fixed a bug where pie charts overlapped titles (#10700)
- Fixed Trend widget not working with years (#10699)
- Fixed some UI problems with "connected to" counters (#6830)
- Fixed a bug in the display of answers for large integer numbers (#5816)
- Fixed an issue while sorting on aggregated values (#10421)
- Fixed tables not allowing sorting on named aggregations (#10422)
- Fixed a bug where when a dashboard included a card someone doesn't have access to, it results in a JavaScript error rather than an informative message (#10247)
- Fixed an issue in the Admin Panel where error messages weren't displaying when adding Oracle DB
- (#10583)
- Fixed an issue where users were getting a "too many attempts" message when repeatedly logging in with correct password (#8736)
- Fixed a bug where navigating directly to a dashboard with custom SQL and parameters failed (#10350)
- Fixed an issue where NGINX_SERVER_NAME directive denies any access on elastic beanstalk (#6233)
- Notes:
- SHA-256 checksum for the 0.33.1 JAR:
New in Metabase 0.33.0 (Aug 20, 2019)
- A simple exploratory mode for asking questions
- A more powerful notebook-style query builder
- Better search
New in Metabase 0.33 RC 1 (Jul 31, 2019)
- A simple exploratory mode for asking questions
- This mode allows for easy summarizing, pivoting, and visualizing data.
- simple-question
- A more powerful notebook-style query builder
- Here you can create joins, do post-aggregation filtering, multiple stages of aggregating, and more.
- notebook
- Better search
- You can now use the search bar to find tables, segments, and common metrics. And as a shortcut, type the / key to activate the search bar.
- search-tables
- Other changes since the last preview build
- Added back the Ask a Question button, now with options for a Simple question, Custom question, or SQL.
- Improved table selection for asking Simple questions.
- Added option to turn auto-running queries off in View mode at the database level.
- Added ability to pick which columns to include when selecting data or doing a join in the notebook editor.
- Plenty of bug fixes and polish.
New in Metabase 0.32.10 (Jul 31, 2019)
- Reenable nonnumeric data to make up the cells of pivot tables (#8926)
- Fixeddashboard filters connected to different columns (#7640)
- Fixed dashboard filters on linked columns (#9364)
- Fixed dashboard filters not being able to be connected with a brand new dashboard (#10085)
- Fixed linked columns not being able to be added to a table (#9144)
- Improved logic for rounding or not rounding small number cards in dashboards (#4369)
- Fixed a bug where users couldn't log out or go automatically logged in in certain situations (#10039)
- Fixed a bug where when creating a new segment or metric it would require a description of changes (#10209)
- Allow other protocols to be clickable links (#10028)
- Make sure newly added users show up right away on the People page (#9857)
- Make sure admin settings dropdowns display their selection even when it's the default value (#9098)
- Fixed a behavior where category filters were jumping around when searching (#10162)
- Prevent exceptions when clicking on embedded dashboards (#7641 and #7137)
- Fixed a bug where grouping by week wasn't working when language settings were changed (#9892)
- Fixed an issue with charts overflowing the x-axis when a custom y-axis value is set (#10396)
- Fixed a bug with converting data to Dates (#10020)
- Fixed an issue with pie chart legends having too many decimal places (#10385)
- Fixed pulse card rendering (#10326)
- Fixed a problem with reordering filters in dashboards (#10299)
- Fixed an issue with Data Model table search being broken (#10272)
- Fixed an issue with minified React (#10191)
- Fixed date range picker unchecking the "include today" option when date range is changed (#10249)
- Fixed home page not loading if a user has no permissions to data (#10212)
- Better time-series axis placement (#10280)
- Fixed misaligned tooltips in Firefox (#10184)
New in Metabase 0.33.0 Preview 2 (Jul 4, 2019)
- Changes since the first preview:
- Lots of UI updates and changes to the default table / saved question view, including how summarizing and filters work.
- Removed the SQL Preview toggle.
- Bug fixes
New in Metabase 0.33.0 Preview (Jun 25, 2019)
- Version 0.33 of Metabase will introduce two whole new ways to eplore your data and get answers without using SQL. Because this is a pretty large change, we're doing an early preview release to let you try things out and let us know what you think.
- We'll likely do a few of these prereleases before the final release, and things are likely to change between now and then.
- Some highlights of this new upcoming version:
- A more powerful graphical query builder that allows you to create joins, do post-aggregation filtering, or multiple stages of aggregating, and more.
- A simpler eploratory mode that allows for easy summarizing, pivoting, and visualizing data.
New in Metabase 0.32.9 (Jun 15, 2019)
- Fixed issue where adding a Database during setup would not actually add the Database (#10135)
- Fix issues connecting to MongoDB Atlas Cluster (#9867)
- Fixed numeric category error with Postgres (#10103)
- Fixed issue where deactivated users could still receive email Pulses (#6418)
- Fixed issue where hitting Refresh button cached question did not generate new results (#7282)
- Support column & table names with slashes in them (#2137)
- Fixed tons of small issues with query results vizualization (#8540, #9870, #7486, #10054, #9986, #10055, #8109, #9486, #9461, #9795, #10040)
New in Metabase 0.32.8 (May 14, 2019)
- Fixed regression that caused i18n to stop working on 0.32.7 (#9938)
- Fixed regression where syntax error messages for Postgres SQL queries would not be shown in certain circumstances (#9942)
- Fixes issues that could cause the Admin panel to stop loading on new instances (#9950)
New in Metabase 0.32.7 (May 10, 2019)
- Fixed regression where queries could fail with Could not initialize class error messages (#9769)
- Fixed regression where Dashboards would fail to fully populate (#9693)
- Fixed regression where CSV/XLSX downloads would be incorrectly limited to 2,000 rows (#9831)
- Fixed longstanding issue where Google Analytics queries generated 8-day ranges for previous/next week queries (#9475)
- Performance improvements when running queries (#9918, #9911)
- Security improvements by further tightening our Content-Security-Policy header (#9899)
- Fixed non-null constraint violation errors when syncing certain MongoDB databases (#9888)
- Fixed longstanding timezone issues in SQL Server (#8326)
- Fixed longstanding issue where XLS/CSV download for embedded Questions would be limited to 2000 or 10,000 rows (depending on type of query) (#9651)
- Fixed Invalid response from database driver. No :status provided. error messages (#9818)
- Fixed issues when setting Metabase site URL via environment variables (#9849)
- Fixed bug that could cause application to fail to load if value of site-url was invalid (#9764)
- Fixed Refused to load manifest from 'http://localhost:3000/app/assets/img/site.webmanifest' errors (#9745)
- Update to latest Redshift JDBC driver version (#9922)
- Fixed log configuration error messages on launch (#9771)
New in Metabase 0.32.6 (May 9, 2019)
- Improvements and fixes:
- Fixed regression where queries could fail with Could not initialize class error messages (#9769)
- Fixed regression where Dashboards would fail to fully populate (#9693)
- Fixed regression where CSV/XLSX downloads would be incorrectly limited to 2,000 rows (#9831)
- Fixed longstanding issue where Google Analytics queries generated 8-day ranges for previous/next week queries (#9475)
- Performance improvements when running queries (#9918, #9911)
- Security improvements by further tightening our Content-Security-Policy header (#9899)
- Fixed non-null constraint violation errors when syncing certain MongoDB databases (#9888)
- Fixed longstanding timezone issues in SQL Server (#8326)
- Fixed longstanding issue where XLS/CSV download for embedded Questions would be limited to 2000 or 10,000 rows (depending on type of query) (#9651)
- Fixed Invalid response from database driver. No :status provided. error messages (#9818)
- Fixed issues when setting Metabase site URL via environment variables (#9849)
- Fixed bug that could cause application to fail to load if value of site-url was invalid (#9764)
- Fixed Refused to load manifest from 'http://localhost:3000/app/assets/img/site.webmanifest' errors (#9745)
- Update to latest Redshift JDBC driver version (#9922)
- Fixed log configuration error messages on launch (#9771)
New in Metabase 0.32.5 (Apr 20, 2019)
- Fix issues in Dashboards where Cards with long-running queries would load slowly or not at all (#9693)
- Major improvements to the way Metabase handles long-running queries to prevent reverse proxies like nginx from canceling them due to timeouts before they finish (#9817)
- Fix issue where H2 to MySQL/Postgres migration tool could fail with sizeX cannot be null message (#9756)
- Fix issue where maps powered by custom GeoJSON files would not display on embedded Dashboards (#5338)
New in Metabase 0.32.4 (Apr 10, 2019)
- Improvements and fixes:
- Fix issue where Google Auth login did not work (#9738)
- Fix issue where Sessions could expire too soon, requiring more frequent logins
- Notes:
- SHA-256 checksum for the 0.32.4 JAR:
New in Metabase 0.32.3 (Apr 9, 2019)
- Improvements and fixes:
- Fixed issue where copying a dashboard created an empty dashboard (#9683)
- Fixed issue where login did not work when running Metabase in a non-root context (#9718)
- Fixed issue where Metabase did not keep connections alive for slow-running queries (#9693)
- Fixed issue where Snowflake connections failed with "Authentication token expired" errors (#9674)
- Improved error handling when unable to save TaskHistory rows for constrained application DBs like Heroku hobby instances (#9723)
New in Metabase 0.32.2 (Apr 4, 2019)
- Improvements and fixes:
- Fixed dashboard date filters on single dates (#9090)
- Fixed an issue where bar and line charts in dashboards that included multiple questions were incorrectly displaying with the same color (#9636)
- Fixed an issue where when an instance was set up with HTTPS, log in over HTTP stopped working (#9630)
- Fixed an issue where Quartz job store didn't work when using MySQL application database with SSL connection (#9650)
- Notes:
- SHA-256 checksum for the 0.32.2 JAR:
New in Metabase 0.32.1 (Apr 1, 2019)
- Improvements and fixes:
- Fixed MySQL connections with SSL (#9629)
- Fixed an issue where tables were sometimes not syncing correctly (#6825 and #6953)
New in Metabase 0.31.2 (Dec 8, 2018)
- New Features:
- Added German translation (#9066)
- Bug Fixes:
- Fixed failures due to improper handling of dimension parameters using a foreign key (#9017, #8917, #8837)
- Fixed Heroku out-of-memory errors (#9016, #3360)
- Fixed date handling for nested queries based on SQL (#9007)
- Fixed problem with cumulative sum aggregation (#8978)
- Fixed minus sign disappearing when using table column formatting (#8968)
- Fixed issue with Slack-based Pulses due to rate limiting (#8967)
- Fixed an issue with the MongoDB driver (#6678)
- Enhancements:
- Added warning when using incorrect SSL settings for Postgres (#8908)
New in Metabase 0.31.1 (Dec 7, 2018)
- New Features:
- Added the ability to duplicate a dashboard (#7254)
- Enhancements:
- Updated Metabase to use a newer, supported Docker image (#8459)
- Faster launch time and smaller JAR size
- Bug Fixes:
- Fixed out-of-memory issues on Heroku hobby/small/1x dynos (#3360)
- Fixed several database migration failures (#8909, #8937, #8924)
- Fix running queries with more than one aggregation of the same kind on MongoDB and Druid (#4166 and #5393)
- Fixed issue where non-admin users weren't allowed to create top-level Collections regardless of their permissions (#8949)
- Fixed issue where starting a new question based on a saved question that included sorting did not work in SQL Server (#8985)
- Fixed issues related to click-through actions and page refresh with calculated columns (#8854 and #8940)
- Fixed regression where starting a new question based on a saved question using a JOIN was not working properly (#8972)
- Fixed regressions running certain queries with MongoDB (#8929 and #8894)
- Fixed regression where some questions with invalid parameters made it impossible to run certain queries or edit certain dashboards (#8914)
- Fixed regressions related to filtering by datetime (#8932, #8073, #8927)
New in Metabase 0.31 RC 1 (Oct 31, 2018)
- Some highlights for this release:
- Gauge charts
- Line and bar combo charts
- Trendlines
- Smart numbers
- Global, field, and per question formatting options and improvements.
- Currency metadata and display
- Updated table visual design
- Reorder-able dashboard filters
New in Metabase 0.30.4 (Oct 1, 2018)
- Bug Fixes:
- Fix BigQuery SQL parameters with encrypted DB details
- Metabase fails to launch in Chinese
- Fix token status checking
New in Metabase 0.30.3 (Sep 14, 2018)
- Improvements:
- Translations for Chinese, Japanese, Turkish, Persian
- #8515 Reduce potential XSS surface area
- Bug Fixes:
- #8371 Self referencing FK leads to "column reference is ambiguous" exception
- #8516 Fix gear alignment in admin panel
New in Metabase 0.30.2 (Sep 7, 2018)
- Improvements:
- Localized in French and Norwegian
- Bug Fixes:
- #8312 Dashboards not loading when using https
- #8428 core.async take/put ops in go blocks use single ! functions
- #8368 Saved credentials encryption is DISABLED for this Metabase instance.
- #8296 Map does not appear in drop down menu of VISUALIZATION.
- #8386 Mongodb: date field fingerprint error
- #8372 When deleting a database, typing localized "DELETE" won't work
New in Metabase 0.30.1 (Aug 21, 2018)
- Improvements:
- Localized in Portuguese
- Bug Fixes:
- #8261 SQL template tags reordering while editing
- #8328 timezone issue
- #8262 0.30 data passed by filter
- #8260 Unable to render certain graphs using Slack integration
- #5507 Foreign key remappings aren't applied to nested queries
New in Metabase 0.30.0 (Aug 9, 2018)
- This is a big one folks. After a bunch of work this summer we're happy to announce Metabase 0.30. It's our biggest update since we first released Metabase and we're very excited to have you all start playing with it.
- Collections all the way down:
- Many of you have asked for this for a long, long time, and since we couldn't agree with you more, collections are now first class citizens in Metabase. You can organize dashboards, questions, and pulses into collections with their own permissions and nest collections to set things up just the right way for your team.
- Pins:
- Now that you can sort things into collections, we figured you'd want to mark whats important while you're at it. In any collection you can pin dashboards or questions that should stand out from the pack and they'll show up right at the top of the page. For even faster access to what matters, any dashboard you pin in the new "Our analytics" default collection will show up right on the home page, so you can direct your users to those right after they log in.
- App wide search:
- Need to find those marketing numbers for Q3 of last year that you tucked away inside of one of those new collections? Search has come to the navbar so you can find exactly what you're looking for no matter where you are. You can also filter by item type in collections and in search results.
- Comparisons:
- Curious how Widgets are performing against Gizmos? Well you work at GizWidget Inc, so of course you are. Clicking on any bar or point in a line chart will now offer you the option to look at a comparison of that segment vs the others in the specified dimension.
- Conditional formatting:
- Need to highlight how well or how badly things are going in a table? You can now add conditional formatting to tables to highlight the positive or negative aspects of your data. The settings you choose will even show up in pulses.
- Bug Fixes:
- Per usual there are many assorted bug fixes and tweaks as well.
New in Metabase 0.30.0 RC1 (Jul 31, 2018)
- Collections all the way down:
- Many of you have asked for this for a long, long time, and since we couldn't agree with you more, collections are now first class citizens in Metabase. You can organize dashboards, questions, and pulses into collections with their own permissions and nest collections to set things up just the right way for your team.
- Pins:
- Now that you can sort things into collections, we figured you'd want to mark whats important while you're at it. In any collection you can pin dashboards or questions that should stand out from the pack and they'll show up right at the top of the page. For even faster access to what matters, any dashboard you pin in the new "Our analytics" default collection will show up right on the home page, so you can direct your users to those right after they log in.
- App wide search:
- Need to find those marketing numbers for Q3 of last year that you tucked away inside of one of those new collections? Search has come to the navbar so you can find exactly what you're looking for no matter where you are. You can also filter by item type in collections and in search results.
- Comparisons:
- Curious how Widgets are performing against Gizmos? Well you work at GizWidget Inc, so of course you are. Clicking on any bar or point in a line chart will now offer you the option to look at a comparison of that segment vs the others in the specified dimension.
- Conditional formatting:
- Need to highlight how well or how badly things are going in a table? You can now add conditional formatting to tables to highlight the positive or negative aspects of your data. The settings you choose will even show up in pulses.
- Bug Fixes:
- Per usual there are many assorted bug fixes and tweaks as well.
New in Metabase 0.29.3 (May 13, 2018)
New in Metabase 0.29.2 (May 11, 2018)
- Spark SQL Driver not working
New in Metabase 0.29.0 (May 2, 2018)
- New and improved X-rays #7048
- Setting up Metabase for the first time or exploring a new dataset you just connected to is now easier with X-rays. You can now get instant insights and overviews into what’s going on with your data, and even generate entire dashboard-like explorations on the fly to explore specific points of interest.
- Search field values #4241
- If you're dealing with names, addresses, or any large set of values when filtering questions or dashboards you can now search for values and get results back as you type.
- Spark SQL support - #7323
New in Metabase 0.28.6 (Apr 13, 2018)
- #7210 Pulses not showing figures - metabase.pulse.render.NumericWrapper
New in Metabase 0.28.5 (Apr 5, 2018)
- Bug Fixes
- #7253 Public dashboard fail to show data on v0.28.4
- #7243 Memory issue: Java process eats up all the memory, but query doesn't even get run in db engine
- #7197 java out of memory issues
- #7212 Invalid parameters on embedding dashboards
- #7223 Unable to add cards to dashboards or search for cards, StackOverflowError on backend
New in Metabase 0.28.4 (Mar 30, 2018)
- Bug Fixes:
- [Bug] Dashboard filters sends filter value as string ( regression of #3816 ? )
- Invalid parameters on embedding dashboards
- Migrating from using the H2 database to Postgres error: Database "/data/metabase/metabase.db.h2.db" not found [90013-194]
- Upgrading from 0.26.2 to 0.28.1 Fails with insert or update on table "report_card" violates foreign key constraint "fk_report_card_ref_database_id"
- Typing to search for Fields when editing Dashboard Params results in jumping cursor
New in Metabase 0.28.3 (Mar 24, 2018)
- Bug fixes:
- #7189 dashboards are visible to everyone
New in Metabase 0.28.2 (Mar 21, 2018)
- Bug Fixes:
- #6973 Validate DashCard params
- #6889 Extremely poor UI performance - activity/dashboard/database apis run MANY queries
- #5943 Cannot sort on custom and saved metrics
New in Metabase 0.28.1 (Feb 10, 2018)
- Bug Fixes:
- #6901 CSV & XLSX downloads return internal server error
- #6895 Bar Charts in Pulses not rendering with user-defined X/Y axis
- #6926 Fix text card scroll visibility
- #6898 fix update settings version info text in translation tag
New in Metabase 0.28.0 (Feb 9, 2018)
- New Features:
- Time datatype support
- Attach full table CSV to pulse?
- Multiselect Dashboard Option
- Mongodb 3.6 support
- Improvements:
- Virtualize AccordianList to resolve performance issues with many dbs/schemas/tables/fields
- Metabase doesn't run on Heroku without 1GB of memory
- Stream all JSON responses [ci drivers]
- Druid HyperUnique aggregator in View dropdown
- Allow custom connection options for vertica
- Fix excessive DB calls on reference guide
- Notify users when alert emails are disabled
- Include "today/this week/this month/this year" in relative date filters
- Add option to disable Table/Field name humanization completely
- Bug Fixes:
- Seems like a bug in a BigQuery join
- [Breaking] Unable to save or access questions based on Google Analytics
- Permission for collection is not working well when dashboard has a card which made of multi questions
- No Time selection (day/month/etc...) on nested queries in "groupby"
- SQLite error java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open_utf8([BI)V
- Analytics.googleapis.com service no longer exists
- Problem with calendar picker
New in Metabase 0.27.2 (Dec 13, 2017)
- Bug Fixes:
- Check to ensure database exists before updating card in migration #6568
New in Metabase 0.27.1 (Nov 30, 2017)
- Bug Fixes:
- Failed to upgrade to v0.27.0 (#6494)
- Editable filters are not applied for embedded question download (#6407)
New in Metabase 0.27.0 (Nov 29, 2017)
- New Features:
- Alerts! Run a query every few minutes and get notified when a condition is met. (#1373)
- Improvements:
- X-Ray improvements: downsampling (#6365)
- Postgres 10 Support (#5424)
- Java 9 support (#6430, #6393, #6299, #6250)
- Add support for Postgres citext type columns (#6172)
- Show values for all columns in chart tooltips (#5886)
- New chart axis ticks spacing algorithm prevents overlapping ticks from cluttering up your beautiful charts (#5473)
- Add Europe/Istanbul timezone support
- Ability to rename series in charts (#5951)
- When adding a Question to a Dashboard, don't ask about adding to a Collection if none exist (#4668)
- Add timestamp formatting for Druid select queries (#6015)
- Bug Fixes:
- Fixed issue saving questions based on Google Analytics (#6104)
- Fix serverissues running on Java 9 (#6430)
- Fixed incorrect error message for GET /api/card endpoint (#6462)
- Fixed issue with too much blank space when selecting SQL template tag types (#6371)
- Fixed issue where group be week in Druid displayed incorrect results (#6047)
- Fixed issue with setting timezone for queries on Redshift databases (#6279)
- Fixed Mac App behavior on devices with smaller screens (#6301)
- Fixed issue where editing the name of a SQL parameter always moved the cursor to the end (#3231)
- Fixed issue where default value for SQL Field Filters wasn't used in certain cases (#6059)
- Fix timeseries ticks disappearing when resizing window (#6340)
- Fix issue where all-blank strings were allowed on signup page but returned server error (#4459)
- Fix issue where 7 % appeared as 7.0000001 % on axis labels (#3959)
- Fix issue parsing variable names in SQL template tags with leading or trailing whitespace (#5954)
New in Metabase 0.26.1 (Sep 28, 2017)
New in Metabase 0.26.0 (Sep 26, 2017)
- New features:
- A revamped New Question flow that helps highlight your company's metrics and segments. (#5790)
- New options to schedule when database syncing and analysis occurs (#5510)
- Binning values on histograms (#5331)
- X-rays and Comparisons: a new way to get in-depth insights into your fields and segments
- Enhancements:
- You can now page through records in the detail view with the arrow keys or buttons (#5832)
- Improved goal line visibility in night mode (#5831)
- Bug fixes:
- Fixed a suite of bugs having to do with timezones (#5729)
- Fixed some issues with category filter values (#5150)
- Fixed autocomplete not behaving in SQL editor (#5806)
- Fixed a bug that was showing questions that didn't support nested queries (#5788)
- Fixed dependencies caused by x-rays (#5711)
- Fixed a bug that didn't let you use more than one segment in a query (#5706)
- Fixed an unnecessary warning on SQL queries with blank column values (#5637)
- Fixed an issue with nested queries which contained segment filters (#5530)
- Fixed a bug where table metadata wasn't getting updated for removed fields (#5292)
- Fixed the "potentially useful questions" section of the Data Reference (#5055)
- Fixed a bug with the edit mode of the Data Reference (#5717)
- Lots of little fixes to modals throughout the product
New in Metabase 0.26.0 RC1 (Aug 30, 2017)
- New features:
- A revamped New Question flow that helps highlight your company's metrics and segments. (#5790)
- New options to schedule when database syncing and analysis occurs (#5510)
- Binning values on histograms (#5331)
- X-rays and Comparisons: a new way to get in-depth insights into your fields and segments
- Enhancements:
- You can now page through records in the detail view with the arrow keys or buttons (#5832)
- Improved goal line visibility in night mode (#5831)
- Bug fixes:
- Fixed a suite of bugs having to do with timezones (#5729)
- Fixed some issues with category filter values (#5150)
- Fixed autocomplete not behaving in SQL editor (#5806)
- Fixed a bug that was showing questions that didn't support nested queries (#5788)
- Fixed dependencies caused by x-rays (#5711)
- Fixed a bug that didn't let you use more than one segment in a query (#5706)
- Fixed an unnecessary warning on SQL queries with blank column values (#5637)
- Fixed an issue with nested queries which contained segment filters (#5530)
- Fixed a bug where table metadata wasn't getting updated for removed fields (#5292)
- Fixed the "potentially useful questions" section of the Data Reference (#5055)
- Fixed a bug with the edit mode of the Data Reference (#5717)
- Lots of little fixes to modals throughout the product
New in Metabase 0.25.2 (Aug 10, 2017)
- Bug Fixes:
- SQlite databases stopped working after migrating
- Metabase is REALLY Slow after 0.25.0 update
New in Metabase 0.25.1 (Jul 28, 2017)
- New Features /Enhancements:
- Better UI state for db adding in admin section
- Bug Fixes:
- After upgrading to 0.25, unknown protocol error.
- Don't show saved questions in the permissions database lists
- Elastic beanstalk upgrades broken in 0.25
- Learn more link in custom field menu is broken
- dashboard filter of a boolean field shows no option text and cannot filter false
- Available aggregation types do not take into account the linked tables
New in Metabase 0.25.0 (Jul 26, 2017)
- New Features:
- Use a query as table (subquery)
- Alias Integer (Enum) Columns
- Display foreign key name instead of ID
- Feature Request: LDAP Authentication
- Enhancements:
- We should update our Welcome modals
- Make the startup loading screen more interesting
- Bug Fixes:
- Comma Separated Numbers In Number Field To Be Used With IN Operator
- Date-based drillthrough not working using Vertica for weeks, months and years.
- Loss of navigation on smaller screen sizes
New in Metabase 0.24.2 (Jun 2, 2017)
- Bug Fixes:
- Can't save permission change on table
- Question lineage when drilling through broken
- Ends with filter button text wrapping in Safari/Mac app
- Questions list looks empty if you haven't created questions yet
- Download bug on V0.24.0
- If a question is in the activity feed and archived, it can be accessed but won't return any results
New in Metabase 0.24.1 (May 14, 2017)
- Metabase v24 database upgrade fails with Mariadb
New in Metabase 0.24.0 (May 10, 2017)
- New Features:
- Connect to databases via SSH tunnel
- Support PrestoDB
- Feature: Drill-down reporting
- Cached questions
- Enhancements:
- improved dashboard organization
- Allow a dashboard to be archived
- Support Oracle Service Name connection option
- Support expression-aggregations for BigQuery
- Bug Fixes:
- Unable to connect to SQLServer with special characters in DB password
- I shouldn't be able to click on card titles on public dashboards
- Custom field (formula) and custom expression forms are broken
- Something wicked this modal way comes.
- Embed codes use self-closing iframe tag, which isn't valid and may break things
- BigQuery driver fails to execute queries with two of the same aggregation
- Named aggregations in BigQuery can't have spaces/special characters
- Some time filter options are not working on Druid
- Cannot connect to BigQuery datasource with > 10000 tables
New in Metabase 0.23.1 (Mar 31, 2017)
- Enhancements:
- Add widget support to field filter template tags
- Use kmeans to automatically group map data
- In the filters when asking a question, when entering a filter value, hitting enter should apply the filter
- Postgres tests should only run when the postgres engine is enabled
- Return a sensible status message on /api/health while starting up
- Update User Docs for Funnel Visualization
- Possibility to copy/paste list of value in filters
- Bug Fixes:
- Password Reset Failed: Attempting to call unbound fn: #'metabase.db/select-one-id
- Version 0.23 not working on Java 1.7
- Email option can't be enabled when creating a pulse
- Funnel display broken on Firefox
- Mutli-series scalar dashboard cards don't work
New in Metabase 0.23.0 (Mar 31, 2017)
- New Features:
- Optional Encryption for Database Details
- Allow embedding of cards in other websites
- Allow embedding of dashboards in other websites
- Public Cards & Dashboards
- Enhancements:
- Reworked QueryExecutions Table
- Hidden tables being shown as suggestions - SQL query builder
- Bug Fixes:
- Collection permissions page not working in master
- Variables - Text value contains single quotes
- Internet Explorer 11: error "Out of stack space" on all dashboards
- Native Queries w/ an initial null causes the type of a column to be marked as "type/*"
- Installation Follow up email received every day
- Converting a Question to SQL causes map to render no colors and NaN - NaN for the legend
- Loading a dashboards sometimes query the card twice (1x without default filters and 1x with)
- Creating label in Chinese failed
New in Metabase 0.22.2 (Jan 27, 2017)
- #4242 - 0.22.1 jar installation does not start on Open JDK 7
New in Metabase 0.22.1 (Jan 26, 2017)
- Enchancements:
- Skip loading Liquibase if not needed
- Bug Fixes:
- Users can't see question which they have collection permission but not data permission
- Progress bar visualization doesn't render in Safari
- Removed admin still receives new user emails
- White space after editor was hidden
- No edit icon after edit question
- Native MongoDB queries don't work if they contain ISODate() calls
New in Metabase 0.22.0 (Jan 21, 2017)
- NEW FEATURES:
- Collections + Collection Permissions
- Allow multiple aggregations
- Expression aggregations
- Provide a JSON download of a saved question
- BUG FIXES:
- Date Filter : Next | Previous (Week/Month/etc) can't be set at 2 (0.21.0)
- Option for downloading CSV with no rows limit
- Saving a named custom expression gives blank screen
- Metabot / slack bot doesn't start
New in Metabase 0.21.1 (Dec 28, 2016)
- BUG FIXES:
- Regression: BigQuery - empty 'Choose an aggregation' dropdown
- Google App Engine adding charset=ISO-8859-1 to Content-Type header
- Pin map uses inverted latitude and longitude
- BigQuery: Unexpected error introspecting table schema
- Nullpointer exception for some BigQuery results
- Support native parameters in BigQuery
New in Metabase 0.21.0 (Dec 9, 2016)
- NEW FEATURES:
- Vertica Driver
- Google Analytics driver
- time filter improvements
- ENHANCEMENTS:
- when a user runs a query that returns too many rows and is truncated, if the user graphs the results, we should let them know not all results came back
- User should be able to create a new dashboard when saving a new question
- Remove Angular
- Document the REST API
- Switch to using Leaflet for all maps visualizations (pin map, heat)
- BUG FIXES:
- CSV Download for SQL Query Returns Default Value on Variable
- BigQuery INTEGER type should be mapped to Long not Integer
- Tables with a large number of columns can't be displayed as raw data
- SQlite databases stopped working after migrating
- All User list is not consistent with People list When summing by month, the NULL group's sum is added to a random month
- Additional filter on saved question results in hanging "Doing Science" dialog, doesn't redraw.
- MySQL TINYINT(1) columns are always interpreted as booleans UI pulled back to query answer after navigating away from query while "doing science"
- Slow loading in custom query
- Pin Map keeps zooming on San Francisco
- Cards / queries break and can't be modified if underlying column is removed
New in Metabase 0.20.3 (Oct 27, 2016)
- #3677 - Dashboard cards didn't retain size after migrating from H2
New in Metabase 0.20.2 (Oct 26, 2016)
- Bug Fixes:
- #3641 - Users without write permissions can't download csv
- #3568 - Oracle Queries fail - Unable to display Raw Data
- #3637 - 0.20.1 Still getting error on migration from h2 to mysql, PermissionsGroup Duplicate Entry
- #3643 - Revision history is using an incorrect date
- #3652 - Updates section is showing 0.20.0 being more recent than 0.20.1
New in Metabase 0.20.1 (Oct 25, 2016)
- Bug Fixes:
- #3539 - If multiple parameters target a single SQL field filter variable only one is applied
- #3601 - slack: document requirement of metabase_files channel during setup
- #3359 - Database details contain stale data
- #3516 - Improve the modal message when trying to add a group that already exists
- #3518 - Cannot remove a slack token from slack setup in admin.
- #3558 - Segments Definition 'Filtered by [Unknown Field]'
- #3566 - Can't add card to dashboard with a line chart AND a dashboard filter, javascript error
- #3603 - Admin Panel : Database form not loading properly
- #3592 - On migration from h2 to mysql, duplicate entry error with PermissionsGroup
- #3283 - MB_PASSWORD_COMPLEXITY/MB_PASSWORD_LENGTH not being respected
- #3545 - Label issue after upgrading to v0.20.0.
- #3538 - Dashboard relative date filter widget doesn't work with SQL card field filter variables
- #3570 - Column 'show_in_getting_started' cannot be null error in getting started
- #3571 - Data Reference Fails
- #3537 - Labels on GeoJSON "display name" and "identifier" property settings are reversed
New in Metabase 0.20.0 (Oct 25, 2016)
- New Features:
- #3362 - Permissions Stage 1
- #1344 - Oracle Database Driver
- #745 - New visualization type: Progress Bar
- #646 - bubble chart option
- #645 - scatter plot chart option
- #2663 - Implement hierarchical field type system
- #2530 - Give admins ability to create a Getting Started guide for their users
- Enhancements:
- #896 - Ensure that time series breakouts have continuous grouping values
- #2740 - Way to add a country map other than US?
- Bug Fixes:
- #2971 - login doesn't redirect to original location
- #3338 - Dashboard dropdown menu should close when you click outside of it
- #3323 - Disabling Google OAuth locks Google login users out
- #3437 - Google login without a metabase account should display an error page
- #3470 - All cards in dashboards are greyed-out
New in Metabase 0.19.3 (Oct 25, 2016)
- Bug fixes:
- #3169 - After upgrading to 0.19.2 the card buttons have disappeared from LineAreaBarChart
New in Metabase 0.19.2 (Oct 25, 2016)
- Bug Fixes:
- #3146 Missing chart title after loading data
- #3152 Pin Map keeps zooming on San Francisco
New in Metabase 0.19.1 (Oct 25, 2016)
- #3112 - Enable Metabot toggle not working in admin slack settings
- #3096 - Can't add dashboard level filter
- #3090 - CSV downloads don't respect SQL variables/parameters
- #3095 - Strange behaviour with single series line chart
New in Metabase 0.19.0 (Oct 25, 2016)
- New Features:
- #1008 - Support SSO via Google Auth
- #2348 Support parameters for Saved SQL Questions
- Enhancements:
- #612 - Specify which columns to use in chart
- #1445 - Allow users to select fields to be displayed in the table
- #2907 - Fix n+1 DB calls in GET /activity
- Bug Fixes:
- #2899 - Admin "Setup" list shouldn't count sample db for "Add a database" or yourself for "Invite team members"
- #2845 - Timeouts not being displayed in dashboard errors
- #2874 - Hour-of-day formatting is wrong on Druid
- #2906 - Getting set up steps don't route
- #2915 - Favorite Questions is throwing a 500 if I don't have any
New in Metabase 0.18.1 (Oct 25, 2016)
- Enchancements:
- #2812 - Add documentation on how to upgrade your Metabase instance
- Bug Fixes:
- #2829 - Hour of Day is being sorted incorrectly in line charts
- #2823 - Foreign key fields appearing as "field" in FieldName widget
- #2821 - Column Ordering
- #2819 - Hour-of-day line charts ordered incorrectly
- #2732 - Native queries for Mongo and visualisation
New in Metabase 0.18.0 (Oct 25, 2016)
- New Features:
- #2556 - Support Dashboard Level filters
- #2502 - Allow Native Queries for Druid
- #647 - Add "cumulative count" aggregation type
- #607 - Enable the ability to switch from gui to sql after running a question
- Enhancements:
- #2537 - Metabase should respond to "metabot"
- #2459 - Automatically hide Rails framework tables
- #2419 - Automatically hide Django framework tables
- #1749 - Make default dashboard query timeout of 60 seconds configurable
- #2386 - Prepend Query Metadata in SQL Comment
- Bug Fixes:
- #2801 - Highlighting a selection of SQL & typing to replace brings cursor to end of query
- #2786 - Done button appearing when it shouldn't
- #2784 - Charts on dashboards are showing multiseries headers where they shouldn’t be
- #2780 - Object detail doesn't always show up when clicking on primary key
- #2753 - Calm down Metabot's overeager responses
- #2744 - Admin checklist should correctly check off the "Organize Questions" item
- #2738 - Native BigQuery SQL queries broken
- #2738 - Filtering by clicking cell in table visualization doesn't wrap field in fk-> form when needed
- #2616 - App crashing after database upgrade on Heroku
- #2606 - Return minimum value when query maximum value in druid
- #2085 - Visualization overwrites column ordering with A-Z order