DOs and DON'Ts
and maybe a few words about DBT framework
Yes, we need all of these.
Point and click adventure
$$$
Code (SQL and/or Python)
$
Good framework generates SQLs and keeps transformation inside the database
Expectation
Reality
Issues
Expectation
Reality
Issues
Expectation
Reality
Issues
Expectation
Reality
Issues
Models = Transformation
1 Model = 1 SQL statement
Materialization can be a view, table, temp table, or custom
Handles schema changes