Dbt

11 items tagged with "dbt"

Filter by type:

Best Practices1

Best Practice

dbt Style Guide

Community conventions for naming, structuring, and documenting dbt transformation projects.

Tutorials1

Tutorial

How to build transformation models and tests with dbt

Structure dbt staging and mart models, add tests and documentation, and run a build that materializes them in a warehouse.

Playbooks1

Playbook

dbt and ELT Adoption Program Playbook

Adopt dbt-style ELT to modernize transformation logic with version control, testing, documentation, and a medallion architecture.

Stacks6

Stack

Modern Data Stack (ELT)

Cloud-native ELT pattern: managed ingestion loads raw data into a warehouse, where dbt transforms it and a BI tool serves analytics.

Stack

dbt + BigQuery Analytics Stack

Serverless analytics engineering on Google BigQuery with dbt managing SQL transformations, tests, and lineage on top of warehouse-native compute.

Stack

Open Lakehouse Stack (Trino + Iceberg + dbt)

Open, engine-agnostic lakehouse: Iceberg tables on object storage, queried by Trino across sources, with dbt managing transformations in SQL.

Stack

dbt + Amazon Redshift

An ELT analytics stack where data lands in Amazon Redshift and dbt transforms it with version-controlled, tested SQL models.

Stack

Airbyte + dbt + Snowflake

An open-core ELT stack: Airbyte ingests data, Snowflake stores it, and dbt transforms it with tested, version-controlled SQL models.

Stack

Dagster + dbt

An asset-oriented data orchestration stack where Dagster schedules and observes pipelines built around dbt's transformation models.

Comparisons1

Comparison

dbt vs Dataform

The widely adopted SQL transformation framework versus Google's warehouse-native transformation tool integrated with BigQuery.

Benchmarks1

Benchmark

dbt Pipeline Performance Benchmark

A category of benchmarks measuring transformation pipeline performance in dbt — model build time, warehouse compute cost, and incremental run efficiency.