dbt-transformation-patterns

Documentation & Productivité

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

Documentation

dbt Transformation Patterns

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.

Use this skill when

●Building data transformation pipelines with dbt
●Organizing models into staging, intermediate, and marts layers
●Implementing data quality tests and documentation
●Creating incremental models for large datasets
●Setting up dbt project structure and conventions

Do not use this skill when

●The project is not using dbt or a warehouse-backed workflow
●You only need ad-hoc SQL queries
●There is no access to source data or schemas

Instructions

●Define model layers, naming, and ownership.
●Implement tests, documentation, and freshness checks.
●Choose materializations and incremental strategies.
●Optimize runs with selectors and CI workflows.
●If detailed patterns are required, open resources/implementation-playbook.md.

Resources

●resources/implementation-playbook.md for detailed dbt patterns and examples.

Compétences similaires

Explorez d'autres agents de la catégorie Documentation & Productivité

Voir tout le catalogue

api-documenter

Master API documentation with OpenAPI 3.1, AI-powered tools, and

VOIR LA FICHE

terraform-module-library

Build reusable Terraform modules for AWS, Azure, and GCP infrastructure following infrastructure-as-code best practices. Use when creating infrastructure modules, standardizing cloud provisioning, or implementing reusable IaC components.

VOIR LA FICHE

firebase

"Firebase gives you a complete backend in minutes - auth, database, storage, functions, hosting. But the ease of setup hides real complexity. Security rules are your last line of defense, and they're often wrong. Firestore queries are limited, and you learn this after you've designed your data model. This skill covers Firebase Authentication, Firestore, Realtime Database, Cloud Functions, Cloud Storage, and Firebase Hosting. Key insight: Firebase is optimized for read-heavy, denormalized data. I"

VOIR LA FICHE
Utiliser l'Agent dbt-transformation-patterns - Outil & Compétence IA | Skills Catalogue | Skills Catalogue