MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

Why Semantic Layers Matter — and How to Build One with DuckDB

2025/08/19 - Simon Späti

Why Semantic Layers Matter — and How to Build One with DuckDB

Learn what a semantic layer is, why it matters, and how to build a simple one with DuckDB and Ibis using just YAML and Python

When Spark Meets DuckLake: Tooling You Know, Simplicity You Need

2025/08/11 - Mehdi Ouazza

When Spark Meets DuckLake: Tooling You Know, Simplicity You Need

Learn how to combine Apache Spark’s scale with DuckLake’s simplicity to build a lakehouse with ACID, time travel, and schema evolution

Subscribe to MotherDuck Blog

Blog subscription card section illustration
Real-Time MySQL to MotherDuck Streaming with Streamkap: A Shift Left Architecture Guide

2025/08/07 - Oli Dinov

Real-Time MySQL to MotherDuck Streaming with Streamkap: A Shift Left Architecture Guide

Build real-time MySQL to MotherDuck pipelines with Streamkap. Learn Shift Left architecture, streaming CDC, and how to replace batch ETL for instant analytics and customer dashboards.

DuckDB Ecosystem: August 2025

2025/08/07 - Simon Späti

DuckDB Ecosystem: August 2025

DuckDB Monthly #32: DuckDB hits 50.7% growth—vector search, WASM, and analytics take the spotlight

Just Enough SQL to be Dangerous with AI

2025/08/04 - Jacob Matson, Alex Monahan

Just Enough SQL to be Dangerous with AI

Learn essential SQL to verify AI-generated queries. Master SELECT, JOIN, and CTEs to safely analyze data with LLMs. Includes DuckDB examples and safety tips

MotherDuck's Latest AI Features: Smarter SQL Error Fixes and Natural Language Editing

2025/07/25 - Hamilton Ulmer, Jacob Matson

MotherDuck's Latest AI Features: Smarter SQL Error Fixes and Natural Language Editing

Stay in flow with MotherDuck's latest features. Real-time SQL feedback and natural language editing.

Summer Data Engineering Roadmap

2025/07/21 - Simon Späti

Summer Data Engineering Roadmap

A comprehensive 3-week structured roadmap for learning data engineering fundamentals, from SQL and Git basics to advanced topics like streaming, data quality, and DevOps.RetryClaude can make mistakes. Please double-check responses.

Small Data SF Returns November 4-5, 2025: First Speakers Announced

2025/07/17 - Ryan Boyd

Small Data SF Returns November 4-5, 2025: First Speakers Announced

Conference with two days of practical innovation on data and AI: workshops and talks from industry leaders, including Benn Stancil, Joe Reis, Adi Polak, George Fraser, Jordan Tigani, Holden Karau, Ravin Kumar, Sam Alexander and more!

Introducing Mega and Giga Ducklings: Scaling Up, Way Up

2025/07/17 - Ryan Boyd

Introducing Mega and Giga Ducklings: Scaling Up, Way Up

New MotherDuck instance sizes allow data warehousing users more flexibility for complex queries and transformations. Need more compute to scale up? Megas and Gigas will help!

Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation

2025/07/15 - Mehdi Ouazza

Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation

Learn how to keep LLMs updated with llms.txt and Cursor's docs feature.

This Month in the DuckDB Ecosystem: July 2025

2025/07/08 - Simon Späti

This Month in the DuckDB Ecosystem: July 2025

DuckDB Monthly #31: Kafka Integration, Browser-Based Analytics, and Lake Format Innovations

The Data Engineer Toolkit: Infrastructure, DevOps, and Beyond

2025/07/03 - Simon Späti

The Data Engineer Toolkit: Infrastructure, DevOps, and Beyond

A comprehensive guide to advanced data engineering tools covering everything from SQL engines and orchestration platforms to DevOps, data quality, AI workflows, and the soft skills needed to build production-grade data platforms.