Blog Posts
Insights and articles about DuckDB, data engineering, serverless and open source.
Filter by tag
Filter by tag:
Use your favorite AI tool to read the latest AWS News
Connect Claude, Claude Code, Cursor, VS Code Copilot or Amazon Q to the unofficial AWS News MCP server, which aggregates 40+ AWS news feeds.
Using Amazon SageMaker Lakehouse with DuckDB
Query S3 Tables through Amazon SageMaker Lakehouse and the AWS Glue Iceberg REST catalog with DuckDB, including IAM role and Lake Formation setup.
Welcome to the age of $10/month Lakehouses
Compare Iceberg, Delta Lake and DuckLake, then deploy a serverless DuckLake lakehouse for about $10 a month on Cloudflare Containers, R2 and Neon Postgres.
Using DuckDB databases as lightweight Data Lake access layer
Share Parquet data in S3 or R2 via a small DuckDB database file of views: a lightweight, low-cost data lake access layer that is queryable with plain SQL.
Handling GTFS data with DuckDB
Load GTFS public transit schedule feeds into a DuckDB database, query stops, routes and trips with SQL, and export the data to Parquet.
Cost-efficient event ingestion into Iceberg S3 Tables on AWS
Compare three serverless architectures for ingesting events into Apache Iceberg S3 Tables via Amazon Data Firehose, then query the data with Athena and DuckDB.
Query S3 Tables with DuckDB
Step-by-step guide to set up an Amazon S3 Table bucket and query its Apache Iceberg tables with DuckDB, including IAM permissions, secrets and catalog attach.
Querying IP addresses and CIDR ranges with DuckDB
Look up whether an IP address belongs to a CIDR range in DuckDB with three reusable SQL macros that compute network and broadcast addresses.
Chat with a Duck
Query your data in plain English: use the DuckDB-NSQL LLM via Ollama to generate DuckDB SQL from natural language prompts in the browser-based SQL Workbench.
Using DuckDB-WASM for in-browser Data Engineering
Analyze, transform and visualize local and remote data in the browser with DuckDB-WASM and SQL Workbench, including a full example data engineering pipeline.