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
Oldest comments (0)