MotherDuck

​

Credentials

Open the file named io_config.yaml at the root of your Mage project and enter DuckDB database name & schema. To connect to a MotherDuck database, you’ll need to add a MOTHERDUCK_TOKEN and a md: to the database name.

version: 0.1.1
default:
  DUCKDB_DATABASE: md:database
  DUCKDB_SCHEMA: main
  MOTHERDUCK_TOKEN: token

​

How to use

1. Create a new pipeline or edit an existing pipeline.

2. Add a data loader or transformer SQL block.

3. In the block’s header, click the dropdown menu labeled Connection and select the option labeled DuckDB.

4. In the block’s header, click the dropdown menu labeled Profile and select the option labeled default.

   If the name of your profile in the io_config.yaml file is different, then select the profile name that matches your settings.

5. You can optionally check the box labeled Use raw SQL. If you do, read more about how to use SQL blocks with raw SQL.

6. Write your SQL statements in the SQL block.

7. Once you’re finished writing your SQL statements, click the play button in the top right corner of the block to execute the SQL block and preview the results.