GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator

Oracle lower/mixed case table names are not supported

Open
#1,733 0 comments 0 reactions 0 assignees View on GitHub
type: feature request
Dominant language
Python
Stars
524
Forks
171
Avg merge
5d 15h
Merged PRs (30d)
4

Description

**Is your feature request related to a problem? Please describe.**
Oracle lower/mixed case table names are not supported.

We've added test tables to demonstrate this.

- pso_data_validator."DvtCaseCamel"
- pso_data_validator."dvt_case_lower"

CamelCase appears to mostly work but fails in our custom raw metadata processing which is upper casing the name:

```
source = f'"{database}"."{table}"'.upper()
```

Lower casing is failing in Ibis code, root cause unknown.

Workarounds proposed to the customer:

1. Create a view that converts problem identifiers to upper case.
2. Use a custom query validation.

Because there are viable workarounds we might choose to not prioritise this feature request. We should certainly wait until after the upcoming Ibis upgrade to even think about this.

Search for tests skipped due to issue-1733 to reproduce these problems.

**What version of DVT are you using?**
8.x

**What type of connections are you using for source and target?**
Oracle

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.