dbt - Governance and Collaboration
Which of the following is the correct syntax to specify a column type in a model contract in
schema.yml?Which of the following is the correct syntax to specify a column type in a model contract in schema.yml?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall correct syntax for column definitions
Inschema.yml, columns are defined withnameandtypekeys.Step 2: Match options to syntax
- name: customer_id\n type: integer usesnameandtypecorrectly. Others use incorrect keys likecolumn,datatype, orfield.Final Answer:
- name: customer_id\n type: integer -> Option BQuick Check:
Column type syntax uses name and type = B [OK]
Quick Trick: Use 'name' and 'type' keys for columns in schema.yml [OK]
Common Mistakes:
MISTAKES- Using 'datatype' instead of 'type'
- Using 'column' or 'field' instead of 'name'
- Mixing SQL types with dbt contract types
Master "Governance and Collaboration" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes