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 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 SSB schema of an external database.

Parent topic: Query Remote Catalogs and Databases