GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
Need standard format for INTERVAL columns in row validations
Open
priority: p3
- Dominant language
- Python
- Stars
- 524
- Forks
- 171
- Avg merge
- 5d 15h
- Merged PRs (30d)
- 4
Description
Casting interval columns to string gives differing values based on the SQL engine. For example:
- Oracle: `+02 03:04:55.666`
- PostgreSQL: `2 days 03:04:55.666`
- BigQuery: `0-0 2 3:4:55.666`
There does not appear to be formatting functions like there are for timestamps so we need to think about how to approach this.
Also consider whether the changes for this issue can cater for column min/max validations.
Search for "issue-1214" in our tests to locate our currently disabled tests.
Contributor guide
Assessment
This issue has not been assessed yet.