1.3.0 - The Coalesce Release
Breaking Changes
- Updating the package to reflect the changes in the v1.3 metric spec.
type
-->calculation_method
sql
-->expression
type: expression
-->calculation_method: derived
- Updating the
required_dbt_version
to be v1.3 - Removing the dependency on dbt_utils.
New Features
- Adding functionality to return a single value for a metric by using
all_time
in the time_grains by @callum-mcdata in #99 - Adding a new
metric_list
input to secondary calculations to allow for flexibility in which metric the secondary calculation is being applied to. By @callum-mcdata in #116 - Making
develop
have feature parity withcalculate
! You can now query any metrics defined in the provided yml, even if they are derived metrics. By @callum-mcdata in #118 - Allow users to override the default method for handling null values. Default behavior replaces null values with 0 - now there is a config to keep as null. Shout out to @dave-connors-3 taking on a bear of a PR . #96
- Adding the ability to define a
window
in the metric definition and have that be applied in the calculation. More information in the readme. By @callum-mcdata in #104 - Adding a new secondary calculation called
prior
that allows you to display the metric prior metric value from a set interval. By @callum-mcdata in #127
Quality of Life Changes
- The 👑 @dave-connors-3 cleaning up the whitespace in the compiled query so it can actually be read by humans! #94
- Restructuring the metrics in the package for code consistency and to remove branching paths based on different behaviors/inputs. #90
- Adding default ordering to the final returned dataset where the most recent metric value is first! #119
- Updating packages.yml by @callum-mcdata in #122
- Adding changie for our change management by @callum-mcdata in #137
Bug Fixes
- Fixing the calendar table by @callum-mcdata in #98
- Hotfix: All_time with dimensions broken by @callum-mcdata in #108
- Fixing Bug Around Left Outer Join Vs Full Outer Join by @callum-mcdata in https://github.com/dbt-labs/dbt_metrics/pull/133s
- Removing dbt_utils date trunc functionality by @callum-mcdata in #134
- Removing order by for redshift by @callum-mcdata in #136
- Removing L Character in Calculate by @callum-mcdata in #126
- Fixing Rolling Secondary Calc Typo by @callum-mcdata in #141
- Removing
bool_or
from dbt_utils reference by @callum-mcdata in #142
Full Changelog: 0.3.2...1.3.0