Configure environment

1. Install prerequisites:

   • IDE (e.g. VS Code)
   • Docker

2. Fork & Clone this repository and open in IDE

3. Spin up Docker containers

   All the services are configured via Docker containers.

   • devcontainer
   • Postgres

   # build dev container
   devcontainer build .
   
   # open dev container
   devcontainer open .

   

4. Verify you are in a development container by running commands:

   dbt --version

   

   If any of these commands fails printing out used software version then you are probably running it on your local machine not in a dev container!

Install dbt packages

1. Install modules via packages.yml

   dbt clean # clean temp files
   dbt deps # install dependencies (modules)

Homework

1. Build a data mart over Data Vault.

Dynamics of changes in the number of orders by calendar week and order status.