Add a way to integrate dimension to: expect_column_values_to_be_within_n_moving_stdevs

calogica / dbt-expectations

Port(ish) of Great Expectations to dbt test macros

https://calogica.github.io/dbt-expectations/

Apache License 2.0

1.06k stars 130 forks source link

Add a way to integrate dimension to: expect_column_values_to_be_within_n_moving_stdevs #166

Closed jordanjbanal closed 2 years ago

jordanjbanal commented 2 years ago

Hi ! I am trying to monitor KPI metrics values per game with expect_column_values_to_be_within_n_moving_stdevs. However, I am only able to monitor the variations for the entire columns containing data for all the games. Adding the ability of partitioning the values per game with a PARTITION_BYclause would be very helpful.

clausherther commented 2 years ago

Hi @jordanjbanal! Thanks for opening this issue. This seems like a reasonable enhancement. Would you be interested in contributing a PR for this? It's probably something I can get to in the next couple of weeks, but if you wanted to give it a shot in the meantime, happy to help!