AgentSkillsCN

dbt-transformation-patterns

掌握 dbt（数据构建工具），用于分析工程中的模型组织、测试验证、文档撰写，以及增量式开发策略。无论是构建数据转换流程、创建数据模型，还是践行分析工程的最佳实践，dbt 都是你的得力助手。

SKILL.md
--- frontmatter
version: 4.1.0-fractal
name: dbt-transformation-patterns
description: 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.

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.

🧠 Knowledge Modules (Fractal Skills)

1. implementation-playbook