The MotherDuck intergration is supported in Mage versions
>=0.9.63
Credentials
Open the file namedio_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.
How to use
- Create a new pipeline or edit an existing pipeline.
- Add a data loader or transformer SQL block.
- In the block’s header, click the dropdown menu labeled Connection and select the option labeled DuckDB.
-
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. - You can optionally check the box labeled Use raw SQL. If you do, read more about how to use SQL blocks with raw SQL.
- Write your SQL statements in the SQL block.
- 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.