Oracle AI Data Platform Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Support view type objects in Autonomous Database based external catalogs

Needs Votes
21
Views
0
Comments
DMD
DMD Rank 4 - Community Specialist

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.

1
1 votes

Needs Votes · Last Updated