Data Minded Academy - dbt

Exercises Repository

This repository is hosting the exercises provided to students in the context of the Relational DataBases course of the Data Minded Academy. This specific exercise is focused on dbt.

To start click on "Open in Gitpod" button

Once it is started, run the script ./create_profiles.sh which will generate connection with Snowflake Data Warehouse. DBT is already installed there, so everything is ready for you first dbt projects.

1) Your first dbt project

Enter the folder "my_first_dbt_project" explore the files in folders:

• models
• tests

Try running the following commands:

• dbt run
• dbt test

2) audience_measurement

Enter the folder "audience_measurement" explore the files in folders:

• models
• tests

Try running the following commands:

• dbt run (See the views created at DWH)
• dbt test

Resources:

• Learn more about dbt in the docs
• Check out Discourse for commonly asked questions and answers
• Join the chat on Slack for live discussions and support
• Find dbt events near you
• Check out the blog for the latest news on dbt's development and best practices