GoogleCloudPlatform / GoogleCloudPlatform/professional-services-data-validator
Oracle lower/mixed case table names are not supported
- 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
Assessment
This issue has not been assessed yet.