I know it's the hottest thing right now in the ETL/ELT space, but is it really any good?
Coming from a strong Qlik background, where Qlik's load script, if you know what you are doing can be really fast to get a solution going - is dbt just as fast to develop a solution in?
How does dbt compare to using raw SQL and SSIS packages to build a simple star schema data warehouse?
I've watched some YouTube videos on dbt, which are really showing me that it seems labour intensive, but perhaps once you know it, it's going to be really powerful.
I do prefer ETL to ELT - so that could be where I just don't get it; all my Qlik load scripts Transform the raw data and we do the same with SQL.
It looks like dbt is a good tool for data engineering and getting data from many sources into a, let's call it data repository.
Should I invest the time to learn it?
