Sharing DuckDB Data with MotherDuck

MotherDuck Shares give you the power to share an updatable snapshot of an entire DuckDB database with other users by providing them with a secret URL. We’ve seen them be used inside companies to give colleagues access to data and publicly like the authors of the DuckDB in Action book have chosen to do [see page 26 in the free book].

Here’s a snippet showing how to use DuckDB-specific SQL extensions from Michael Simons, one of the authors of the DuckDB book:

To see this code snippet quack into action [ha!], you can visit app.motherduck.com and sign up for a free MotherDuck account. Then you can copy the ATTACH, USE, and desired SELECT statements into your MotherDuck notebook to see the SQL in action. Note that you can also do this all in the DuckDB CLI if you prefer.

We encourage you to check these out, vote on the snippets you find most helpful and submit your own snippets with public data.

Bundle Multiple Snippets Together

If you’re a current DuckDB Snippets user, you probably already caught that the snippet I shared above bundled multiple code snippets together into a single set. You can now do that whether or not you have a MotherDuck Share link referenced.

Here’s an example from Simon Aubury, who is also writing an upcoming DuckDB book, on how to load remote parquet files into DuckDB:

You can try out this snippet in MotherDuck or in the DuckDB CLI running on your laptop.

Simon also has other great snippets on Working with public REST APIs using DuckDB and Working with spatial data in DuckDB.

Thanks to the DuckDB Community

Thanks to the community for writing such great code snippets for the DuckDB Snippets site and voting on the snippets you like the most. Special thanks to Michael Simons, Michael Hunger, Simon Aubury and the MotherDuck DevRel team (Mehdi Ouazza, David Neal) for seeding these new-style snippets on the site. Looking forward to seeing what you submit!