← Your first PRlesson 6 of 9

  1. ✓ set up
  2. ✓ pick data
  3. ✓ find source
  4. ✓ place it
  5. ✓ model
  6. YAML
  7. build
  8. PR
  9. merge

Describe and test it

Next to your .sql goes a .yml file with the same name. It does three jobs: names an owner, documents the columns, and declares tests — assertions checked on every build, forever. CI requires it; more importantly, it is where your knowledge of the data gets written down.

Write it by hand — it is short, and writing it is how you make the decisions it contains. Tap the numbers to see what each part is for:

stg_reference_opening_hours.ymltap a numbered line
models:
  - name: stg_reference_opening_hours

step 1 of 3