Tests Documentation

• in file documentation

  version: 2
  
  models:
    - name: stg_jaffle_shop__customers
      description: one unique customer per row <------
      columns:
        - name: customer_id
          description: primary key
          tests:
            - unique
            - not_null
    - name: stg_jaffle_shop__orders
      description: one order per row <---------
      columns:
        - name: order_id
          description: primary key
          tests:
            - unique
            - not_null
  

• docs header

  • create a md file and write a docs header within which you will have your docs written

    

  • Then reference the doc header in the description field

    

Sources Documentation

• dbt docs generate