exasol / databricks-virtual-schema

Virtual Schema for connecting Databricks as a data source to Exasol
MIT License
0 stars 0 forks source link

Improve mapping of table and column names: map all names to upper case #18

Open kaklakariada opened 3 weeks ago

kaklakariada commented 3 weeks ago

Table names in Databricks are always lower_case while column names can be MIXED_case. The adapter reports these names 1:1 to Exasol. When querying a virtual table, e.g. using select * from vs.table it will fail, because Exasol automatically converts unquoted names to upper case TABLE and the query fails with error object VS.TABLE not found.

To simplify using the VS we should automatically convert table and column names to upper case.