This page contains 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.
Introduction Once you've defined sources in dbt, you can reference them using the source() function. This is essential for dbt to identify dependencies between sources and models. In this hands-on tutorial, we’ll show you how to use the source() function with a sample project. 📌 This is a...
Introduction In dbt (data build tool), sources represent raw data tables that already exist in your data warehouse - often provided by upstream systems like operational databases, APIs or other applications. Defining these sources in sources.yml is a crucial step in your data project. This tutorial will guide you...
Introduction Seeds in dbt are a simple and powerful way to load static data - such as reference tables, lookup data, or mapping tables - directly into your data warehouse. In this tutorial, you'll learn what seeds are and how to use them effectively. Since this topic is...
Introduction Want to start with dbt core but don’t know where to begin? Don’t worry! In this tutorial, we'll walk through setting up a new dbt project from scratch - we cover the entire process from creating a virtual environment to initializing your project and verifying...
Introduction Modern data work doesn’t always require complex infrastructure. If you're looking for a fast, local-first analytics stack, dbt + DuckDB is a powerful combination. In this tutorial, we'll walk through connecting dbt to DuckDB — perfect for analysts, developers, and data enthusiasts who want simplicity without...
Introduction In dbt, the dbt_project.yml file is the backbone of your project configuration. It controls how dbt behaves, where it looks for different resource types, and how your models are materialized and organized. In this tutorial, we'll walk through a sample dbt_project.yml file and...
Introduction In dbt, one of the most essential commands is dbt build. In this tutorial, we’ll dive into the dbt build command, exploring its syntax, functionality, and practical usage. Since this topic is relevant for the dbt Analytics Engineering Certification Exam, this guide will be a valuable resource on...
Introduction In dbt, one of the most essential commands is dbt test. In this tutorial, we’ll dive into the dbt test command, exploring its syntax, functionality, and practical usage. This tutorial is also a valuable resource for those studying for the dbt Analytics Engineering Certification Exam. 💡Explanation of dbt...
Introduction Data Transformation is a crucial step in any data project, ensuring that raw data is turned into accurate, consistent, and usable data. One tool that has become especially valuable in this process is dbt (Data Build Tool). In this tutorial, we’ll explore what dbt is, how it simplifies...