Last updated:|... min read
Compatibility with Query Engines
You can query OLake Iceberg tables from multiple engines. The table below shows catalog compatibility at a glance, with links to setup guides.
| Query Tool | AWS Glue | Hive Metastore | JDBC | REST | Docs |
|---|---|---|---|---|---|
| Amazon Athena | ✅ | ❌ | ❌ | ❌ | AWS Docs |
| Apache Spark (v3.3+) | ✅ | ✅ | ✅ | ✅ | Spark Docs |
| Apache Flink (v1.18+) | ✅ | ✅ | ✅ | ✅ | Flink Docs |
| Trino (v475 +) | ✅ | ✅ | ✅ | ✅ | Trino Docs |
| Starburst Enterprise | ✅ | ✅ | ✅ | ✅ | Starburst Docs |
| Presto (v0.288 +) | ✅ | ✅ | ✅ | ✅ | Presto Guide |
| Apache Hive (v4.0) | ✅ | ✅ | ❌ | ✅ | Hive Docs |
| Apache Impala (v4.4) | ❌ | ✅ | ❌ | ❌ | Impala Docs |
| Dremio (v25/26) | ✅ | ✅ | ❌ | ✅ | Dremio Docs |
| DuckDB (v1.2.1) | ❌ | ❌ | ❌ | ✅ | DuckDB Docs |
| ClickHouse (v24.3 +) | ❌ | ❌ | ❌ | ✅ | ClickHouse Docs |
| StarRocks (v3.2 +) | ❌ | ✅ | ❌ | ✅ | StarRocks Docs |
| Apache Doris (v2.1 +) | ✅ | ✅ | ❌ | ✅ | Doris Docs |
| BigQuery (BigLake) | ❌ | ❌ | ❌ | ❌ | BigQuery Docs |
| Snowflake (GA) | ❌ | ❌ | ❌ | ✅ | Snowflake Docs |
| Databricks (Unity) | ❌ | ❌ | ❌ | ✅ | Databricks Docs |
Important Notes
- Amazon Athena → Supports Iceberg v2 tables only when registered in Glue.
- Presto → REST catalog supported from v0.288+; Glue requires the AWS SDK fat-jar.
- Apache Hive v4.0 → Glue requires adding the AWS bundle.
- Impala → Works with Hive Metastore; Glue/REST only via Hive federation.
- Dremio → Supports Polaris/REST/Nessie natively; JDBC not supported.
- DuckDB → Supports REST catalogs (Nessie, Tabular); Glue/Hive not yet supported.
- ClickHouse → Iceberg tables are read-only; REST support stable from v24.12+.
- BigQuery → Reads Iceberg manifests directly, without a catalog.
- Snowflake → Can read external REST catalogs, but they are read-only.
- Databricks Unity Catalog → REST endpoint allows federation with Glue, Hive, and Snowflake catalogs.