Dbt Interview Questions

13 real Dbt questions asked in live technical interviews — each with a model answer. Updated weekly.

🎤 Auto-captured by Assisting AI during live interviews

These Dbt interview questions were captured from real interviews by candidates using Assisting AI. Each links to a full model answer. For real-time help during your own interview, get Assisting AI from ₹500/day.

Are you familiar with Git, Jenkins, dbt, typical CI/CD pipelines, and Python, and how to deploy objects from development to production?🟡 Medium · Conceptual · Asked 1×Do you normally deploy dbt code/models from one environment to another? For example, working in a dev instance of Databricks and then moving to production. How do you manage environment variables, connections, and passwords to keep them secure and easy to manage?🟡 Medium · Conceptual · Asked 1×Earlier we discussed the silver layer, where we mainly write data cleansing logic using PySpark. I'm curious: would you still use Databricks notebooks and PySpark commands to create the gold layer? Are you familiar with dbt and can you execute dbt using traditional SQL templates?🟡 Medium · Conceptual · Asked 1×Can you define a pre-hook?🟢 Easy · Conceptual · Asked 1×Is a pre-hook the same as a post-hook in dbt?🟢 Easy · Conceptual · Asked 1×How can I run a model in dbt? What command should I use?🟢 Easy · Conceptual · Asked 1×In dbt, what is the difference between ref and source?🟡 Medium · Conceptual · Asked 1×What is the difference between ref and source functions?🟡 Medium · Conceptual · Asked 1×Show the model syntax inside a dbt model. Is the SQL syntax to create a view for product?🟢 Easy · Coding · Asked 1×I want to create a dbt model on top of the product table. How would I structure it across bronze, silver, and gold layers, and what would the SQL look like to create a view that selects shop from product?🟡 Medium · Conceptual · Asked 1×In dbt, what is the meaning of a model?🟢 Easy · Conceptual · Asked 1×Can you explain DBT in technical language?🟡 Medium · Conceptual · Asked 1×Can you explain DBT using layman terms with an example involving mango?🟢 Easy · Conceptual · Asked 1×

🎤 Get Dbt questions answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

Browse Other Topics