skills.rest
JosiahSiegel
JosiahSiegelCOMMUNITY
Explore all skills by this author →
GitHub

fabric-onelake-2025

...

51|10|Updated Oct 22, 2025
Search Tags:#data integration#warehouse#lakehouse#onelake#microsoft fabric#azure data factory
One-click install
npx skills add https://github.com/JosiahSiegel/claude-plugin-marketplace --skill fabric-onelake-2025
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-onelake-2025
Source: https://github.com/JosiahSiegel/claude-plugin-marketplace/tree/main/plugins/adf-master/skills/fabric-onelake-2025
Command: npx skills add https://github.com/JosiahSiegel/claude-plugin-marketplace --skill fabric-onelake-2025

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies the integration of Azure Data Factory with Microsoft Fabric's Lakehouse and Warehouse, enabling efficient data movement and transformation.

Core Features & Use Cases

  • Fabric Lakehouse Connector: Read and write data to Fabric Lakehouse tables and files.
  • Fabric Warehouse Connector: Load data into Fabric Warehouses using T-SQL capabilities.
  • OneLake Integration: Leverage OneLake shortcuts for zero-copy data access.
  • Use Case: Automate the incremental loading of sales data from an on-premises SQL Server into a Fabric Lakehouse for real-time analytics.

Quick Start

Use the fabric-onelake-2025 skill to configure a linked service for Fabric Lakehouse using managed identity authentication.

Frequently Asked Questions about fabric-onelake-2025

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I integrate Azure Data Factory with Microsoft Fabric Lakehouse for data ingestion?▼

To configure a Fabric Lakehouse linked service in Azure Data Factory, use managed identity or service principal authentication to securely connect and facilitate data movement into your Lakehouse tables.

Can I use managed identity authentication for Azure Data Factory connections to Fabric Warehouse?▼

Yes, managed identity authentication is fully supported for connecting Azure Data Factory to Fabric Warehouse, allowing you to securely load data using T-SQL capabilities and script execution.

What is the best way to automate incremental loads from on-premises SQL Server to OneLake?▼

The best way to automate incremental loads to OneLake is by using Azure Data Factory copy activities and lookup patterns to move data into Fabric Lakehouse, leveraging OneLake shortcuts for zero-copy data access.

Does Azure Data Factory support T-SQL script execution for data transformation in Fabric Warehouse?▼

Yes, Azure Data Factory supports T-SQL script execution within Fabric Warehouses, enabling you to load data and perform transformations directly against the Warehouse using pipeline orchestration.

How do OneLake shortcuts handle zero-copy data access when integrating with Azure Data Factory?▼

OneLake shortcuts provide zero-copy data access by referencing data in place without duplication, which Azure Data Factory leverages during data ingestion and transformation pipelines across Fabric Lakehouse and Warehouse.

Related Skills

Explore More Data & Analytics Skills→
microsoftmicrosoft
952

sqldw-consumption-cli

Query read-only T-SQL against Fabric Data Warehouse, Lakehouse, and Mirrored Databases via CLI.

Official
Intermediate
ThomazRossitoThomazRossito
31

Microsoft Fabric Lakehouse — Medallion Architecture

Design and implement a Medallion Lakehouse pattern in Microsoft Fabric.

Community
Advanced
weiflycc-cmdweiflycc-cmd

synapse-migration

Automate Azure Synapse Analytics workload migration to Microsoft Fabric.

Community
Intermediate
markus41markus41
12

Fabric Data Factory

Automate end-to-end data integration and orchestration in Microsoft Fabric Data Factory.

Community
Advanced