Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 312 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Support view type objects in Autonomous Database based external catalogs
When creating an external catalog connected to an Autonomous Database all tables type objects are presented in the catalogue, but I do not see view type objects.
Although writes can't be supported, having the ability to leverage reads of views in the external catalogue format would be extremely helpful. As a workaround we are leveraging the oracledb python package to query views rather than the AIDP catalog APIs - however would be a lot cleaner being able to query through the catalogue directly.
This is especially important for databases that utilize views as a security layer, preventing certain schemas from being able to read underlying tables, meaning the views are your only option to read the underlying data depending on your schema access.