Oracle Cloud Infrastructure Documentation

Conceptual Diagram of Querying Remote Catalogs

The following diagram displays the conceptual network diagram of querying remote catalogs using Autonomous Database:


Description of simple-sql-syntax.png follows
Description of the illustration simple-sql-syntax.png

Data from all types of external catalog can be queried this way including:

  • Database Links: Data in other databases where a catalog is mounted over a database link.

    These catalogs are built using traditional database links, which are set up in advance by system administrators. The catalog tool autonomous database uses standard SQL queries on these links to discover tables and other objects.

    There are two types of database links: Oracle and Heterogeneous.

    For Oracle links, use queries like SELECT table_name FROM all_tables@link.

    For Heterogeneous links, similar queries are run, such as SELECT table_name FROM all_tables@link.

  • Glue Catalogs: Data made available through AWS Glue, where a catalog is mounted over an AWS Glue region.

  • OCI Data Catalogs: Data made available via OCI Data Catalogs. These catalogs use customer-defined credential objects to securely connect to OCI endpoints protected by ACLs.

  • Delta Share Catalogs: Data that has been shared using the Delta Sharing standard from any system that can use this standard to share data, where a catalog is mounted over the share. These catalogs leverage External Table Delta Sharing support, which employs customer-defined credential objects to access delta sharing endpoints. The credential includes a bearer token for authentication.

  • Iceberg Catalogs: Data made available through an Iceberg Data Catalog, such as Databricks Unity Iceberg Catalog, or Snowflake Polaris.