Testing Patterns

models:
  - name: dim_customers
    columns:
      - name: customer_id
        tests:
          - unique
          - not_null
      - name: email
        tests:
          - unique
          - not_null
      - name: status
        tests:
          - accepted_values:
              values: ['active', 'inactive', 'churned']

- name: customer_id
  tests:
    - relationships:
        to: ref('dim_customers')
        field: customer_id

-- tests/assert_order_total_positive.sql
select *
from {{ ref('fct_orders') }}
where order_total < 0

sources:
  - name: raw_ecommerce
    freshness:
      warn_after: {count: 12, period: hour}
      error_after: {count: 24, period: hour}
    tables:
      - name: orders
        loaded_at_field: _loaded_at