version: 2

models:
  - name: ephemeral_copy
    description: "An ephemeral copy of the table"
    columns:
      - name: id
        description: "The ID"
        tests:
          - not_null
          - unique
      - name: favorite_color
        tests:
          - accepted_values: { values: ['blue', 'green'] }

  # this whole model should pass and run
  - name: table_summary
    description: "The summary table"
    columns:
      - name: favorite_color_copy
        description: "The favorite color"
        tests:
          - not_null
          - unique
          - accepted_values: { values: ['blue', 'green'] }
          - relationships: { field: favorite_color, to: ref('ephemeral_copy') }
      - name: count
        description: "The number of responses for this favorite color"
        tests:
          - not_null