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

•

云基础设施

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.

主要功能

Strict control flow nesting validation for ForEach, If, Until, and Switch activities
Resource limit tracking for pipeline activities, parameters, and batch counts
7 GitHub stars
Standardized Execute Pipeline workaround patterns for prohibited nesting combinations
Automated enforcement of Windows-specific backslash file path requirements
Comprehensive authentication guidance for Azure Storage and SQL Linked Services

使用场景

Configuring secure Managed Identity or Service Principal authentication for Azure resources
Validating pipeline JSON structures against ADF service limits before deployment
Architecting complex ETL pipelines that require multi-level conditional logic

关于

主要功能

Strict control flow nesting validation for ForEach, If, Until, and Switch activities
Resource limit tracking for pipeline activities, parameters, and batch counts
7 GitHub stars
Standardized Execute Pipeline workaround patterns for prohibited nesting combinations
Automated enforcement of Windows-specific backslash file path requirements
Comprehensive authentication guidance for Azure Storage and SQL Linked Services

使用场景

Configuring secure Managed Identity or Service Principal authentication for Azure resources
Validating pipeline JSON structures against ADF service limits before deployment
Architecting complex ETL pipelines that require multi-level conditional logic