"One of the most common use cases for developers [will be] to build applications against PostgreSQL and then [move] or copy the data for analytics into either a data platform like Snowflake or increasingly, an open data lakehouse like Iceberg tables on S3 Tables in [AWS] or Microsoft Onelake [in Fabric]... that data now becomes available for analytics."
"pg_lake would allow developers to manage Iceberg tables directly in PostgreSQL by introducing a new Iceberg table type where PostgreSQL acts as the catalog. It would also allow developers to query raw data files in the data lake or external Iceberg tables, Delta tables, and various geospatial file formats from PostgreSQL."
Snowflake released pg_lake, a set of PostgreSQL extensions that enable direct reading and writing of Apache Iceberg tables from PostgreSQL, eliminating the need to extract and move data. Apache Iceberg provides an open table format that allows analytics engines to operate on data in place and is supported by Snowflake, Google, and AWS. The extensions were developed by Crunchy Data and released under the Apache license following Crunchy Data's acquisition. pg_lake introduces an Iceberg table type with PostgreSQL acting as the catalog and enables querying raw data files, external Iceberg and Delta tables, and geospatial file formats from PostgreSQL.
Read at Theregister
Unable to calculate read time
Collection
[
|
...
]