Metricflow

Breaking Changes

- Remove SQL-Comment-Based Tags ([1034](https://github.com/dbt-labs/metricflow/issues/1034))

Features

- Enable querying metric_time without metrics. ([928](https://github.com/dbt-labs/metricflow/issues/928))
- Enable querying cumulative metrics with their agg_time_dimension. ([1000](https://github.com/dbt-labs/metricflow/issues/1000))
- Enable offset metrics to be queried with agg_time_dimension. ([1006](https://github.com/dbt-labs/metricflow/issues/1006))
- Add Support for Consistent SQL Query Generation ([1020](https://github.com/dbt-labs/metricflow/issues/1020))

Fixes

- Validate that there are metrics or group by items in each query. ([1002](https://github.com/dbt-labs/metricflow/issues/1002))
- For measures that join to time spine, allow joining when agg_time_dimension is queried. ([1009](https://github.com/dbt-labs/metricflow/issues/1009))
- Join to time spine if requested for conversion metric input measures. ([1048](https://github.com/dbt-labs/metricflow/issues/1048))
- Enable querying offset metric with multiple agg_time_dimensions at once. Also fixes a bug when filtering by a different grain than the group by grain. ([1052](https://github.com/dbt-labs/metricflow/issues/1052), [#1053](https://github.com/dbt-labs/metricflow/issues/1053))
- Bug fix: if measure joins to time spine, apply filters again after that join. ([1039](https://github.com/dbt-labs/metricflow/issues/1039))
- Improve error message for metrics/queries with missing inputs ([1051](https://github.com/dbt-labs/metricflow/issues/1051))

Docs

- change group-bys to group-by in the tutorial message

Under the Hood

- Add test for nested derived metric filter rendering bug fixed in 0.204.0 ([920](https://github.com/dbt-labs/metricflow/issues/920))

Dependencies

- Remove unused numpy dependency ([984](https://github.com/dbt-labs/metricflow/issues/984))
- Update Jinja2 past 3.1.3 to resolve CVE-2024-22195 ([1049](https://github.com/dbt-labs/metricflow/issues/1049))

Contributors
- [batou9150](https://github.com/batou9150)
- [courtneyholcomb](https://github.com/courtneyholcomb) ([#928](https://github.com/dbt-labs/metricflow/issues/928), [#1000](https://github.com/dbt-labs/metricflow/issues/1000), [#1006](https://github.com/dbt-labs/metricflow/issues/1006), [#1002](https://github.com/dbt-labs/metricflow/issues/1002), [#1009](https://github.com/dbt-labs/metricflow/issues/1009), [#1048](https://github.com/dbt-labs/metricflow/issues/1048), [#1052](https://github.com/dbt-labs/metricflow/issues/1052), [#1053](https://github.com/dbt-labs/metricflow/issues/1053), [#1039](https://github.com/dbt-labs/metricflow/issues/1039))
- [plypaul](https://github.com/plypaul) ([#1034](https://github.com/dbt-labs/metricflow/issues/1034), [#1020](https://github.com/dbt-labs/metricflow/issues/1020))
- [tlento](https://github.com/tlento) ([#1051](https://github.com/dbt-labs/metricflow/issues/1051), [#920](https://github.com/dbt-labs/metricflow/issues/920), [#984](https://github.com/dbt-labs/metricflow/issues/984), [#1049](https://github.com/dbt-labs/metricflow/issues/1049))

Features

- Add Trino support to the MetricFlow. ([207](https://github.com/dbt-labs/metricflow/issues/207))
- Implemented date_part in where filter. ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Resolve Ambiguous Group-By-Items ([887](https://github.com/dbt-labs/metricflow/issues/887))
- Support for Conversion Metrics ([252](https://github.com/dbt-labs/metricflow/issues/252))
- Add a Query Validation Rule for Repeated Metrics in a Query ([943](https://github.com/dbt-labs/metricflow/issues/943))
- Expose label on Metric & Dimension for use in APIs. ([956](https://github.com/dbt-labs/metricflow/issues/956))

Fixes

- Apply time offset for nested dervied & ratio metrics ([882](https://github.com/dbt-labs/metricflow/issues/882))
- Fix Incorrect SQL Column Name Rendering for WhereConstraintNode ([908](https://github.com/dbt-labs/metricflow/issues/908))
- `Unable To Satisfy Query Error` with Cumulative Metrics in Saved Queries ([917](https://github.com/dbt-labs/metricflow/issues/917))
- Fixes a bug in dimension-only queries where the filter column is removed before the filter has been applied. ([923](https://github.com/dbt-labs/metricflow/issues/923))
- Bug fix: Keep where constraint column until used for nested derived offset metric queries. ([930](https://github.com/dbt-labs/metricflow/issues/930))
- Fixes incorrect time constraint applied to derived offset metrics. ([925](https://github.com/dbt-labs/metricflow/issues/925))
- Remove default time constraint for queries with cumulative metrics. ([917](https://github.com/dbt-labs/metricflow/issues/917))
- Return exit code 1 for failed validations ([867](https://github.com/dbt-labs/metricflow/issues/867))
- Optimizer Does Not Deduplicate Common Metrics ([941](https://github.com/dbt-labs/metricflow/issues/941))
- Duplicate input measures after combiner optimizer ([969](https://github.com/dbt-labs/metricflow/issues/969))

Under the Hood

- Test to ensure Dimension and TimeDimension syntax are identical in the case of time dimensions
- Fixed typo in error message

Dependencies

- Remove unnecessary MarkupSafe dependency ([950](https://github.com/dbt-labs/metricflow/pull/950))

Contributors
- [DevonFulcher](https://github.com/DevonFulcher)
- [WilliamDee](https://github.com/WilliamDee) ([#252](https://github.com/dbt-labs/metricflow/issues/252), [#867](https://github.com/dbt-labs/metricflow/issues/867), [#969](https://github.com/dbt-labs/metricflow/issues/969))
- [courtneyholcomb](https://github.com/courtneyholcomb) ([#956](https://github.com/dbt-labs/metricflow/issues/956), [#882](https://github.com/dbt-labs/metricflow/issues/882), [#923](https://github.com/dbt-labs/metricflow/issues/923), [#930](https://github.com/dbt-labs/metricflow/issues/930), [#925](https://github.com/dbt-labs/metricflow/issues/925))
- [plypaul](https://github.com/plypaul) ([#887](https://github.com/dbt-labs/metricflow/issues/887), [#943](https://github.com/dbt-labs/metricflow/issues/943), [#908](https://github.com/dbt-labs/metricflow/issues/908), [#917](https://github.com/dbt-labs/metricflow/issues/917), [#917](https://github.com/dbt-labs/metricflow/issues/917), [#941](https://github.com/dbt-labs/metricflow/issues/941))
- [sarbmeetka](https://github.com/sarbmeetka) ([#207](https://github.com/dbt-labs/metricflow/issues/207))
- [tlento](https://github.com/tlento) ([#950](https://github.com/dbt-labs/metricflow/pull/950))

Fixes

- Fix error in cumulative metric output when start-time and end-time are specified ([869](https://github.com/dbt-labs/metricflow/issues/869))

Dependencies

- Remove Rudderstack client and associated dependencies ([866](https://github.com/dbt-labs/metricflow/pull/866))
- Relax version pin on typing extensions to allow >=4.4, <5 ([875](https://github.com/dbt-labs/metricflow/pull/875))

Contributors
- [tlento](https://github.com/tlento) ([#869](https://github.com/dbt-labs/metricflow/issues/869), [#866](https://github.com/dbt-labs/metricflow/pull/866), [#875](https://github.com/dbt-labs/metricflow/pull/875))

Breaking Changes

- Use FULL OUTER JOIN to combine input metrics for derived metrics. This is a change from using INNER JOIN and may result in changes in output. ([842](https://github.com/dbt-labs/metricflow/issues/842))
- Update Dependencies to Use `dbt-semantic-interfaces~=0.4.0` ([846](https://github.com/dbt-labs/metricflow/issues/846))

Features

- Enable DATE PART aggregation for time dimensions ([770](https://github.com/dbt-labs/metricflow/issues/770))
- Support Saved Queries in MetricFlow ([765](https://github.com/dbt-labs/metricflow/issues/765))
- Support for sort order in query interface ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Support for the Dimension(...).grain(...) syntax for the where parameter ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Support querying dimensions without metrics. ([804](https://github.com/dbt-labs/metricflow/issues/804))
- Join to time spine and fill nulls when requested on metric input measures. ([759](https://github.com/dbt-labs/metricflow/issues/759))
- Fill nulls for multi-metric queries ([850](https://github.com/dbt-labs/metricflow/issues/850))

Fixes

- Removing methods and reordering parameters for Query Interface. ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Coerce time granularity to configured value to prevent finer-grained timestamps from causing unexpected query behavior ([714](https://github.com/dbt-labs/metricflow/issues/714))
- Prioritize source nodes based on correct cost ([801](https://github.com/dbt-labs/metricflow/issues/801))
- Enables case insensitivity for various query params. ([802](https://github.com/dbt-labs/metricflow/issues/802))
- Ensure extract calls return consistent results across engines ([792](https://github.com/dbt-labs/metricflow/issues/792))
- The --order param was being dropped from CLI saved queries. ([835](https://github.com/dbt-labs/metricflow/issues/835))
- Fix query validation for metric_time requirements ([825](https://github.com/dbt-labs/metricflow/issues/825))
- Use FULL OUTER JOIN for dimension-only queries. ([863](https://github.com/dbt-labs/metricflow/issues/863))

Under the Hood

- A simple update to make the where filter query parameter objects more accurate ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Expose underlying where clause error message ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Remove query interface and depend on DSI protocol instead ([None](https://github.com/dbt-labs/metricflow/issues/None))
- re-categorize `TypeErrors` that arise from `create_from_where_filter` into `InvalidQueryException` ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Add the ability to use distinct select in sql nodes ([None](https://github.com/dbt-labs/metricflow/issues/None))
- Removed DatePart Enum and change imports to depend on DSI version instead. ([None](https://github.com/dbt-labs/metricflow/issues/None))

Dependencies

- Update to dbt-semantic-interfaces~=0.3.0. ([809](https://github.com/dbt-labs/metricflow/pull/809))
- Update typing-extensions minimum version to 4.4 ([823](https://github.com/dbt-labs/metricflow/pull/823))
- Update dbt dependencies to ~=1.7.0 ([860](https://github.com/dbt-labs/metricflow/pull/860))

Contributors
- [DevonFulcher](https://github.com/DevonFulcher) (closed issue list unavailable)
- [WilliamDee](https://github.com/WilliamDee) (closed issue list unavailable)
- [courtneyholcomb](https://github.com/courtneyholcomb) ([#842](https://github.com/dbt-labs/metricflow/issues/842), [#770](https://github.com/dbt-labs/metricflow/issues/770), [#804](https://github.com/dbt-labs/metricflow/issues/804), [#759](https://github.com/dbt-labs/metricflow/issues/759), [#850](https://github.com/dbt-labs/metricflow/issues/850), [#801](https://github.com/dbt-labs/metricflow/issues/801), [#802](https://github.com/dbt-labs/metricflow/issues/802), [#835](https://github.com/dbt-labs/metricflow/issues/835), [#863](https://github.com/dbt-labs/metricflow/issues/863))
- [plypaul](https://github.com/plypaul) ([#846](https://github.com/dbt-labs/metricflow/issues/846), [#765](https://github.com/dbt-labs/metricflow/issues/765), [#809](https://github.com/dbt-labs/metricflow/pull/809))
- [tlento](https://github.com/tlento) ([#714](https://github.com/dbt-labs/metricflow/issues/714), [#792](https://github.com/dbt-labs/metricflow/issues/792), [#825](https://github.com/dbt-labs/metricflow/issues/825), [#823](https://github.com/dbt-labs/metricflow/pull/823), [#860](https://github.com/dbt-labs/metricflow/pull/860))

Features

- Adds the option for users to specify group by parameters with object syntax matching the where/filter expressions. ([717](https://github.com/dbt-labs/metricflow/pull/717))
- Expose measures for metrics on MFEngine with agg_time_dimension ([735](https://github.com/dbt-labs/metricflow/issues/735))

Fixes

- Update dataflow plan to support different granularities with time offset metrics ([726](https://github.com/dbt-labs/metricflow/issues/726))
- Removes unneeded JoinOverTimeRangeNode step from dataflow plan. ([743](https://github.com/dbt-labs/metricflow/issues/743))
- Update BigQuery YEAR granularity truncation to use January 1st instead of ISOYEAR start ([755](https://github.com/dbt-labs/metricflow/issues/755))

Dependencies

- Allow tabulate versions >= 0.8.9 ([762](https://github.com/dbt-labs/metricflow/pull/762))

Contributors
- [DevonFulcher](https://github.com/DevonFulcher) ([#717](https://github.com/dbt-labs/metricflow/pull/717))
- [courtneyholcomb](https://github.com/courtneyholcomb) ([#735](https://github.com/dbt-labs/metricflow/issues/735), [#726](https://github.com/dbt-labs/metricflow/issues/726), [#743](https://github.com/dbt-labs/metricflow/issues/743))
- [tlento](https://github.com/tlento) ([#755](https://github.com/dbt-labs/metricflow/issues/755), [#762](https://github.com/dbt-labs/metricflow/pull/762))

Features

- Add dbt-duckdb as a supported adapter and remove legacy DuckDB sql client ([583](https://github.com/dbt-labs/metricflow/issues/583))

Fixes

- Remove barrier to partition pruning certain time partition filter predicates ([712](https://github.com/dbt-labs/metricflow/issues/712))

Under the Hood

- Make duckdb the standard for all dev-env environment runs, including `make test` ([723](https://github.com/dbt-labs/metricflow/issues/723))
- ([728](https://github.com/dbt-labs/metricflow/issues/728))

Dependencies

- Update pandas to 1.5.x ([719](https://github.com/dbt-labs/metricflow/pull/719))
- Relax version pins for MetricFlow dependencies ([720](https://github.com/dbt-labs/metricflow/pull/720))

Contributors
- [courtneyholcomb](https://github.com/courtneyholcomb) ([#728](https://github.com/dbt-labs/metricflow/issues/728))
- [jwills](https://github.com/jwills) ([#583](https://github.com/dbt-labs/metricflow/issues/583))
- [tlento](https://github.com/tlento) ([#712](https://github.com/dbt-labs/metricflow/issues/712), [#723](https://github.com/dbt-labs/metricflow/issues/723), [#719](https://github.com/dbt-labs/metricflow/pull/719), [#720](https://github.com/dbt-labs/metricflow/pull/720))