GoogleCloudPlatform / professional-services-data-validator

Utility to compare data between homogeneous or heterogeneous environments to ensure source and target tables match
Apache License 2.0
399 stars 114 forks source link

Oracle DATE/BigQuery DATETIME primary key row validations fail #1153

Open nj1973 opened 4 months ago

nj1973 commented 4 months ago

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.