User guide

How to work with Iceberg tables and data lake files from PostgreSQL.

Page	What it covers
Iceberg tables	Creating and loading Iceberg tables, and when to use them.
Partitioning	Hidden partitioning, transforms, pruning and partitioned writes.
Modifying tables	UPDATE, DELETE, schema changes and table options.
Catalogs and interoperability	The PostgreSQL catalog, REST catalogs, Spark, Python and Snowflake.
Maintenance	VACUUM, autovacuum, snapshots, metadata functions and recovery.
Query data lake files	Querying files in place, wildcards, hive partitions and writable tables.
Import and export	COPY and load_from for loading and exporting files, and deleting files.
Geospatial	GeoParquet, GDAL formats, geometry in Iceberg and spatial pushdown.
Performance	Query pushdown, file pruning, the file cache and faster writes.
dbt	Building Iceberg and PostgreSQL tables with dbt.