select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Analytics

pg_lake

Data lake extension by Snowflake

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_lake
Version3.5
PostgreSQL versions16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Project statusActive
VendorSnowflake
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_extension_base
Schemalake, pg_catalog
Stars1,630
Latest commit2026-08-28
Latest release2026-07-28
Catalogue updated2026-09-20

Related extensions

Requires

pg_lake_copyCopy to/from data lake files
pg_lake_tableData lake tables and Iceberg tables

Required by

pg_lake_benchmarkProvides ClickBench, TPC-H and TPC-DS data generation and benchmark queries for pg_lake, Iceberg and heap tables.
pg_lake_spatialAdds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows.

See also

pg_ducklakeDuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet
pg_duckdbDuckDB Embedded in Postgres
pg_parquetcopy data between Postgres and Parquet
pg_mooncakeColumnstore Table in Postgres
duckdb_fdwDuckDB Foreign Data Wrapper
aws_s3aws_s3 postgres extension to import/export data from/to s3
file_fdwforeign-data wrapper for flat file access
pg_bulkloadpg_bulkload is a high speed data loading utility for PostgreSQL
pg_clickhouseInterfaces to query ClickHouse databases from PostgreSQL
columnarHydra Columnar extension

Same project

pg_extension_baseExtension development kit by Snowflake
pg_extension_updaterAutomatic extension updater
pg_mapMap type for PostgreSQL, bundled as a required pg_lake component.
pg_lake_engineQuery engine for data lake queries
pg_lake_icebergIceberg implementation in Postgres
pg_lake_tableData lake tables and Iceberg tables
pg_lake_copyCopy to/from data lake files
pg_lake_benchmarkProvides ClickBench, TPC-H and TPC-DS data generation and benchmark queries for pg_lake, Iceberg and heap tables.
pg_lake_spatialAdds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows.