ELT with DBT : an introductory tutorial

⭐ This repo contains the code for the Data Build Tool : introductory tutorial blogpost. It is in two parts on Medium :

1. Data Build Tool : introductory tutorial — Part 1/2 : available at https://medium.com/@jb.excoffier/data-build-tool-introductory-tutorial-part-1-2-9186f5ac5947 for an introduction to DBT and the basics.
2. Data Build Tool : introductory tutorial — Part 2/2 : available at https://medium.com/@jb.excoffier/data-build-tool-introductory-tutorial-part-2-2-3fe4ad00422d for an overview of advanced features (testing, documentation, etc).

It is an introduction to the ELT (Extract Load Transform) way of processing data and DBT (Data Build Tool) to manage the data transformation part. The blogpost describes the best functionalities of DBT and illustrates each of them with code from this repo.

This repo includes :

• 💻 DBT codes that includes YAML config files, SQL models and data and unitary tests (dbt_project folder and the profiles.yml file).
• 💾 Light version of the PAGILA database that is used in the blogpost (light_pagila_for_dbt_tutorial.sql).
• 🔧 Setup file for the needed packages (requirements.txt).
• 📊 All images that were generated and used in the blogpost (Images folder).

So, ready to bake some data ?