skills.rest
accelerate-data
accelerate-dataOFFICIAL
Explore all skills by this author →
WebsiteGitHub

applying-staging-candidate

Apply an approved staging candidate to a plan and update its references.

3|Updated Feb 27, 2026
Search Tags:#automation#planning#validation#migration#staging#dbt
One-click install
npx skills add https://github.com/accelerate-data/migration-utility --skill applying-staging-candidate
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: applying-staging-candidate
Source: https://github.com/accelerate-data/migration-utility/tree/main/skills/applying-staging-candidate
Command: npx skills add https://github.com/accelerate-data/migration-utility --skill applying-staging-candidate

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a safe, auditable process to apply one approved staging candidate to a plan, updating only that candidate and enforcing governance.

Core Features & Use Cases

  • Enforces candidate approval and prevents unintended edits.
  • Updates staging model references and rewires downstream consumers with ref() following plan changes.
  • Use Case: When a new staging candidate is prepared, run this Skill to apply it, validate effects, and record status back to the plan.

Quick Start

Apply an approved staging candidate to a plan and update only that candidate section.

Frequently Asked Questions about applying-staging-candidate

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

FAQPage Schema
How do I apply an approved staging candidate to a dbt migration plan?▼

To apply an approved staging candidate to a dbt migration plan, you use an automated process that updates only that specific candidate while enforcing pre-edit checks for plan presence and approval status.

What happens to downstream dbt models when a staging candidate is applied?▼

When a staging candidate is applied, the process automatically updates staging model references and rewires downstream consumers using dbt ref() contracts to maintain dependency integrity.

What validation checks are required before applying a staging candidate?▼

Before applying a staging candidate, the system enforces pre-edit checks for plan presence, candidate existence, approval status, output definitions, and validation definitions to ensure safe migration.

Why does my staging candidate application fail with unresolved catalog errors?▼

Staging candidate application fails when unresolved catalog errors are detected during the process, preventing unintended edits and ensuring only validated candidates are written back to the plan.

Can I update multiple staging candidates in a single dbt migration workflow?▼

No, this process is designed to update only one specific approved staging candidate at a time, ensuring targeted changes and strict governance over individual stg_* model migrations.

How does applying a staging candidate coordinate with the overall migration plan?▼

Applying a staging candidate coordinates with the migration plan by writing back the candidate's status using provided references contracts, maintaining an auditable record of all plan updates.

Related Skills

Explore More Data & Analytics Skills→
accelerate-dataaccelerate-data
3

planning-refactor-mart

Generate a markdown refactor plan for bounded mart-domain units in dbt projects.

Official
Advanced
AltimateAIAltimateAI

refactoring-dbt-models

Analyze downstream dependencies and validate dbt model refactoring changes.

Official
Advanced
astronomerastronomer
419

cosmos-dbt-fusion

Run dbt Fusion projects on Snowflake or Databricks with Astronomer Cosmos.

Official
Advanced
hschnehschne
1

recruiter-profile

Sync approved profile updates across recruiter and freelancing platforms.

Community
Advanced