skills.rest
nrakow
nrakowCOMMUNITY
Explore all skills by this author →
GitHub

model-deprecation

Deprecate dbt models, columns, or sources with lineage checks and dbt compile validation.

1|1|Updated Feb 27, 2026
Search Tags:#migration#deprecation#dbt#governance#data-modeling#notification#lineage
One-click install
npx skills add https://github.com/nrakow/ae-skills-dev --skill model-deprecation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: model-deprecation
Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/model-deprecation
Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill model-deprecation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Safely retire dbt models, columns, or sources without breaking downstream consumers by coordinating lineage checks, deprecation tagging, migration windows, and clean removals.

Core Features & Use Cases

  • Governance and deprecation planning: identify downstream consumers and owners, tag artifacts as deprecated, and define migration timelines.
  • Safe removal workflow: verify references, run dbt compile/tests, and clean up artifacts after migration.
  • Notifications and coordination: draft and track stakeholder communications to minimize disruption.

Quick Start

Initiate a deprecation for a target artifact and let the workflow orchestrate lineage checks, stakeholder notifications, migration planning, and safe removal.

Frequently Asked Questions about model-deprecation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I safely deprecate dbt models without breaking downstream consumers?▼

To safely deprecate dbt models, you coordinate lineage checks, tag artifacts as deprecated, define migration timelines, and verify references with dbt compile and tests before clean removal.

What is the best way to manage dbt artifact retirement and data governance?▼

The best way to manage dbt artifact retirement is identifying downstream consumers, tagging artifacts as deprecated in schema.yml, and defining migration timelines to ensure safe removal across the dbt project.

How do I notify stakeholders and track communications during a dbt source deprecation?▼

Notify stakeholders during a dbt source deprecation by drafting and tracking communications through the workflow, ensuring downstream owners are informed throughout the migration window to minimize disruption.

Can I update schema.yml with deprecation metadata for retired dbt columns?▼

Yes, you can update schema.yml with deprecation metadata for retired dbt columns. The workflow tags artifacts as deprecated and updates metadata while verifying references through dbt compile and targeted tests.

Does dbt lineage verification prevent breaking changes when removing deprecated models?▼

Yes, dbt lineage verification prevents breaking changes by checking downstream references before removal. The workflow validates changes with dbt compile and targeted tests to ensure safe retirement of models, columns, or sources.

Related Skills

Explore More Data & Analytics Skills→
AltimateAIAltimateAI
792

dbt-analyze

Identify downstream consumers and column-level lineage for changed dbt models.

Official
Intermediate
pkoka888pkoka888
1

dbt-migration

Classify and triage dbt migration errors across platforms.

Community
Advanced
miptah21miptah21
2

documenting-dbt-models

Document dbt models and columns in schema.yml with business context.

Community
Intermediate
randoneeringrandoneering

working-with-dbt-mesh

Coordinate dbt Mesh governance across multiple projects with cross-project refs.

Community
Advanced