Amazon Aurora PostgreSQL embeds DuckDB to query Parquet and Iceberg in S3

AWS announced that Amazon Aurora PostgreSQL can now query Parquet and Iceberg data in S3 using embedded DuckDB via the aurora_analytics extension. It requires PostgreSQL 17.11+ or 18.6+ and an IAM role with the AuroraAnalytics feature.

• The aurora_analytics extension embeds DuckDB in Aurora PostgreSQL
• Parquet and Iceberg queries in S3 run through foreign tables
• Requires PostgreSQL 17.11+ or 18.6+ and an AuroraAnalytics IAM role
• Query plans show DuckDB operators like READ_PARQUET and PERFECT_HASH_GROUP_BY