Open the file named
io_config.yaml at the root of your Mage project and enter DuckDB database name:
version: 0.1.1 default: DUCKDB_DATABASE: database DUCKDB_SCHEMA: main
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.yamlfile 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.