Data Minded Academy - Relational Databases

DBT exercise

This repository is hosting the exercises provided to students in the context of the Relational DataBases course of the Data Minded Academy. This specific excersise 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 DataWarehouse. DBT is already installed there, so everything is ready for you first dbt projects.

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

• models
• tests

And file:

• dbt_profiles.yml

Try running the following commands:

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

Afterwards start your own dbt project by making a new folder and running inside it

• dbt init

Welcome to your new dbt project!

Using the starter project

Try running the following commands:

• dbt run
• 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