Hi all! I'm just getting started with Meltano and am trying to get the transferwise Oracle tap working. I'm running into the below error. I removed the actual schema name and replaced it with SCHEMANAME for posting in the Slack channel. The issue appears to be that the syntax for the query is wrong. If I copy/paste it and try to run it in Oracle I get an error. It looks like the (:0) and brackets should not be there. If I change the where clause to WHERE owner != 'SYS' AND owner IN ('SCHEMANAME') it works and returns the expected results. This is the query generated by the tap, so I'm confused as to why it would be generating invalid syntax. I have the schema defined in the FILTER_SCHEMAS setting in the yml file. Wondering if anyone has encountered this error before or has ideas on how to resolve it? Thanks in advance! INFO fetching row counts INFO fetching tables: SELECT owner, table_name FROM all_tables WHERE owner != 'SYS' AND owner IN (:0) ['SCHEMANAME'] INFO fetching views INFO fetching column info INFO fetching pk constraints CRITICAL ORA-00942: table or view does not exist

Seems like you might have the same issue as mentioned in https://github.com/transferwise/pipelinewise-tap-oracle/issues/8

Thanks for the tip! I'll follow up with the Oracle DBA and see if he can grant that additional access.

I was like hmm I've seen this before, ahh it's my issue haha 🙂

Was able to get the access and got past the Oracle issue. Now running into something weird Snowflake side to figure out, but I at least got past the initial Oracle issue. Thanks again for the help!