Description

Using External Catalog, users can perform federated queries across different data sources as if they were data within the same database. It is also possible to perform associative queries between external data sources and tables in the Lakehouse.

Syntax

SELECT <expr> FROM external_catalog_name.schema_name.table_name;

Parameter Description

• <expr>: The field or expression the user wishes to query.
• external_catalog_name: The name of the external catalog.
• schema_name: The schema name, used to organize database objects.
• table_name: The name of the table, the dataset the user wishes to query. Notes Querying tables under the external catalog must use three-tier structure syntax

Example

SELECT * FROM my_external_catalog.my_schema.my_table;