CodeNewbie Community 🌱

Tip Season
Tip Season

Posted on

dbt (data build tool) explained in 100 words

Let’s say you have a huge amount of raw data (it can be any kind of data that is not cleaned like urls, duplicates, nulls etc.), and you want to convert this raw data into something meaningful for your data analysis(say reports, ML models etc.); you can use dbt to easily convert this raw data into meaningful data objects like tables, views etc with simple SELECT queries by connecting it with your data warehouse. dbt takes care of creating , updating , modifying your data tables at scale. You can connect dbt with many modern applications like snowflake, postgres etc

You can learn about it with a real world example (using shopify or amazon) at in this dbt beginner guide

Top comments (0)