How does this skill handle ADF nesting limits?

It identifies prohibited combinations, such as nesting a ForEach inside an If condition, and suggests the Execute Pipeline pattern as a workaround to enable deeper logic levels.

What resource limits does it track?

It monitors pipeline-specific limits including the 80-activity maximum, 50-parameter cap, and Lookup activity data size constraints (5,000 rows/4MB).

Can this skill help with Windows development environments?

Yes, it automatically enforces the use of backslashes for file paths on Windows systems to ensure Edit and Write tools function correctly.

Does it support Managed Identity for storage connections?

Yes, it provides specific configuration requirements for Managed Identity, including the mandatory accountKind settings to prevent Data Flow failures.

Azure Data Factory Validator

Name: Azure Data Factory Validator
Author: JosiahSiegel

byJosiahSiegel

•

Cloud Infrastructure

Enforces Azure Data Factory validation rules, activity nesting limits, and linked service best practices during pipeline development.

About

The Azure Data Factory (ADF) Validator skill provides deep domain expertise to prevent common deployment errors and architectural pitfalls. It enforces strict nesting rules for control flow activities, offers 'Execute Pipeline' workarounds for prohibited nesting combinations, and ensures that resource limits like activity counts and lookup sizes are respected. Beyond logic validation, the skill guides users through secure authentication configurations for Azure Blob Storage and SQL Database, while also maintaining environment-specific standards like Windows file path conventions and clean documentation practices.

Key Features

Guides 'Execute Pipeline' patterns to bypass nesting limitations
Enforces ADF resource limits including activity counts and timeout settings
Validates activity nesting logic for ForEach, If, Switch, and Until containers
1 GitHub stars
Configures secure Linked Service authentication (Managed Identity, SPN, SAS)
Standardizes Windows file path conventions using backslashes for tool compatibility

Use Cases

Developing complex data orchestration pipelines with multi-level conditional logic
Troubleshooting and refactoring ADF JSON definitions that exceed resource limits
Configuring secure storage and database connections following Azure best practices

About

Key Features

Guides 'Execute Pipeline' patterns to bypass nesting limitations
Enforces ADF resource limits including activity counts and timeout settings
Validates activity nesting logic for ForEach, If, Switch, and Until containers
1 GitHub stars
Configures secure Linked Service authentication (Managed Identity, SPN, SAS)
Standardizes Windows file path conventions using backslashes for tool compatibility

Use Cases

Developing complex data orchestration pipelines with multi-level conditional logic
Troubleshooting and refactoring ADF JSON definitions that exceed resource limits
Configuring secure storage and database connections following Azure best practices