Examples: Query Data from a Table in a Catalog
To query data from a table in a specific catalog (schema), you must prepend the schema name to the table name.
For example, querying data from the SALES table in the SH schema:
SELECT * FROM "SH"."SALES"@catalogname; Note
In this example, you are querying data in the
In this example, you are querying data in the
SH schema of an external database.
If you are working with other schemas like
SSB, you can similarly query their tables by specifying the schema name:SELECT * FROM "SSB"."SALES"@catalogname; Note
In this example, you are querying data in the
In this example, you are querying data in the
SSB schema of an external database.
Parent topic: Query Remote Catalogs and Databases