des-airflow-orchestration

Orchestrate DES workflows into scheduled Apache Airflow DAGs with validation gates.

2|Updated May 20, 2026
One-click install
npx skills add https://github.com/DKSang/DES-SKILL --skill des-airflow-orchestration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: des-airflow-orchestration
Source: https://github.com/DKSang/DES-SKILL/tree/main/skills-stack/des-airflow-orchestration
Command: npx skills add https://github.com/DKSang/DES-SKILL --skill des-airflow-orchestration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill solves the problem of turning DES data-engineering design artifacts into production-ready Apache Airflow orchestration that is scheduled, retry-safe, validation-gated, observable, and evidence-producing.

Core Features & Use Cases

  • Design Airflow DAG boundaries that coordinate DES phase outputs into executable task graphs without embedding heavy transformation logic.
  • Implement robust operational controls including schedules, retries, timeouts, backfills/catchup behavior, and idempotent reruns.
  • Integrate common data-stack components such as dlt ingestion, dbt transformations, Provero validation gates, DuckDB profiling, and Fabric job/notebook execution with lineage and alerting plans.
  • Produce operational evidence to support DES “Done” gates, release readiness, troubleshooting, and handoff.

Quick Start

Use the des-airflow-orchestration skill to design an Airflow DAG that schedules ingestion and runs Bronze→Silver→Gold with Provero/dbt gates, lineage planning, alerts, and an evidence pack for the target environment.

Frequently Asked Questions about des-airflow-orchestration

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

FAQPage Schema
How do I design Airflow DAGs that coordinate ingestion and transformation without embedding heavy logic?

Design Airflow DAGs by defining thin, idempotent task boundaries that coordinate phase outputs like dlt ingestion and dbt transformations into executable task graphs, avoiding embedded logic. This approach keeps workflows scheduled, retry-safe, and maintainable.

What is the best way to implement data quality gates in Airflow before publishing datasets?

Implement data quality gates in Airflow by adding pre-publish validation checks using tools like Provero and DuckDB profiling. These gates ensure datasets pass quality validation before release, producing operational evidence for troubleshooting and handoff.

Does this Airflow orchestration approach support dbt, dlt, and DuckDB integration in one workflow?

Yes, this Airflow orchestration approach supports integrating dlt for ingestion, dbt for transformations, and DuckDB for profiling within a single DAG. It coordinates these data-stack components while maintaining lineage and alerting plans.

How do I configure retry and backfill policies for idempotent reruns in Apache Airflow?

Configure retry and backfill policies in Apache Airflow by applying explicit schedules, timeouts, and catchup behavior to your DAGs. This ensures idempotent reruns, allowing failed tasks to recover safely without duplicating data or side effects.

Why do I need lineage and observability planning for Airflow DAG orchestration?

Lineage and observability planning for Airflow DAG orchestration is needed to track data flow across Bronze to Gold layers and external checks. It provides visibility into task execution, supports alerting, and generates evidence for release readiness.

Can I use Airflow to schedule Bronze to Silver to Gold transformations with validation gates?

Yes, you can use Airflow to schedule Bronze to Silver to Gold transformations by structuring DAGs with Provero and dbt validation gates. This coordinates phase outputs, enforces pre-publish checks, and produces evidence packs aligned to release requirements.