Analytic Engineering & dbt: 0-100

dbt Logo

Summary

This is a quick guide on how to get started and create your data models using dbt (data build tool). dbt is a Python-based packaged for managing Transformations in the ELT (Extract, Load, Transform) lifecyle.

%%html

<iframe width="560" height="315" src="https://www.youtube.com/embed/SDhNA3k0Jhc" frameborder="0" 
allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" 
allowfullscreen></iframe>

Installation

The Tutorial

Go to this repository customer-analytics, and enter the following in your CLI (outside of this repo):

git clone https://github.com/CloudChaoszero/customer-analytics.git
  • Note: I used a Snowflake Trial to implement this tutorial.

Environment

conda create --name dbtcourse
python -m ipykernel install --user --name dbtcourse --display-name "Python (dbt Course)"