Data lake tables and Iceberg tables
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_lake |
|---|---|
| Version | 3.5 |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | Preloaded |
| Project status | Active |
| Vendor | Snowflake |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | pg_extension_base |
| Schema | __pg_lake_table_writes, lake_file, lake_file_cache, lake_table, pg_catalog |
| Stars | 1,630 |
| Latest commit | 2026-08-28 |
| Latest release | 2026-07-28 |
| Catalogue updated | 2026-09-20 |
| btree_gist | support for indexing common datatypes in GiST |
| pg_lake_engine | Query engine for data lake queries |
| pg_lake_iceberg | Iceberg implementation in Postgres |
| pg_lake | Data lake extension by Snowflake |
| pg_lake_copy | Copy to/from data lake files |
| pg_ducklake | DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet |
| pg_mooncake | Columnstore Table in Postgres |
| columnar | Hydra Columnar extension |
| pg_parquet | copy data between Postgres and Parquet |
| storage_engine | colcompress and rowcompress Table Access Methods with vectorized execution |
| orioledb | OrioleDB, the next generation transactional engine |
| pg_sorted_heap | Sorted heap table AM with zone map scan pruning and built-in vector search |
| aws_s3 | aws_s3 postgres extension to import/export data from/to s3 |
| pg_bulkload | pg_bulkload is a high speed data loading utility for PostgreSQL |
| file_fdw | foreign-data wrapper for flat file access |
| pg_lake | Data lake extension by Snowflake |
| pg_extension_base | Extension development kit by Snowflake |
| pg_extension_updater | Automatic extension updater |
| pg_map | Map type for PostgreSQL, bundled as a required pg_lake component. |
| pg_lake_engine | Query engine for data lake queries |
| pg_lake_iceberg | Iceberg implementation in Postgres |
| pg_lake_copy | Copy to/from data lake files |
| pg_lake_benchmark | Provides ClickBench, TPC-H and TPC-DS data generation and benchmark queries for pg_lake, Iceberg and heap tables. |
| pg_lake_spatial | Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. |