Dbt

BigQuery

BigQuery is Google Cloud's fully managed, serverless data warehouse that lets users run fast SQL analytics over massive datasets without provisioning or managi…

Airbyte

Airbyte is an open-source data integration platform that moves data from source systems — databases, SaaS apps, and files — into destinations like data warehou…

Alteryx

Alteryx is a self-service analytics platform that lets analysts prepare, blend, and analyze data through a visual, drag-and-drop workflow designer, without req…

Dagster

Dagster is an open-source, Python-based data orchestration platform that lets teams define, schedule, test, and monitor data pipelines as software assets with…

Databricks

Databricks is a cloud-based data and AI platform, built by the original creators of Apache Spark, that unifies data engineering, analytics, and machine learnin…

dbt

dbt (data build tool) is an open-source, SQL-based transformation framework that lets analytics engineers build, test, and document data transformation pipelin…

Snowflake

Snowflake is a cloud-native data warehouse platform that separates storage and compute so organizations can scale each independently, running SQL analytics on…

Prefect

Prefect is a modern workflow orchestration platform for building, scheduling, and observing data pipelines in Python, designed as a more Python-native alternat…

Building a Star Schema with dbt

How to design fact and dimension tables in dbt using surrogate keys, explicit grain, incremental materialization, and referential-integrity tests.

CI/CD for dbt Projects

How to build continuous integration and deployment pipelines for dbt projects using slim CI, automated testing, and gated production deploys.

dbt Best Practices

The project structure, layering, testing, and deployment conventions that keep a dbt project maintainable as it scales past a handful of models.

dbt Cloud vs dbt Core

A practical comparison of dbt's two deployment models — the self-hosted open-source CLI versus the managed dbt Cloud platform — and how to choose between them.

dbt Interview Questions

Common dbt interview questions covering concepts, materializations, testing, and macros, with the reasoning behind strong answers.

dbt Packages

dbt packages let you install and reuse pre-built models, macros, and tests published by others, from the dbt Hub or a private Git repo, via a simple packages.y…

dbt Quick Reference

A lookup sheet of the CLI commands, YAML config keys, and Jinja functions used every day in a dbt project.

dbt Semantic Layer Basics

The dbt Semantic Layer lets you define metrics once, on top of governed models, and query them consistently from any connected BI tool via MetricFlow instead o…

dbt vs Traditional ETL

How dbt's ELT, SQL-in-Git approach differs from traditional GUI-based ETL tools like Informatica or SSIS in compute cost, collaboration, and testing.

Documentation with dbt docs

dbt turns descriptions in your YAML files and standalone doc blocks into a browsable, auto-generated documentation site with an interactive lineage graph.

Installing dbt and Project Setup

How to install dbt Core with the correct database adapter, scaffold a new project with dbt init, and understand the role of profiles.yml.

Jinja Templating in dbt

Learn how dbt uses the Jinja templating engine to add loops, conditionals, and variables to plain SQL, turning static queries into reusable, environment-aware…

Macros

Learn how dbt macros turn repeated Jinja + SQL patterns into reusable, function-like building blocks, and how community packages like dbt_utils extend them fur…

Orchestrating dbt Runs

How to schedule and sequence dbt commands reliably in production using dbt Cloud jobs, Airflow, Dagster, or cron, including selectors and freshness checks.

SQL Models Basics

Learn how dbt models turn a plain SQL SELECT statement into a managed table or view, and how to organize them into a clean, layered project structure.

The dbt Project Structure

A tour of a dbt project's folders and configuration files, and the staging/intermediate/marts convention used to organize models.

What Is dbt?

An introduction to dbt (data build tool), the SQL-first framework that lets analysts and engineers transform data already loaded in a warehouse using version-c…

Your First dbt Model

How to write, materialize, and run a basic dbt model, including the ref() function and how dbt builds its dependency DAG.