text: {% test expect_column_distinct_values_to_equal_set(model, column_name,
                                                              value_set,
                                                              quote_values=True,
                                                              row_condition=None
                                                              ) %}
  
  with all_values as (
  
      select distinct
          {{ column_name }} as column_value
  
      from {{ model }}
      {% if row_condition %}
      where {{ row_condition }}
      {% endif %}
  
  ),
  set_values as (
  
      {% for value in value_set -%}
      select
          {% if quote_values -%}
          '{{ value }}'
          {%- else -%}
          {{ value }}
          {%- endif %} as value_field
      {% if not loop.last %}union all{% endif %}
      {% endfor %}
  
  ),
  unique_set_values as (
  
      select distinct value_field
      from
          set_values
  
  ),
  validation_errors as (
  
      select
          *
      from
          all_values v
          full outer join
          unique_set_values s on v.column_value = s.value_field
      where
          v.column_value is null or
          s.value_field is null
  
  )
  
  select *
  from validation_errors
  
  {% endtest %}
  