Choosing the right table architecture lets you optimize performance, reduce
costs, and maintain data access across your analytics tools.
Borderless Lakehouse offers multiple table types and serving endpoints
so you can select the option that fits your write engines, read requirements,
and management control needs.

> [!TIP]
> **Tip:** For most open lakehouse workloads, use Apache Iceberg tables managed by the *Lakehouse runtime catalog* and served through the Apache Iceberg REST catalog endpoint. This configuration provides broad read and write interoperability between open source engines and BigQuery.

## Table formats by catalog or engine

Select a catalog or engine to learn about its supported table formats, metastore
configuration, storage optimization capabilities, and engine interoperability.

### Lakehouse runtime catalog

The Lakehouse runtime catalog manages Apache Iceberg tables
through the Apache Iceberg REST catalog endpoint and provides seamless
read-write interoperability across Iceberg-compatible engines
(Apache Spark, Apache Flink, and Trino) and
BigQuery, while being backed by the industry-standard
[Iceberg REST catalog
interface](https://iceberg.apache.org/rest-catalog-spec/).

**Supported table formats**

Apache Iceberg V2 tables (GA) and V3 tables (Preview) are supported. Iceberg
V1 tables aren't supported. Before you use existing V1 tables with
Lakehouse, you must upgrade them to a supported version. For more
information, see [Upgrade Iceberg V1 tables to
V2](https://docs.cloud.google.com/lakehouse/docs/update-tables).

Key features include:

- **Metastore**: Lakehouse runtime catalog.
- **Storage**: Cloud Storage.
- **Storage optimization** : Managed by you, a third party, or ([Google-managed](https://docs.cloud.google.com/lakehouse/docs/table-options.md.txt#choose-table-management), Preview).
- **Read and write access** :
  - Open source engines: read and write (GA)
  - BigQuery: read/write (Preview)
- **Use cases**: Open lakehouse with high-performance, enterprise-grade storage for advanced analytics, streaming, and AI.

### Hive metastore

The *Lakehouse runtime catalog* manages Apache Hive
tables through an Apache Hive metastore (HMS) endpoint optimized
for Spark `ExternalCatalog` compatibility, letting you
seamlessly share data across Spark,
Apache Hive, and BigQuery. You create these tables
from open source engines and store them in Cloud Storage. This
option works well if you want your ETL workflow to be managed by open source
engines without needing a separate self-hosted Hive metastore, and only
require read access from BigQuery.

Tables managed by the Hive metastore endpoint are standard
Apache Hive and Spark tables (using Hive
SerDes or Spark data sources), not Apache Iceberg
tables. To create and manage Apache Iceberg tables in the
Lakehouse runtime catalog, use the Apache Iceberg REST
catalog endpoint instead.

Key features include:

- **Metastore** : Lakehouse runtime catalog (through custom `IMetastoreClient`).
- **Storage**: Cloud Storage (supporting formats like Parquet, ORC, and Avro).
- **Storage optimization**: Managed by you or a third party.
- **Read and write access** :
  - Open source engines (Spark and Apache Hive): Read and write.
  - BigQuery: read-only.
- **Use cases**: Migrating existing Spark and Apache Hive workloads to a fully managed, serverless metastore on Google Cloud.

## Table formats by product

Use the following chart to compare table types in the
Lakehouse runtime catalog.

### Lakehouse

|   | **Apache Iceberg (GA)** | **Cross-cloud data access (GA)** | **Apache Hive (GA)** |
|---|---|---|---|
| **Metastore** | Lakehouse runtime catalog | Lakehouse runtime catalog | Lakehouse runtime catalog |
| **Storage** | Cloud Storage | Cloud Storage / Amazon S3 | Cloud Storage |
| **Storage optimization** | Customer-managed, third-party-managed, or [Google-managed](https://docs.cloud.google.com/lakehouse/docs/table-options.md.txt#choose-table-management) (Preview) | Customer-managed or third-party-managed | Customer-managed or third-party-managed |
| **Read/write** | Open source engines (read/write) BigQuery (read/write \[Preview\]) | Open source engines (read) BigQuery (read) | Open source engines (read/write) BigQuery (read-only) |
| **Advanced operations** | None | None | None |
| **Access control** | [Table-level security with IAM](https://docs.cloud.google.com/lakehouse/docs/iam-and-access-control.md.txt) | [Table-level security with IAM](https://docs.cloud.google.com/lakehouse/docs/iam-and-access-control.md.txt) | [Table-level security with IAM](https://docs.cloud.google.com/lakehouse/docs/iam-and-access-control.md.txt) |
| **Use cases** | Open lakehouse | Query data in other cloud providers without migrating files or building complex ETL pipelines | Migrate existing Spark and Apache Hive workloads to a fully managed, serverless metastore |

## Iceberg table capabilities

Use the following table to learn more about capabilities offered in Apache
Iceberg tables in the Lakehouse runtime catalog.

To compare capabilities between Apache Iceberg tables managed by the
Lakehouse runtime catalog and Apache Iceberg tables managed by
BigQuery, see [Iceberg table capabilities
comparison](https://docs.cloud.google.com/bigquery/docs/lakehouse-in-bigquery#iceberg_table_capabilities_comparison).

| Capability | Support |
|---|---|
| **Catalog** | Lakehouse runtime catalog (Iceberg REST catalog compatible) |
| **Storage** | Cloud Storage |
| **Accessible through the Iceberg REST catalog endpoint** | Yes |
| **Read/write interoperability** ||
| BigQuery read queries (`SELECT`, BigQuery ML, AI functions) | Supported (GA) |
| BigQuery DML (`INSERT`, `UPDATE`, `DELETE`, `MERGE`) | Supported (Preview) |
| OSS engine reads | Supported (GA) |
| OSS engine writes | Supported (GA) |
| OSS engine streaming writes (Kafka, Spark, Dataflow with Iceberg I/O sink) | Supported (GA) |
| **Managed and advanced capabilities** ||
| [Table management](https://docs.cloud.google.com/lakehouse/docs/table-options.md.txt#enable-table-management) (compaction, garbage collection) | Supported (Preview) |
| BigQuery Change Data Capture (CDC) | Supported (Preview) |
| **Time travel** ||
| Time travel (using OSS engines) | Flexible (configured through table properties) |
| Time travel (using BigQuery) | Limited to 7 days |
| Snapshot history and rollback to previous snapshot | Supported (GA) |
| **Knowledge Catalog capabilities** ||
| Metadata cataloging, search, and discovery | Supported (GA) |
| Lineage | Supported (GA) |
| Data quality/profiling | Supported (GA) |
| Insights | Supported (GA) |
| AI-based column and table description generation | Supported (GA) |

## What's next

- Learn how to [manage Apache Iceberg tables](https://docs.cloud.google.com/lakehouse/docs/manage-tables.md.txt).

- Learn how to [import external Iceberg tables using
  Dataflow](https://docs.cloud.google.com/lakehouse/docs/import-iceberg-tables).