Dbt guide
What is required to materialize a model in your data platform ? - answer1. 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 ? -
answerTarget schema
How to use dbt ? - answer1. dbt Cloud
2. dbt Core
dbt Cloud - answerOnline IDE and interface
dbt Core - answerCommand line interface that can be run locally
Where is the data stored ? - answerData is stored in the data platform
Where is the code stored ? - answerCode is stored in the git repository
How version control with git is done ? - answerSeparate branches allow dbt developers
to simultaneously work on the same code base without impacting production
Modeling - answerShaping of data from raw through your final transformed data
What are data engineers responsibilities - answerBuild source tables
Build intermediate views and tables
What are models in dbt ? - answerSQL Select statements
Where do models live in dbt ? - answer'Models' folder
What is generally the relationship of models with table or view? - answerEach 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 ? - answerYes, by selecting the Preview button
How do you materialize a model ? - answerWith the 'dbt run' command it will create a
view
How do you materialize a model as a table ? - answerAdd 'config' block on top of
queries in .sql file
How do you materialize only one model at a time - answerUse the option '-m' in your
'dbt run' command
e.g. dbt run -m dim_customers
What is modularity ? - answerbuilding a final product piece by piece
What are the benefits of modularity ? - answerEach model is reusable for other
downstream models
How do you reference the model 'stg_customers' in dbt ? - answerUsing the 'ref'
function
e.g. {{ ref('sag_customers') }}
What does the 'compile sql' button do ? - answerSee how dbt will actually run the code
by changing the references to actual names. This is only a preview, it does not
materialize
What is the benefit of references ? - answerIt also assigns dependencies between
models and make sure models are built in the right order
What is required to materialize a model in your data platform ? - answer1. 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 ? -
answerTarget schema
How to use dbt ? - answer1. dbt Cloud
2. dbt Core
dbt Cloud - answerOnline IDE and interface
dbt Core - answerCommand line interface that can be run locally
Where is the data stored ? - answerData is stored in the data platform
Where is the code stored ? - answerCode is stored in the git repository
How version control with git is done ? - answerSeparate branches allow dbt developers
to simultaneously work on the same code base without impacting production
Modeling - answerShaping of data from raw through your final transformed data
What are data engineers responsibilities - answerBuild source tables
Build intermediate views and tables
What are models in dbt ? - answerSQL Select statements
Where do models live in dbt ? - answer'Models' folder
What is generally the relationship of models with table or view? - answerEach 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 ? - answerYes, by selecting the Preview button
How do you materialize a model ? - answerWith the 'dbt run' command it will create a
view
How do you materialize a model as a table ? - answerAdd 'config' block on top of
queries in .sql file
How do you materialize only one model at a time - answerUse the option '-m' in your
'dbt run' command
e.g. dbt run -m dim_customers
What is modularity ? - answerbuilding a final product piece by piece
What are the benefits of modularity ? - answerEach model is reusable for other
downstream models
How do you reference the model 'stg_customers' in dbt ? - answerUsing the 'ref'
function
e.g. {{ ref('sag_customers') }}
What does the 'compile sql' button do ? - answerSee how dbt will actually run the code
by changing the references to actual names. This is only a preview, it does not
materialize
What is the benefit of references ? - answerIt also assigns dependencies between
models and make sure models are built in the right order
