Examples: List the Mounted Catalogs

You will use this syntax in a SQL query.

For example, to list the catalogs you mount, you could run the following command:

SELECT CATALOG_NAME,CATALOG_TYPE,IS_ENABLED FROM USER_MOUNTED_CATALOGS;

The output of the query lists the catalogs that you connect with.

After the connection, you can query the catalogs using the syntax mentioned above:

SELECT * FROM "DEFAULT"."BOSTON-HOUSING"@CATALOGNAME;

In the above example, Catalogname is a catalog you have mounted, and BOSTON-HOUSING is a table in that catalog.

Parent topic: Query Remote Catalogs and Databases