synapse-migration

Migrate Azure Synapse Spark workspaces into Microsoft Fabric with validation and reporting.

3|6|Updated Jun 21, 2024
One-click install
npx skills add https://github.com/rritec/Microsoft-Fabric --skill synapse-migration-rritec
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: synapse-migration
Source: https://github.com/rritec/Microsoft-Fabric/tree/main/skills/plugins/fabric-skills/skills/synapse-migration
Command: npx skills add https://github.com/rritec/Microsoft-Fabric --skill synapse-migration-rritec

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill turns a Microsoft Synapse Spark workspace migration into a structured Fabric workflow, reducing manual rewrites, broken bindings, and post-cutover surprises.

Core Features & Use Cases

  • Workspace migration: Inventory Spark pools, lake databases, notebooks, and Spark Job Definitions, then map them into Fabric Environments, Lakehouses, Notebooks, and SJDs.
  • Code and connectivity refactoring: Replace mssparkutils with notebookutils, remap linked services to Data Connections or OneLake Shortcuts, and handle synapsesql, Kusto, Cosmos DB, and ADLS OAuth changes.
  • Validation and reporting: Validate environments, shortcuts, row counts, notebook execution, and migration readiness, then generate a migration report with Fabric portal links.
  • Use case: Move an enterprise Synapse workspace using either lift-and-shift or migrate-and-modernize guidance, with guardrails for external Hive Metastore, library incompatibilities, and GPU blockers.

Quick Start

Ask this skill to migrate a Synapse workspace to Microsoft Fabric and specify whether you want lift-and-shift or migrate-and-modernize.

Frequently Asked Questions about synapse-migration

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

FAQPage Schema
How do I migrate Azure Synapse Spark workspaces to Microsoft Fabric?

Migrate Azure Synapse Spark workspaces to Microsoft Fabric by inventorying Spark pools, lake databases, notebooks, and Spark Job Definitions, then mapping them into Fabric Environments, Lakehouses, and SJDs. Choose either lift-and-shift or migrate-and-modernize workflows.

What is the best way to replace mssparkutils when moving notebooks to Fabric?

The best way to replace mssparkutils when moving notebooks to Fabric is through code refactoring to notebookutils. This process also remaps linked services to Data Connections or OneLake Shortcuts to maintain connectivity.

Can I migrate Synapse Spark Job Definitions and lake databases directly into Fabric?

Yes, you can migrate Synapse Spark Job Definitions and lake databases directly into Fabric. The migration workflow inventories these components via REST APIs and maps them into corresponding Fabric Lakehouses and SJDs.

Does Synapse to Fabric migration handle external Hive Metastore and library incompatibilities?

Synapse to Fabric migration handles external Hive Metastore and library incompatibilities by applying lift-and-shift or migrate-and-modernize guardrails, preventing post-cutover surprises and broken bindings.

How do I validate a Synapse to Fabric workspace migration?

Validate a Synapse to Fabric workspace migration by checking environments, shortcuts, row counts, and notebook execution. The process assesses migration readiness and generates a report with Fabric portal links.

What data connectors are supported during Synapse Spark to Fabric migration?

Data connectors supported during Synapse Spark to Fabric migration include synapsesql, Kusto, Cosmos DB, and ADLS. The workflow refactors these connectors to handle OAuth changes and map them to Fabric Data Connections.