Key tasks

📄️ Upgrading to DuckDB 0.9.2

Important: MotherDuck is on DuckDB version 0.9.2 as of 9am PST November 15th!

📄️ Loading Data Into MotherDuck

You can leverage MotherDuck’s managed storage to persist your data. MotherDuck storage provides a high level of manageability and abstraction, optimizing your data for secure, durable, performant, and efficient use. There are several ways to load data into MotherDuck storage.

📄️ Using AI to query data (Alpha)

This is an Alpha feature. We encourage you to provide feedback via Slack or by emailing support@motherduck.com.

📄️ Database operations

While embedded DuckDB uses files on your local filesystem to represent databases, MotherDuck implements SQL syntax for creating, listing and dropping databases.

📄️ Specifying different databases

MotherDuck enables you to specify an active/current database and an active/current schema within that database.

📄️ Switching the current database

Below are examples of how to determine the current/active database and schema and switch between different databases and schemas:

📄️ Querying local DuckDB databases and files

MotherDuck seamlessly integrates with DuckDB allowing you to use its full power to explore data on your laptop.

📄️ Querying Files in Amazon S3

Since MotherDuck is hosted in the cloud, one of the benefits of MotherDuck is better and faster interoperability with Amazon S3. MotherDuck's "hybrid mode" automatically routes queries that query Amazon S3 to MotherDuck's execution runtime in the cloud rather than executing these queries locally.

📄️ Writing Data to Amazon S3

You can use MotherDuck to transform files on Amazon S3 or export data from MotherDuck to Amazon S3.

📄️ Managing a shared MotherDuck database

MotherDuck enables you to share snapshots of your databases with your colleagues and friends. To share a database requires creating a SHARE object, which gives you a URL that others can use to read the data. This is a form of Capability-Based Access Control.