1. This will require a connection to a database. For this demo, I'll be using a Snowflake trial account. You can sign up for that [here](https://signup.snowflake.com/) (no credit card required). You can also use a different database like [postgresql](https://www.sqlshack.com/setting-up-a-postgresql-database-on-mac/). But configuration in later steps will be different.
2. Create a new database and schema. For Snowflake you can run:
```
create database if not exists jaffle_shop;
create schema if not exists jaffle_shop.dbt_demo;
```
3. Install dbt following the instructions [here](https://docs.getdbt.com/dbt-cli/installation). I recommend installing dbt with pip into a Python virtual environment.
```
pip install dbt
```
4. Clone the [dbt jaffle_shop repo](https://github.com/dbt-labs/jaffle_shop) locally and change to the new directory
```
git clone https://github.com/dbt-labs/jaffle_shop.git
cd jaffle_shop
```
5. Create a new `profiles.yml` file in your `~/.dbt/` directory
```
jaffle_shop:
  target: dev
  outputs:
    dev:
      type: snowflake
      account: <ACCOUNTNAME>
      user: <USERNAME>
      password: <PASSWORD>
      database: jaffle_shop
      warehouse: compute_wh
      schema: dbt_demo
```
6. Run `dbt debug` to confirm that everything is set up. If it passes, you are good to go!