DBT QUESTIONS AND ANSWERS
What is required to materialize a model in your data platform ? - Answer -1. dbt project
with .sql files saved in a model directory
2. connection to data warehouse with raw data loaded in
What should always be unique for each dbt developer working in development ? -
Answer -Target schema
How to use dbt ? - Answer -1. dbt Cloud
2. dbt Core
dbt Cloud - Answer -Online IDE and interface
dbt Core - Answer -Command line interface that can be run locally
Where is the data stored ? - Answer -Data is stored in the data platform
Where is the code stored ? - Answer -Code is stored in the git repository
How version control with git is done ? - Answer -Separate branches allow dbt
developers to simultaneously work on the same code base without impacting production
Modeling - Answer -Shaping of data from raw through your final transformed data
What are data engineers responsibilities - Answer -Build source tables
Build intermediate views and tables
What are models in dbt ? - Answer -SQL Select statements
Where do models live in dbt ? - Answer -'Models' folder
What is generally the relationship of models with table or view? - Answer -Each model
has a one-to-one relationship with a table or view in the data warehouse* (with a few
exceptions)
Can you run queries directly in dbt ? - Answer -Yes, by selecting the Preview button
How do you materialize a model ? - Answer -With the 'dbt run' command it will create a
view
How do you materialize a model as a table ? - Answer -Add 'config' block on top of
queries in .sql file
What is required to materialize a model in your data platform ? - Answer -1. dbt project
with .sql files saved in a model directory
2. connection to data warehouse with raw data loaded in
What should always be unique for each dbt developer working in development ? -
Answer -Target schema
How to use dbt ? - Answer -1. dbt Cloud
2. dbt Core
dbt Cloud - Answer -Online IDE and interface
dbt Core - Answer -Command line interface that can be run locally
Where is the data stored ? - Answer -Data is stored in the data platform
Where is the code stored ? - Answer -Code is stored in the git repository
How version control with git is done ? - Answer -Separate branches allow dbt
developers to simultaneously work on the same code base without impacting production
Modeling - Answer -Shaping of data from raw through your final transformed data
What are data engineers responsibilities - Answer -Build source tables
Build intermediate views and tables
What are models in dbt ? - Answer -SQL Select statements
Where do models live in dbt ? - Answer -'Models' folder
What is generally the relationship of models with table or view? - Answer -Each model
has a one-to-one relationship with a table or view in the data warehouse* (with a few
exceptions)
Can you run queries directly in dbt ? - Answer -Yes, by selecting the Preview button
How do you materialize a model ? - Answer -With the 'dbt run' command it will create a
view
How do you materialize a model as a table ? - Answer -Add 'config' block on top of
queries in .sql file
