GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
Oracle DATE/BigQuery DATETIME primary key row validations fail
Open
priority: p3
- Dominant language
- Python
- Stars
- 524
- Forks
- 171
- Avg merge
- 5d 15h
- Merged PRs (30d)
- 4
Description
I attempted to validate Oracle DATE vs BigQuery DATETIME and an exception was throw:
```
google.api_core.exceptions.BadRequest: 400 No matching signature for operator IN for argument types DATETIME and {TIMESTAMP} at [4:17]
```
Using date times as key column is not common and therefore this is not (yet) urgent.
I've added a test to the attached branch to illustrate the problem: `test_row_validation_datetime_pk_to_bigquery`
We'll need to also add equivalent test tables to other engines and tests across the board.
Contributor guide
Assessment
This issue has not been assessed yet.