You want to ensure a column email in your users model has no nulls and all values are unique using dbt-utils tests. Which YAML snippet correctly applies both tests?
hard📝 Application Q15 of 15
dbt - Advanced Testing
You want to ensure a column email in your users model has no nulls and all values are unique using dbt-utils tests. Which YAML snippet correctly applies both tests?
Step 1: Recall correct dbt-utils test syntax for columns
dbt-utils not_null and unique tests expect column_name: email under the test name.
Step 2: Evaluate each YAML snippet
Snippet with column_name: email for both tests correctly uses the required key-value format. The snippet missing colons after tests is invalid YAML. Using a list - email passes incorrect config type. Using columns is invalid key.
