7 DuckDB in the cloud with MotherDuck

This chapter covers

  • The idea behind MotherDuck
  • Understanding how the architecture works under the hood
  • Use cases for serverless SQL analytics
  • Creating, managing, and sharing MotherDuck databases
  • Tips for optimizing your MotherDuck usage

Up until this point, our focus has been on using DuckDB’s capabilities for querying datasets—whether they’re stored locally or remotely—directly from our own computers. While this approach addresses a broad range of needs, there are specific scenarios in which a remote database server offers additional advantages.

Enter MotherDuck: a solution for enhancing SQL analytics through a simplified scale-up strategy. In this chapter, we will learn how MotherDuck enables ...

Get DuckDB in Action now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.