Bytetalks ep6: Bytewax DuckDB/MotherDuck connector

By Zander Matheson & Laura Funderburk

Welcome to another exciting episode of Bytetalks! 🐝 This time, we’re joined by the incredible Jacob Matson, Developer Advocate at MotherDuck, to explore the evolving landscape of real-time data processing and high-performance analytics.

Together with Bytewax’s Zander and Laura, Jacob discusses DuckDB and MotherDuck's capabilities, their innovative use cases, and how the new Bytewax DuckDB/MotherDuck connector unlocks possibilities for streamlined data workflows.

What to Expect:

☑️ DuckDB Basics: Why is DuckDB considered a lightweight powerhouse for in-process analytics? ☑️ MotherDuck’s Edge: How does MotherDuck build on DuckDB to provide cloud scalability and collaboration without losing speed? ☑️ Bytewax Integration: A live demo showcasing:

  • Batch and real-time processing with Bytewax.
  • Writing tables to DuckDB locally and MotherDuck in the cloud.
  • Combining Python and SQL for seamless data workflows. ☑️ Streaming Meets Analytics: A candid conversation about where streaming fits into modern data pipelines, and the trade-offs between batch and streaming workflows.

Key Quotes:

📌 “Streaming and batch processing aren’t competitors—they’re complementary tools. Knowing when to use each is where the magic happens.” – Jacob Matson

📌 “The fastest way to innovate in data engineering is to stop reinventing the wheel and use modular tools that just work.” – Zander Matheson📌

Questions Discussed:

  • How do lightweight tools like DuckDB challenge the traditional data warehouse paradigm?
  • What’s the future of hybrid workflows that blend local and cloud-based analytics?
  • How do you balance performance and simplicity in real-time systems?

🧐 Resources and Links:

MotherDuck: https://motherduck.com

DuckDB: https://duckdb.org

GitHub Module: https://github.com/bytewax/bytewax

MotherDuck Token Setup: https://motherduck.com/docs

Blog: https://bytewax.io/blog/bytewax-duckdb-motherduck-integration

What’s your take on integrating streaming with analytics? Let us know in our Salck channel.

Stay updated with our newsletter

Subscribe and never miss another blog post, announcement, or community event.

Previous post
Zander Matheson

Zander Matheson

CEO, Founder
Zander is a seasoned data engineer who has founded and currently helms Bytewax. Zander has worked in the data space since 2014 at Heroku, GitHub, and an NLP startup. Before that, he attended business school at the UT Austin and HEC Paris in Europe.

Laura Funderburk

Senior Developer Advocate
Laura Funderburk holds a B.Sc. in Mathematics from Simon Fraser University and has extensive work experience as a data scientist. She is passionate about leveraging open source for MLOps and DataOps and is dedicated to outreach and education.
Next post