GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Oracle DATE/BigQuery DATETIME primary key row validations fail

Open
#1,153 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.