MotherDuck
motherduck.com
MotherDuck
@motherduck.com
Making analytics fun, frictionless and ducking awesome with an unorthodox data warehouse for the post big data era based on @duckdb.org in collab with DuckDB Labs
Pinned
S3 isn’t a database. But what if your lakehouse finally acted like one?

@jrdntgn.bsky.social shares why the current generation of lakehouse formats like Iceberg and Delta Lake might be missing the point—and how DuckLake, a new table format, changes the game.

motherduck.com/blog/ducklak...
A Duck Walks into a Lake - MotherDuck Blog
DuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read
motherduck.com
Reposted by MotherDuck
Fall 2025 Seminar Schedule:
Sep 22: Apache Iceberg
Sep 29: Apache Hudi
Oct 06: @motherduck.com
Oct 13: SpiralDB Vortex
Oct 27: @singlestore.com
Nov 03: @deltalakeoss.bsky.social
Nov 10: Mooncake
Nov 17: @firebolthq.bsky.social
Nov 24: @xtdb.com
Dec 01: Apache Polaris
September 17, 2025 at 11:15 PM
Reposted by MotherDuck
Just use @motherduck.com instead
here are the costs associated with the Oracle database, in case anyone doesn't know. the costs can go up further depending on other options 😅 this is why you need to stick with opensource databases such as pgsql 🥰 the amount of freedom FLOSS brings to individuals & small businesses is unmeasurable
September 12, 2025 at 8:36 PM
Reposted by MotherDuck
I've been leading the data infrastructure efforts at my job (I used to work as a Data Engineer in big tech) and the stack we've landed on is so enjoyable to work with.

@dagster.io - Orchestration
@duckdb.org - Database
@motherduck.com - Data Warehouse/storage
DBT - Data modeling
September 5, 2025 at 3:00 PM
Why use a semantic layer? 🤔

@ssp.sh shows how to build the simplest one with just:
⚡ YAML for metrics
⚡ Python + DuckDB + Ibis to query 20M NYC taxi records

You'll understand when it's useful and when it's overkill

motherduck.com/blog/semanti...
Why Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck Blog
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 | Reading time: 21 min read
motherduck.com
August 19, 2025 at 2:21 PM
The August DuckDB Ecosystem Newsletter is out!

Highlights:
• DuckDB grew 50.7% YoY (1.8M HN headlines analyzed)
• Claude + DuckDB = full Spotify analytics pipeline
• AI that debugs its own SQL
• Real-time news sentiment with DuckDB

motherduck.com/blog/duckdb-...
DuckDB Ecosystem: August 2025 - MotherDuck Blog
DuckDB Monthly #32: DuckDB hits 50.7% growth—vector search, WASM, and analytics take the spotlight | Reading time: 7 min read
motherduck.com
August 7, 2025 at 1:12 PM
🚀 Just published a 3-week data engineering roadmap - perfect for summer learning!
📖 Week 1: SQL, Git & Linux basics
⚙️ Week 2: Python, cloud & data modeling
🔥 Week 3: Streaming, data quality & DevOps
Perfect for beginners or skill refreshers.
Consistency > speed!
👏 Thanks @ssp.sh
July 21, 2025 at 3:33 PM
All roads lead to Rome, but there are 3 ways to get your Postgres analytics queries from painfully slow to lightning fast ⚡

Watch the latest video of @mehdio.com to understand 3 distinct paths to DuckDB integration, each with its own pros/cons👇

youtu.be/86V4wbFtuaY
Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)
YouTube video by MotherDuck
youtu.be
July 18, 2025 at 3:01 PM
Come join us for THE conference of the year!
🎫🦆 Early bird tix are live!
🎤 First round of speakers just dropped!
Join the builders doing more with less →
$295 until Aug 4: smalldatasf.com
Small Data 2025 – The San Francisco Event on Small, Local-First Data
Save the date for Small Data 2025, the event where simplicity meets impact. Join industry leaders in exploring the joys of small, local-first data and the future of efficient computing.
smalldatasf.com
July 17, 2025 at 3:57 PM
🦆 NEW: Mega and Giga ducklings are here!

For when your data is too big, your queries too complex, and "fast enough" isn't fast enough.

Learn More: motherduck.com/blog/announc...
July 16, 2025 at 4:05 PM
Your AI thinks DuckDB is v0.10.2 😱
Current version? 1.3.2

Stop feeding your AI stale docs!
Quick fixes:
1️⃣ llms.txt files - copy fresh docs directly
2️⃣ Cursor's docs feature - auto-crawl documentation

📖 motherduck.com/blog/fix-outdated-llm-documentation-duckdb/
Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation - MotherDuck Blog
Learn how to keep LLMs updated with llms.txt and Cursor's docs feature. | Reading time: 4 min read
motherduck.com
July 15, 2025 at 7:27 PM
🦆 DuckDB Ecosystem Newsletter is live!

🔥 YamlQL, Tributary Kafka extension, SQLRooms browser apps, DuckDB Wizard 🚀 DuckDB 1.3.0 with 100x perf gains, DuckLake, AWS/PostgreSQL integrations

👨‍💻 Community spotlight: Rusty Conover
motherduck.com/blog/duckdb-...
This Month in the DuckDB Ecosystem: July 2025 - MotherDuck Blog
DuckDB Monthly #31: Kafka Integration, Browser-Based Analytics, and Lake Format Innovations | Reading time: 7 min read
motherduck.com
July 8, 2025 at 3:14 PM
The toolkit explosion is real for data engineers.

One day you're optimizing SQL queries, the next debugging Kubernetes, then explaining to stakeholders why their dashboard is empty.

The secret? Infrastructure as Code + DevOps principles.

Read more by @ssp.sh : motherduck.com/blog/data-en...
The Data Engineer Toolkit: Infrastructure, DevOps, and Beyond - MotherDuck Blog
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 pro...
motherduck.com
July 3, 2025 at 12:38 PM
MotherDuck now supports DuckLake! 🦆

New open table format for extreme scale with database-backed metadata.

Two options:
🚀 Fully managed
☁️ Bring your own bucket

Ready to dive in (the lake 🥁)?

CREATE DATABASE (TYPE ducklake);

motherduck.com/blog/announc...
MotherDuck Managed DuckLakes Now in Preview: Scale to Petabytes - MotherDuck Blog
Preview support of MotherDuck includes both fully-managed DuckLake support and ability to bring your own bucket. Combined with MotherDuck's storage, you get both high-speed access to recent data and s...
motherduck.com
July 1, 2025 at 9:39 AM
If you missed the livestream with @jrdntgn.bsky.social and @hannes.muehleisen.org, now it's your time to catch up!
A technical discussion about the evolution of open table formats and lakehouse architecture.

youtu.be/-PYLFx3FRfQ
How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen
YouTube video by MotherDuck
youtu.be
June 23, 2025 at 1:49 PM
Reposted by MotherDuck
Curious to know more about DuckLake? Next Tuesday, DuckDB co-creator @hannes.muehleisen.org will talk with @motherduck.com CEO @jrdntgn.bsky.social about DuckLake and the future of open table formats.

📆 June 17 (Tuesday), 8:00 PDT / 17:00 CEST
✍️ Register at lu.ma/mt9f8xh1?tk=...
DuckLake & The Future of Open Table Formats · Luma
Join MotherDuck CEO Jordan Tigani and DuckDB's Hannes Mühleisen for an in-depth discussion about DuckLake, the new lakehouse format that's rethinking how we…
lu.ma
June 13, 2025 at 1:56 PM
Still using REST or JDBC to serve data? 🐢 You’re slowing things down.

It’s like putting a Ferrari engine in a horse-drawn carriage. 🚗🐎

Arrow Flight SQL streams columnar data at 20+ Gb/s/core.

Serve data as fast as you compute it, by Thomas McGeehan:
motherduck.com/blog/flight-...
Why REST and JDBC Are Killing Your Data Stack — Flight SQL to the Rescue - MotherDuck Blog
Understand how Flight SQL can speed up how your serve data with DuckDB | Reading time: 8 min read
motherduck.com
June 13, 2025 at 1:12 PM
We're thrilled to be part of Redpoint's 2025 InfraRed 100 list, which highlights 100 transformative companies in cloud infrastructure. Proud to be in such outstanding company - congratulations to everyone listed!
June 10, 2025 at 1:58 PM
If you still haven’t gotten your hands dirty with DuckLake, here’s your opportunity!

In this blog, @mehdio.com covers :

🔍 Recap on what table formats are
🧠 Understand why DuckLake's architecture is faster
🛠️ Create your first DuckLake table

motherduck.com/blog/getting...
Getting Started with DuckLake: A New Table Format for Your Lakehouse - MotherDuck Blog
Learn how DuckLake simplifies metadata and brings fast, database-like features to your data lakehouse — with a hands-on example using DuckDB and PostgreSQL | Reading time: 8 min read
motherduck.com
June 9, 2025 at 2:07 PM
Reposted by MotherDuck
If you're wondering what all the fuss is about table formats—and this new one called DuckLake—this video is for you.

If you don’t choose table formats but benchmark them, it’s for you too.

If you don’t like table formats at all?
Well, then share this video with your enemies.
Forget what you know about table formats — DuckLake flips the script.

✅ Metadata in Postgres/DuckDB
✅ Data in Parquet on S3
✅ No more crawling metadata files

@mehdio.com breaks it down with a hands-on @supabase + @duckdb.org setup 🛠️
📺 youtu.be/hrTjvvwhHEQ
Understanding DuckLake: A Table Format with a Modern Architecture
YouTube video by MotherDuck
youtu.be
June 5, 2025 at 2:43 PM
🚀 DuckDB Ecosystem: June 2025 — just out! 🦆

Big news: DuckLake — a new table format powered by pure SQL + open formats.

Also in this issue:
✅ GTFS transit data
✅ MinIO lakehouse
✅ CSV reader win
and much more...

👉 motherduck.com/blog/duckdb-...
DuckDB Ecosystem: June 2025 - MotherDuck Blog
DuckDB Monthly #30: DuckDB's new table format, Radio extension and more! | Reading time: 7 min read
motherduck.com
June 6, 2025 at 6:42 PM
Forget what you know about table formats — DuckLake flips the script.

✅ Metadata in Postgres/DuckDB
✅ Data in Parquet on S3
✅ No more crawling metadata files

@mehdio.com breaks it down with a hands-on @supabase + @duckdb.org setup 🛠️
📺 youtu.be/hrTjvvwhHEQ
Understanding DuckLake: A Table Format with a Modern Architecture
YouTube video by MotherDuck
youtu.be
June 5, 2025 at 1:53 PM
DuckDB 1.3.0 is live in MotherDuck! New SQL syntax, blazing-fast Parquet reads and writes, and even better performance.

Learn more:
motherduck.com/blog/announc...

@duckdb.org
DuckDB 1.3 Lands in MotherDuck: Performance Boosts, Even Faster Parquet, and Smarter SQL - MotherDuck Blog
DuckDB 1.3 has launched, with performance boosts, faster Parquet reads and writes, and new SQL syntax for ducking awesome analytics with full support in MotherDuck. Read on for highlights from this ma...
motherduck.com
June 1, 2025 at 9:59 PM
If you’re using BigQuery and want to level up your local development or supercharge your DuckDB workflows with MotherDuck, it’s never been easier to move data—using just SQL or Python.

motherduck.com/blog/bigquer...
From BigQuery to DuckDB and MotherDuck : Efficient Local and Cloud Data Pipelines - MotherDuck Blog
Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python! | Reading time: 7 min read
motherduck.com
May 30, 2025 at 2:58 PM
Reposted by MotherDuck
One of the notions we think about quite a bit at @motherduck.com is "handling data before it becomes big" and I think this example from @tigrisdata.com really nails it. The trick here is parsing the JSON on insert so its really quick to query it.
May 29, 2025 at 9:27 PM
S3 isn’t a database. But what if your lakehouse finally acted like one?

@jrdntgn.bsky.social shares why the current generation of lakehouse formats like Iceberg and Delta Lake might be missing the point—and how DuckLake, a new table format, changes the game.

motherduck.com/blog/ducklak...
A Duck Walks into a Lake - MotherDuck Blog
DuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read
motherduck.com
May 28, 2025 at 10:52 AM