dbt - Advanced Testing
Which of the following is the correct syntax to define a custom test in dbt?
Which of the following is the correct syntax to define a custom test in dbt?
easy📝 Conceptual Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Review dbt test YAML syntax
Custom tests in dbt are defined with a name, test type, column, and optional severity in a list format.Step 2: Identify correct structure
tests: - name: unique_test test: unique column_name: id severity: error correctly uses a list item with name, test, column_name, and severity keys.Final Answer:
tests:\n - name: unique_test\n test: unique\n column_name: id\n severity: error -> Option DQuick Check:
Correct YAML list with keys = tests: - name: unique_test test: unique column_name: id severity: error [OK]
Quick Trick: Custom tests need name, test, column, and optional severity [OK]
Common Mistakes:
MISTAKES- Using incorrect YAML indentation
- Missing the 'name' key for the test
- Not using a list for multiple tests
Master "Advanced Testing" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes