Catalog Connection

Catalog Connection is used to connect to external metadata stores (such as Hive Metastore), allowing Lakehouse to directly read data from external systems through federated queries without needing to migrate data in.

Use Cases

When your data resides in a Hive data lake and you want to query it directly in Lakehouse without copying data, establish a connection via Catalog Connection, then create an External Catalog.

Lakehouse SQL Query
  └── External Catalog
        └── Catalog Connection (stores Hive Metastore connection info)
              └── Hive Metastore → Data lake files

Create Example

CREATE CATALOG CONNECTION my_hive_conn
  TYPE HIVE
  METASTORE_URI = 'thrift://hive-metastore-host:9083';

Comparison with Other Connections

Related Documents

• CREATE CATALOG CONNECTION — full syntax
• External Catalog Federated Queries
• Connection Overview