Step 2: Configure your dbt project to run with DuckDB#
Running dbt requires a data warehouse to store the tables that are created from the dbt models. For our data warehouse, we'll use DuckDB, because setting it up doesn't require any long-running services or external infrastructure.
You'll set up dbt to work with DuckDB by configuring a dbt profile:
Navigate into the jaffle_shop folder, which was created when you downloaded the project, inside your tutorial-dbt-dagster folder:
In this folder, with your text editor of choice, create a file named profiles.yml and add the following code to it: