{
"id": "workflow:dbt-model-review",
"_kind": "Workflow",
"_file": "workflows/workflows/workflows-data-eng-deep.yaml",
"_cluster": "workflows",
"attributes": {
"displayName": "dbt Model Review",
"workflowKind": "governance",
"triggerType": "event-driven",
"typicalCadence": "per-pull-request",
"complexity": "single-team",
"description": "Reviews dbt model changes before merge — validating naming conventions,\nchecking materialization strategy appropriateness, verifying test coverage\non primary keys and not-null constraints, auditing ref() lineage for\ncircular dependencies, profiling query cost against warehouse budgets, and\nensuring documentation blocks and schema YAML are updated. Excludes data\npipeline orchestration and scheduling.\n"
},
"outgoingEdges": [
{
"from": "workflow:dbt-model-review",
"to": "role:data-scientist",
"kind": "involves_role",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "role:code-reviewer",
"kind": "involves_role",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "role:ml-engineer",
"kind": "involves_role",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "skill-area:python-data-pipelines",
"kind": "requires_skill_area",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "skill-area:postgres-tuning",
"kind": "requires_skill_area",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "domain:data-science",
"kind": "applies_to_domain",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "domain:databases",
"kind": "applies_to_domain",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "responsibility:review-prs-merge-decisions",
"kind": "triggers_responsibility",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "responsibility:data-quality-monitoring",
"kind": "triggers_responsibility",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "org-unit:data-team",
"kind": "performed_by_org_unit",
"attributes": {}
},
{
"from": "workflow:dbt-model-review",
"to": "org-unit:data-platform-team",
"kind": "performed_by_org_unit",
"attributes": {}
}
],
"incomingEdges": []
}