Snowflake-Labs/pg_lake v3.3.0

v3.3.0

Repository: Snowflake-Labs/pg_lake

Tag: v3.3.0

Published: 2026-04-13T18:24:10Z

Prerelease: no

Release notes:

What's Changed

• Move CachedExtensionIds and SPI helpers to pg_extension_base by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/164
• Fix logical replication error when dropping Iceberg tables by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/171
• Expose null_padding option for CSV by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/155
• Fix substring_pg crash on macOS due to long vs int64_t type mismatch by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/177
• Remove max CSV line size limitation by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/174
• Add missing catalog to the object store catalog by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/178
• Support additional Iceberg REST API authentication method by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/176
• Introduce OidListToArray by @sfc-gh-agedemenli in https://github.com/Snowflake-Labs/pg_lake/pull/181
• Add GUC to disable vended credentials header for REST catalog by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/184
• Allow long-form Azure URLs by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/187
• Make TupleDescToDuckDBColumnsMap so that other extensions can use by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/192
• Make FindUnreferencedFilesAmongHTABs function public by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/193
• Use the specified VCPKG_VERSION 2025.10.17; change jdk21 to 21.0.10 by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/189
• Make TupleDescToColumnMapForWrite public by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/199
• Provide more common code fore ReadCSV by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/200
• Parallelize upload of metadata files during commit by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/197
• Use pyspark conditionally in the tests by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/202
• Re-enable PG18 tests in test_base_worker_launcher.py by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/204
• Add pg_lake upgrade path from 2.4-1; incorporate same fixes here by @sfc-gh-dachristensen in https://github.com/Snowflake-Labs/pg_lake/pull/196
• Update installation and test docs by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/207
• Cache in-progress table visibility to avoid SPI per file write by @sfc-gh-okalaci in https://github.com/Snowflake-Labs/pg_lake/pull/210
• Add function to run attached worker with query results by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/213
• Allow Iceberg table creation in extensions by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/216
• Add test coverage for REPEATABLE READ and SERIALIZABLE isolation levels by @tanvinkalra in https://github.com/Snowflake-Labs/pg_lake/pull/201
• Make sure to create data file temp table with extension user privilege by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/219
• Pushdown initcap function by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/208
• Fix test teardown hangs by adding timeouts to process and thread cleanup by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/224
• Fix compiler warnings by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/228
• Put sample data under parent folder by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/231
• Reorganize test_common helpers by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/232
• pgduck_server handles sigint/sigterm gracefully by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/229
• Fixes pushdown with constant in grouping by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/238
• Support Postgres interval types as structs in Iceberg by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/220
• Fix flaky test_set_operation_pushdown by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/243
• Fix insert..select and copy from pushdown for nested types by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/241
• Support timetz in iceberg tables by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/239
• Fix BC date/timestamp via PGDuckSerialize + ISO write to Iceberg by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/249
• Unbounded numeric stays as numeric in PG schema, still writes as DECIMAL(38,9) to Iceberg by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/252
• Support unsupported numeric as double by default in Iceberg tables by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/257
• Expand permissions for iceberg tables, filter REST iceberg tables by @sfc-gh-dachristensen in https://github.com/Snowflake-Labs/pg_lake/pull/259
• Clamp numeric NaN as NULL at postgres_scanner by @sfc-gh-abozkurt in https://github.com/Snowflake-Labs/pg_lake/pull/258
• Use index scan in CheckObjectCreatedByLakeInternal by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/261
• Fix crash in hide_lake_objects for MERGE on catalog tables by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/265
• Remove pre-PG16 compat code and bump min version checks by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/266
• Add @STAGE shorthand for common staging bucket by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/245
• Add per-table max_snapshot_age option for Iceberg tables by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/244
• Add automated installation script and improve documentation by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/225
• Add the option of restart base workers after N milliseconds by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/205
• Fix CTAS in SPI assert failure (on top of 254) by @sfc-gh-mslot in https://github.com/Snowflake-Labs/pg_lake/pull/260
• Use heavy asserts in CI; fix heavy assert for NaN/Inf float column bounds by @sfc-gh-npuka in https://github.com/Snowflake-Labs/pg_lake/pull/262
• Switch to upstream DuckDB Azure…