🗃️ Loading Data Into MotherDuck
4 items
📄️ Managing Organizations
Learn how to manage your Organization with MotherDuck
📄️ Running hybrid queries
Running hybrid queries only works when you have access to the local filesystem, and thus, it only operates through the CLI, not the web UI.
📄️ Sharing a Database
MotherDuck enables you to share snapshots of your databases with your colleagues, friends or the public. These snapshots provide a consistent view of your your data, which is very helpful when multiple analysts on the team are exploring or using the data to build machine learning models.
📄️ SQL Writing Assistance
Access SQL Writing Assistance Programmatically
📄️ 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.
📄️ 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.
📄️ Detach and re-attach a MotherDuck database
After creating a remote MotherDuck database,
📄️ Upgrading to DuckDB 0.10.2
DuckDB 0.10.2
📄️ Upgrading to DuckDB 0.9.2
DuckDB 0.9.2