mage-ai
mage-ai copied to clipboard
Oracle data integration pipelines fail when protected names are used
Using quotes should escape protected phrases, but Oracle DI pipelines unexpectedly fail.
https://mageai.slack.com/archives/C05T5RVPP40/p1698346851745829
I have an issue with Oracle Data Integration pipeline. I want to grab data from the "RAW" schema. But afaik RAW is a reserved keyword in oracle, so when I run a query I need to use " for the schema. e.g. select * from "RAW".sometable otherwise if I select * from RAW.sometable I get an error about invalid table name. Can we have a list of reserved keywords that should be quoted? I see debezium and airbyte somehow handling this.