DBT Fundementals
A few screenshots from my work in the DBT Fundamentals course.
1. Materializing Views & First Production Run
The tutorial doesn't mention Big Query needs the "--full-refresh" command here; after solving for that and separating our cleaning code from transforming code, we have our first production run - also shown below.
2. Testing with YML Instructions & Creating Documentation
Added and successfuly ran some tests for unique values, specific values, and table relationships.
3. Re-organizing File Structure to Staging and Marts Folders
With marts folders for each department.
4. Creating a Source Reference with a YML file
5. Custom Test: Total Amount Always >= 0
6. Block Documentation + Final Run
