How does this skill handle OneLake shortcuts?

It provides architectural patterns to reference data in ADLS Gen2 via shortcuts, enabling zero-copy data integration strategies within your ADF pipelines.

What authentication methods does this skill support?

The skill provides templates for both Service Principal and Managed Identity (System-assigned and User-assigned) authentication, following 2025 security best practices.

Can I use this for both Fabric Lakehouse and Warehouse?

Yes, it includes specific configurations for both, covering table and file operations in Lakehouses and T-SQL based workflows in Warehouses.

Are Windows file path requirements addressed?

Yes, the skill enforces a mandatory requirement to use backslashes (\) for all file path operations on Windows systems to ensure tool compatibility.

Microsoft Fabric & OneLake Integration

Name: Microsoft Fabric & OneLake Integration
Author: JosiahSiegel

byJosiahSiegel

•

云基础设施

Integrates Microsoft Fabric Lakehouse, Warehouse, and OneLake components into Azure Data Factory workflows using standardized 2025 implementation patterns.

关于

This skill provides specialized guidance for data engineers working with the Microsoft Fabric ecosystem within Azure Data Factory (ADF). it streamlines the configuration of Fabric Lakehouse and Warehouse connectors by providing production-ready JSON templates for linked services, datasets, and copy activities. Whether you are implementing Managed Identity authentication, orchestrating T-SQL scripts in a Fabric Warehouse, or utilizing OneLake shortcuts for zero-copy data architectures, this skill ensures your pipelines follow 2025 best practices for performance and security.

主要功能

OneLake shortcut integration patterns for zero-copy data access
Optimized Copy Activity configurations for bulk inserts and upserts
Managed Identity and Service Principal authentication patterns
7 GitHub stars
Native Fabric Lakehouse and Warehouse connector templates
Standardized JSON boilerplate for lookups, scripts, and stored procedures

使用场景

Synchronizing on-premises or cloud SQL data into Microsoft Fabric Lakehouses
Orchestrating complex T-SQL transformations within a Fabric Warehouse
Implementing modern data mesh architectures using OneLake shortcuts and ADF

关于

主要功能

OneLake shortcut integration patterns for zero-copy data access
Optimized Copy Activity configurations for bulk inserts and upserts
Managed Identity and Service Principal authentication patterns
7 GitHub stars
Native Fabric Lakehouse and Warehouse connector templates
Standardized JSON boilerplate for lookups, scripts, and stored procedures

使用场景

Synchronizing on-premises or cloud SQL data into Microsoft Fabric Lakehouses
Orchestrating complex T-SQL transformations within a Fabric Warehouse
Implementing modern data mesh architectures using OneLake shortcuts and ADF