Hello everyone.
I am connected to an Oracle server. I can see some schemas and able to pull data. However, there are a lot of schemas that are missing. I can see and query all schemas in sql developer using the exact same credentials and settings (port, host name, etc).
I've tried re-installing Alteryx and the oracle instant client driver but to no avail. I've also tried creating several connections and still seeing the same incomplete schemas.
Has anyone encountered this issue? Fixes?
Thanks in advance!
Solved! Go to Solution.
Alright, this has been resolved. Privilege issues with synonyms and physical tables in the schema.