Hongxia555

Scaffold a new dbt model from a description. Generates staging, intermediate, and mart SQL files with standard structure plus schema.yml tests. Use when adding a new model to a dbt project.

Given a short description of a data outage or quality incident, structure a post-mortem with timeline, root cause, impact, action items, and prevention. Use after any data incident.

Given source-to-target requirements, design a data pipeline architecture. Outputs architecture rationale, medallion layer breakdown, failure modes, and data quality checkpoints.