What problem does it solve? Choosing and configuring the right Microsoft Fabric Data Factory tool for ingestion and orchestration is error-prone, especially with frequent platform changes like the April 2026 deprecation of Dataflow Gen2 Classic and the rename of Data pipeline to Pipeline. This Skill provides up-to-date decision guidance, JSON configuration references, and checklists so pipelines are designed correctly the first time. ## Core Features & Use Cases - Decision Guide: Maps scenarios to the right tool — Copy Activity, Copy Job, Copy Job Activity, Dataflows Gen2, Pipelines, Mirroring, Eventstreams, or Spark notebooks. - Configuration References: Provides JSON examples for pipelines, triggers, Copy Activity sources/sinks, watermark-based incremental loads, error handling, and retry policies. - Breaking Change Awareness: Covers Dataflow Gen2 Classic deprecation, CI/CD-by-default behavior, Fast Copy, Modern Evaluator Engine, and new preview activities like Lakehouse Maintenance, Refresh SQL Endpoint, and dbt Job. - Use Case: When asked to build an incremental ingestion pipeline from Azure SQL into a Fabric Lakehouse, the Skill guides selection of Copy Job Activity with automatic watermark management and provides the pipeline JSON with proper dependencies and retry policies. ## Quick Start Ask the agent to design a Fabric pipeline that incrementally ingests an Azure SQL orders table into a Lakehouse bronze layer and refreshes the semantic model afterward.
