Add Catalog
External catalogs let you register external data sources and query them directly from VeloDB Cloud without copying their data into warehouse tables. Once an external catalog is created, you can use standard SQL to browse its databases and tables alongside the data stored in your warehouse.
Note:
The external catalog types in the following table require VeloDB Cloud 4.1.1 or later and are available only for warehouses on AWS.
To create a catalog, open Data Integration and click Add External Catalog on the initial page. If integrations already exist, in the upper-right corner, choose Add Data > Connect external data. Select the source and follow its guide below. View connected catalogs under External Catalogs.
| External catalog | Description |
|---|---|
| AWS Glue | Query Iceberg and Hive tables stored on S3, with metadata managed by AWS Glue. |
| Amazon S3 Tables | Query S3 Tables via the AWS Glue Iceberg REST endpoint. |
| Iceberg REST Catalog | Connect to any catalog service that implements the Iceberg REST specification. |
| Apache Polaris | Query Iceberg tables managed by the Apache Polaris open-source catalog service. |
| Databricks Unity Catalog | Query data lake tables managed by Databricks Unity Catalog. |
| Hive Metastore | Connect to a Hive Metastore and query Hive or Iceberg tables stored on S3. |
| MySQL Catalog | Run federated queries against a MySQL database. |
| PostgreSQL Catalog | Run federated queries against a PostgreSQL database. |
| Sample Data Catalog | Use built-in TPCH and TPCDS sample datasets for testing and benchmarking. |
Sample Data Catalog creates a TPCDS or TPCH catalog that generates benchmark data for queries. To load a built-in sample dataset into warehouse tables instead, use Add Sample Data.