How many activities can I include in a single ADF pipeline?

A single Azure Data Factory pipeline is limited to 80 activities. This count includes inner activities located within containers like ForEach or If-Condition blocks.

What is the limitation of using Set Variable inside a ForEach loop?

You cannot use a Set Variable activity inside a parallel ForEach loop because variables are scoped at the pipeline level, which would cause race conditions. Use Append Variable or sequential execution instead.

Why does my Data Flow fail when using Managed Identity for Blob Storage?

This failure often occurs if the accountKind property is empty or set to 'Storage'. For Managed Identity to work correctly in Data Flows, accountKind must be explicitly set to 'StorageV2'.

Can I nest an If-condition inside another If-condition in ADF?

No, Azure Data Factory does not support direct nesting of If-conditions. You must use an Execute Pipeline activity to call a child pipeline that contains the nested logic.

ADF Validation Rules

Name: ADF Validation Rules
Author: JosiahSiegel

byJosiahSiegel

•

Cloud Infrastructure

Enforces Azure Data Factory validation rules and provides architectural guidance for pipeline nesting, activity limits, and linked service configurations.

The adf-validation-rules skill equips Claude with deep technical knowledge of Azure Data Factory (ADF) constraints and best practices. It prevents common deployment failures by enforcing strict rules on control flow activity nesting—such as prohibiting nested If-conditions—and offers standardized architectural workarounds like the Execute Pipeline pattern. Beyond logic validation, the skill provides precise configuration requirements for Azure Blob Storage and SQL Database linked services, monitors resource limits for activities and parameters, and ensures system-level compliance for Windows file path formatting.

Key Features

01Strict control flow nesting validation for ForEach, If, Until, and Switch activities

02Resource limit tracking for pipeline activities, parameters, and batch counts

037 GitHub stars

04Standardized Execute Pipeline workaround patterns for prohibited nesting combinations

05Automated enforcement of Windows-specific backslash file path requirements

06Comprehensive authentication guidance for Azure Storage and SQL Linked Services

Use Cases

01Configuring secure Managed Identity or Service Principal authentication for Azure resources

02Validating pipeline JSON structures against ADF service limits before deployment

03Architecting complex ETL pipelines that require multi-level conditional logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josiahsiegel/claude-plugin-marketplace adf-validation-rules

For use in Claude.ai and ChatGPT

Download Skill