Open paulskipprhudson opened 2 years ago
Sorry, I've opened this as a bug, but it's a feature request
Hi @paulskipprhudson, Soda SQL will soon be deprecated in favor of Soda Core. It seems to me your issue is actually related to Soda Core rather than to Soda SQL. May I ask you to move it to https://github.com/sodadata/soda-core/issues? Many thanks!
Describe the bug
Applying a filter to a
row_count
check only applies to the metric, not the external column we're evaluating against.I can see why this is expected behaviour, but I would like a way to optionally apply the filter to the comparison aggregation.
To Reproduce
Steps to reproduce the behavior:
scan.yml
Run
soda scan with -V verbose flag
Observe the "otherRowcount" SQL doesn't include the filter and so counts all rows