Home icon

Streamlining access to tabular datasets stored in Amazon S3 Tables with DuckDB

Storage Blog



This article details how to use DuckDB to read and query Iceberg tables stored in Amazon S3 Tables, offering a lightweight and efficient solution for data analysis.

  • DuckDB provides an embedded, serverless approach to querying data without complex installations
  • Supports reading tables stored in Amazon S3 using Apache Iceberg REST APIs
  • Demonstrates how to set up S3 Tables, configure permissions, and install DuckDB
  • Allows querying data directly from S3 without complex data movements
  • Provides a step-by-step guide to create a table, insert data, and run sample queries

The solution simplifies data lake interactions by enabling direct, performant querying of tabular datasets stored in Amazon S3, making it easier for developers and data scientists to analyze data.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Oct 6
2026
Cost-effective ETL with DuckDB and Amazon S3 Tables on AWS Glue
Mar 13
2025
Amazon S3 Tables add create and query table support in the S3 console
Mar 24
2025
Using Amazon S3 Tables with Amazon Redshift to query Apache Iceberg tables
May 29
2025
How to consume tabular data from Amazon S3 Tables for insights and business reporting

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.