GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
Column validation: Implement support for INTERVAL columns
- Dominant language
- Python
- Stars
- 524
- Forks
- 171
- Avg merge
- 5d 15h
- Merged PRs (30d)
- 4
Description
Column validations of Interval columns are skipped:
```
07/21/2025 03:26:13 PM-INFO: Skipping sum on col_interval_ds due to data type: interval
07/21/2025 03:26:13 PM-INFO: Skipping sum on col_interval_ym due to data type: interval
07/21/2025 03:26:13 PM-INFO: Skipping min on col_interval_ds due to data type: interval
07/21/2025 03:26:13 PM-INFO: Skipping min on col_interval_ym due to data type: interval
```
For this issue we need to look into which aggregations we can support and what they should look like.
Tests `test_column_validation_intervals` should test supported agg types as they are implemented.
See https://github.com/GoogleCloudPlatform/professional-services-data-validator/issues/1214 for the Row validation counterpart to this issue.
Contributor guide
Assessment
This issue has not been assessed yet.