Hi, I'm just trying out meltano to see if I can ge...
# getting-started
r
Hi, I'm just trying out meltano to see if I can get tap-oracle log_based extraction to work. I have a weird issue, when querying the oracle (12c) database, it seems I need to specify the schema in quotes, as such:
SELECT * FROM "RAW".SOMETABLE
as using
SELECT * FROM RAW.SOMETABLE
says Invalid table name. In terms of meltano: I've setup the tap-oracle extractor and target-azureblobstorage - it all seems fine, until the tap starts grabbing some data from the database, I'm getting cx_Oracle.DatabaseError: ORA-00903: invalid table name I've checked the debug logs and can see it's obviously not including the quotes - any simple way to make the tap include quotes when qurying the schema? note: I don't have power to make changes to the database itself.