dbt - Fundamentals
dbt project, models, sources, refs, tests, documentation, materializations, seeds
1What is dbt (data build tool)?
What is dbt (data build tool)?
Answer
dbt is a data transformation tool that allows analysts and data engineers to write transformations in SQL or Python directly in the data warehouse. It follows the ELT (Extract, Load, Transform) approach where data is first loaded into the warehouse then transformed in place, unlike traditional ETL which transforms before loading. dbt manages model dependencies, tests, and documentation automatically.
2What is the basic structure of a dbt project?
What is the basic structure of a dbt project?
Answer
A dbt project is organized around key folders: models/ contains SQL files defining transformations, seeds/ holds CSV files loaded as tables, tests/ stores custom tests, macros/ has reusable Jinja functions, and snapshots/ keeps state captures. The dbt_project.yml file at the root configures the project (name, version, default materializations), while profiles.yml defines warehouse connections.
3What is a model in dbt?
What is a model in dbt?
Answer
A dbt model is a SQL file containing a SELECT statement that defines a data transformation. Each model corresponds to a .sql file in the models/ folder and produces a table or view in the data warehouse when executed. Models can reference other models via the ref() function, creating a dependency graph (DAG) that dbt executes in the correct order.
What is the purpose of the ref() function in dbt?
What is a source in dbt and how to declare one?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free