📄️ 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 firstname.lastname@example.org.
📄️ 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.
📄️ Querying a shared MotherDuck database
In order to use a database that a colleague shared with you, you can attach it using the DuckDB ATTACH command. All that you need is a share URL from your colleague.
📄️ Running hybrid queries
Running hybrid queries only when you have access to the local filesystem, and thus, it only operates through the CLI, not the web UI.
📄️ Detach and re-attach a MotherDuck database
After creating a remote MotherDuck database,