All posts
Data Platform

Aurora PostgreSQL Now Queries Iceberg and Parquet Directly, With DuckDB Inside: When It Replaces a Pipeline

By

October 25, 2026

6 min read

Since September 30, 2026, Aurora PostgreSQL 17 and 18 can query Apache Iceberg and Parquet in S3, S3 Tables and Glue-catalogued lakes in the same SQL as live operational data, using an embedded DuckDB engine. No extra charge. What it is good for, its limits, and when you still want Redshift or Athena.

Aurora PostgreSQL
Apache Iceberg
Parquet
DuckDB
S3 Tables
Data Lake

The usual pattern for joining application data with lake data is a pipeline: copy one into the other, keep it fresh, pay for both copies. Aurora PostgreSQL removes that pipeline for many cases. Enable the aurora_analytics extension, attach an IAM role, define foreign tables over Iceberg or Parquet data, and query them alongside your tables. DuckDB, embedded in Aurora, does the analytical scanning.

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

What it supports

  • Iceberg tables in the Glue Data Catalog, Parquet and Iceberg data in S3 and S3 Tables, and external Iceberg REST catalogs through Glue federation, several in one join.

  • Schemas inferred from file metadata, predicate pushdown and column pruning, and a cache for frequently read data.

  • Read replicas can run the analytical queries; CREATE TABLE AS SELECT on the writer materializes hot data into Aurora for millisecond reads.

  • Aurora PostgreSQL 17.11 and later, and 18.6 and later, in all commercial Regions and GovCloud (US).

  • No feature charge: you pay for the Aurora compute the queries use and S3 requests.

Where it fits, and where it does not

Good fit

Still use a warehouse or Athena

An app screen that combines live records with history in the lake

Heavy analytical workloads that would compete with transactions for Aurora CPU

Occasional reporting joins without building a pipeline

Many analysts running ad hoc scans over terabytes

Reading reference data that lives in the lake

Writing to the lake: external data is read-only

Prototyping a data product before deciding on a warehouse

Workloads that need a warehouse's concurrency scaling and workload management

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.