dbt - Advanced Testing
Which of the following is the correct syntax to define a unique test on a column in a dbt YAML file?
Which of the following is the correct syntax to define a unique test on a column in a dbt YAML file?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall YAML test syntax in dbt
Tests are listed as a YAML list under the 'tests' key, each with a dash and test name.Step 2: Match correct indentation and list format
tests: - unique: column_name shows 'tests:' followed by a list item '- unique: column_name', which is correct YAML syntax for dbt tests.Final Answer:
tests: - unique: column_name -> Option AQuick Check:
YAML lists use dash (-) before items [OK]
Quick Trick: YAML lists need dash (-) before each test [OK]
Common Mistakes:
MISTAKES- Missing dash (-) before test name
- Incorrect indentation
- Placing test name and column incorrectly
Master "Advanced Testing" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes