This is a Postgres Foreign Data Wrapper for Postgres, which you can use to query Apache Iceberg. A FDW allows you to access and query data stored in external data sources as if they were native Postgres tables. It is compatible with the Iceberg REST catalog and S3 Tables (AWS S3's latest offering). Currently it supports SELECT and INSERT operations. You can map an entire Iceberg namespace into your Postgres database like this:
And then query them using a standard SELECT query from your Postgres database:
You can also create tables from within your Postgres database which will then be created inside Iceberg using the `create_table_if_not_exists` option:
The FDW extension used PGRX + the iceberg-rust libraries. The iceberg ecosystem is still very nascent, but we're excited about some architectural patterns it enables. We'll be adding a few resources to the ecosystem, including some libraries that make it easier to use. You can install this FDW on any self-hosted Postgres database and it's available today on the supabase platform. |