Quiz: Advanced dbt Concepts

In a property file:

version: 2

models:
  - name: good_orders
    columns:
      - name: order_id
        tests:
          - unique

In a test file:

{% test unique() % }
SELECT COUNT(DISTINCT id)
FROM {{ model }}
{% endtest %}

In a config block in a model:

{{ config(
 test="unique"
)
}}

Directy in the terminal:

dbt test -s good_orders --column unique_id --test_name unique