How to Connect Claude Desktop to Your dbt Project with MCP
Learn how to connect Claude Desktop to a local dbt project with the official dbt MCP server and safe dbt CLI access.
dbt
This page contains hands-on dbt (Data Build Tool) tutorials. dbt is a powerful open-source technology that enables teams to transform raw data into valuable insights through SQL-based workflows. Here you will find hands-on tutorials and best practices for using dbt effectively. Our dbt tutorials also serve as a resource for anyone preparing for dbt Analytics Engineering Certification Exam.
70 posts
dbt Snapshots Explained: Track Historical Changes in Your Data Warehouse
Learn what dbt snapshots are, why they matter, and how to track historical changes in your data warehouse with a beginner-friendly customer status example.
dbt Exposures Explained for Beginners: Connect Models to Dashboards, Reports, and ML Models
Learn what dbt exposures are, why they matter, and how to connect dbt models to dashboards, reports, notebooks, and machine learning workflows.
dlt vs dbt: What is the Difference?
📘 Introduction When you start learning modern data pipelines, you will quickly hear about both dlt and dbt. The names look similar, and both tools are used in data engineering workflows. But they solve different problems. In this beginner-friendly guide, we will explain the difference between dlt and dbt, where...
What is the dbt Fusion Engine? A Beginner-Friendly Guide
📘 Introduction dbt Fusion is one of the biggest changes in the dbt ecosystem. If you already know dbt Core, you can think of Fusion as a new engine underneath the familiar dbt workflow. You still write models, define dependencies, configure YAML files, define tests, and build transformation logic in SQL....
Common dbt Terms Explained for Beginners
📘 Introduction When you start learning dbt, you will quickly come across many new terms: models, materializations, seeds, snapshots, tests, macros, DAGs, packages, profiles, and targets. At first, these concepts can feel confusing, especially if you are new to analytics engineering or modern data pipelines. In this beginner-friendly guide, we’...
Our New Book is Out Now: Building Modern Data Pipelines with dbt
Exciting News! Our new book has been released! 📕🚀 ➡️ Building Modern Data Pipelines with dbt: From Raw Data to Gold Standard with the Medallion Architecture by Fabian Hanik and Manuel Hanik VIEW ON AMAZON 📕 What is this book about? dbt has become one of the most important tools in the modern...
Sample Data: E-Commerce Dataset
📘 Introduction In the following you will find a fictional e-commerce dataset. The Deep Learning Nerds Academy Store is a fan shop that offers merchandise inspired by artificial intelligence and data science. Its product range includes hoodies, T-shirts, accessories, and other themed items designed for technology enthusiasts and fans...
Using pre-hooks in dbt: A Hands-On Guide
📘Introduction In this hands-on dbt tutorial, you'll learn how to use pre-hooks to automate tasks such as creating backup tables before a model runs. Pre-hooks allow you to execute SQL before your dbt model builds, which is useful for auditing, data quality checks, or preparing...