DBT Interview Questions

Data Warehousing

1. Types of tables you are using in DBT? Tables, views, incremental, snapshot, ephemeral
2. How you create your models with incremental tables?
3. Why dbt is cool, what are the advantages? Testing with advanced test packages and the ability to version your code using GIT seamlessly
4. How do you create your CICD pipelines? Using Gitlab
5. Have you used any macro, what are they? They are just simple functions you can call from your dbt SQL models to not repeat yourself (DRY) and they are created with Jinja code.
6. What are seeds? Reference or config tables you can develop
7. How do you check your code or syntax errors? in the target tables when you compile and you copy paste the SQL code in Snowflake. Or directly in the query profiler.