Amazon Web Services integrates DuckDB into Amazon Aurora

Amazon Web Services (AWS) has announced the general availability of direct data lake querying within Amazon Aurora PostgreSQL. By embedding DuckDB’s vectorized query engine directly into the Aurora kernel, AWS enables users to execute unified SQL queries across relational tables and external lakehouse files, such as Apache Iceberg and Parquet data, stored in Amazon S3.

This integration, available for Aurora PostgreSQL versions 17 and 18, allows transactional applications to query historical data alongside live relational rows without the need for separate data movement or reverse-ETL pipelines. The capability supports automatic schema inference via the AWS Glue Data Catalog and federated Iceberg REST Catalogs. The feature is available across all commercial AWS Regions and AWS GovCloud (US) Regions.