技能 数据科学 dbt 数据转换模式

dbt 数据转换模式

v20261112
dbt-transformation-patterns
面向生产环境的 dbt 数据转换模式,涵盖模型分层组织、数据质量测试、文档编写与增量处理,用于构建可靠的数据管道。
获取技能
412 次下载
概览

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.

Limitations

  • Use this skill only when the task clearly matches the scope described above.
  • Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
  • Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
信息
分类 数据科学
名称 dbt-transformation-patterns
版本 v20261112
大小 5.18KB
更新时间 2026-11-13
语言