DuckDB
Execute SQL commands in DuckDB.
Credentials
Open the file named io_config.yaml
at the root of your Mage project and enter DuckDB 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.