elt_example_model.yml

---
version: 2
models:
  - name: elt_example_model
    description: Source table with cleaned input data from call log supplier X

    columns:
      - name: call_surr_key
        decription: surrogate key for the row
        tests: 
          - unique
        
      - name: call_type
        description: type of call (incoming/outgoing)
        tests: 
          - accepted_values:
              values: ['incoming', 'outgoing']
              
      - name: call_outcome
        description: outcome of the call (answered/unanswered)
        tests: 
          - accepted_values:
              values: ['answered', 'unanswered']
              
      - name: call_duration
        description: length of the call in seconds
        tests:
          - dbt_utils.expression_is_true:
              expression: "> 0"