Fabric Data Engineering VS Code
ExtensionFreeMicrosoft Fabric VS Code experience for Data engineering and Data science of Microsoft Fabric (Previously Synapse VS Code)
Capabilities11 decomposed
remote-spark-notebook-execution-with-local-editing
Medium confidenceEnables developers to author Jupyter notebooks locally in VS Code while executing code cells against remote Microsoft Fabric Spark pools, with bidirectional synchronization of notebook state and output. The extension intercepts notebook cell execution requests, serializes them to the remote Spark cluster via the Fabric platform API, and streams execution results back to the local notebook interface for real-time display.
Integrates VS Code's native Jupyter notebook editor with Microsoft Fabric's remote Spark execution backend, enabling seamless local-to-remote development without file uploads or platform-specific IDEs. Uses VS Code's notebook API to intercept cell execution and route to Fabric Spark pools via authenticated platform APIs.
Tighter integration with VS Code's notebook UX than Fabric's web UI, and lower friction than Synapse Studio for developers already using VS Code, but limited to Fabric platform (no multi-cloud support like Databricks Connect)
lakehouse-structure-exploration-and-table-inspection
Medium confidenceProvides a sidebar explorer view that displays the hierarchical structure of connected Fabric Lakehouses, allowing developers to browse tables, folders, and metadata without leaving VS Code. The extension queries Fabric platform metadata APIs to populate a tree view of lakehouse assets and enables inline table data preview and schema inspection through context menu actions.
Embeds Fabric Lakehouse metadata browsing directly in VS Code's sidebar explorer, eliminating context switching to the web UI. Uses Fabric platform metadata APIs to populate a lazy-loaded tree view with on-demand table preview and schema inspection.
More integrated into the development workflow than Fabric web UI, but less feature-rich than Fabric Studio's data exploration tools (no advanced filtering, statistics, or data profiling)
jupyter-notebook-format-compatibility-and-conversion
Medium confidenceHandles conversion and compatibility between standard Jupyter notebook format (.ipynb) and Fabric Notebook format, enabling seamless editing of Fabric notebooks in VS Code's native Jupyter editor. The extension transparently converts between formats during load/save operations, preserving cell metadata, execution state, and Fabric-specific properties.
Transparently handles format conversion between standard Jupyter and Fabric notebook formats, enabling seamless editing in VS Code's native Jupyter editor. Conversion occurs automatically during load/save without user intervention.
More transparent than manual format conversion tools, but conversion fidelity unknown compared to Fabric's native notebook editor
spark-job-definition-development-and-remote-execution
Medium confidenceAllows developers to create, edit, and execute Spark Job Definitions (compiled Spark applications) locally in VS Code, with deployment and execution against remote Fabric Spark pools. The extension provides syntax highlighting and validation for job definition files, handles packaging and submission to the Fabric platform, and streams job execution logs back to the VS Code terminal.
Integrates Spark Job Definition development into VS Code's editor and command palette, providing local editing with remote execution and log streaming. Handles job packaging and submission to Fabric platform APIs without requiring manual deployment steps.
More integrated into VS Code workflow than Fabric web UI, but lacks the visual job monitoring and scheduling features of Fabric Studio or Databricks Jobs UI
remote-spark-notebook-debugging-with-breakpoints
Medium confidenceEnables developers to set breakpoints in notebook cells and debug code execution on remote Spark pools, with variable inspection and step-through execution. The extension uses VS Code's debug protocol to communicate with the remote Spark cluster's debug server, mapping local breakpoints to distributed execution contexts and streaming variable state back to the debugger UI.
Extends VS Code's native debugging UI to remote Spark execution contexts, mapping local breakpoints to distributed driver/executor processes. Uses Spark cluster debug server integration to stream variable state and execution context back to VS Code debugger.
More integrated debugging experience than Fabric web UI, but limited to driver-side debugging compared to distributed tracing tools like Spark UI or cloud-native observability platforms
fabric-workspace-and-spark-pool-connection-management
Medium confidenceProvides configuration and connection management for Microsoft Fabric workspaces and Spark pools through VS Code settings and command palette, handling authentication, workspace selection, and pool configuration. The extension stores connection credentials securely using VS Code's credential storage API and manages active connections for notebook and job execution.
Integrates Fabric workspace and Spark pool connection management into VS Code's settings and command palette, using VS Code's native credential storage for secure authentication. Abstracts Fabric authentication complexity behind simple workspace/pool selection UI.
More seamless than manual credential configuration, but less flexible than Fabric CLI for advanced authentication scenarios (service principals, managed identity)
notebook-synchronization-between-local-and-remote-fabric
Medium confidenceAutomatically synchronizes notebook content between local VS Code workspace and remote Fabric platform, ensuring consistency across development and execution environments. The extension detects local notebook changes, uploads them to Fabric, and pulls remote updates (from collaborative edits or platform changes) back to the local workspace using a merge-based synchronization strategy.
Provides transparent bidirectional synchronization between local VS Code notebooks and remote Fabric platform, enabling local development workflows with remote execution. Uses file system watchers and Fabric API polling to detect and propagate changes.
More transparent than manual upload/download workflows, but less sophisticated than Git-based collaboration tools (no branching, merging, or conflict resolution UI)
syntax-highlighting-and-language-support-for-fabric-artifacts
Medium confidenceProvides syntax highlighting, code completion, and language support for Fabric-specific file formats (notebooks, Spark job definitions, Lakehouse metadata) within VS Code's editor. The extension registers custom language modes and uses TextMate grammars or language server protocols to enable intelligent code editing for PySpark, Scala, and SQL within Fabric contexts.
Integrates Fabric-specific syntax highlighting and code completion into VS Code's editor, providing language support tailored to Fabric notebook and job definition formats. Uses TextMate grammars and optional language server integration for intelligent code assistance.
More integrated into VS Code than Fabric web editor, but less feature-rich than full-featured IDEs like PyCharm or IntelliJ with Spark plugins
fabric-platform-command-palette-integration
Medium confidenceExposes Fabric platform operations (workspace selection, job submission, notebook execution, data exploration) through VS Code's command palette, enabling keyboard-driven workflows without UI navigation. The extension registers custom commands that map to Fabric platform APIs and execute asynchronously, with progress indicators and result notifications in VS Code's status bar.
Exposes Fabric platform operations through VS Code's command palette, enabling keyboard-driven workflows and integration with VS Code's automation systems. Commands are registered dynamically based on active Fabric connection and available resources.
More keyboard-efficient than web UI navigation, but less discoverable than GUI menus for new users unfamiliar with command names
telemetry-collection-with-user-opt-out
Medium confidenceCollects usage telemetry data (command execution, feature usage, error rates) and sends it to Microsoft for product improvement, with a user-configurable opt-out setting. The extension respects VS Code's telemetry framework and allows disabling data collection via the `telemetry.enableTelemetry` setting without affecting core functionality.
Integrates with VS Code's standard telemetry framework, allowing users to disable data collection via a single setting while maintaining extension functionality. Follows Microsoft's privacy practices for VS Code extensions.
Transparent opt-out mechanism consistent with VS Code ecosystem, but less granular than some third-party tools offering per-feature telemetry control
theme-and-keybinding-customization-for-fabric-development
Medium confidenceProvides custom VS Code themes and keybinding presets optimized for Fabric data engineering workflows, including color schemes for notebook cells, Spark output, and Lakehouse explorer. The extension registers theme contributions and keybinding configurations that can be selected via VS Code's preferences, with support for user customization and extension of default bindings.
Provides Fabric-specific VS Code themes and keybindings optimized for data engineering workflows, with support for user customization. Themes are registered as VS Code theme contributions and can be selected via preferences.
More integrated into VS Code than standalone theme tools, but less flexible than manual theme editing for advanced customization
Capabilities are decomposed by AI analysis. Each maps to specific user intents and improves with match feedback.
Related Artifactssharing capabilities
Artifacts that share capabilities with Fabric Data Engineering VS Code, ranked by overlap. Discovered automatically through the match graph.
Open Notebook
An open source implementation of NotebookLM with more flexibility and features. [#opensource](https://github.com/lfnovo/open-notebook)
Jupyter
Full Jupyter notebook support in VS Code.
Juno
Enhances Python coding with AI in Jupyter...
Hex
Collaborative data workspace with AI-powered analysis.
DataLab
Transform data science with AI analytics, collaboration, and machine learning...
Hex
AI-powered collaborative data workspace
Best For
- ✓data engineers building ETL pipelines on Microsoft Fabric
- ✓teams collaborating on shared Spark clusters with local development workflows
- ✓organizations standardized on VS Code for data engineering work
- ✓data engineers exploring unfamiliar Fabric Lakehouses
- ✓teams building data pipelines who need quick schema reference during development
- ✓analysts discovering available datasets for analysis
- ✓data engineers transitioning from standard Jupyter to Fabric notebooks
- ✓teams sharing notebooks across Jupyter and Fabric ecosystems
Known Limitations
- ⚠Requires active network connection to Microsoft Fabric platform — no offline notebook editing or local Spark execution fallback
- ⚠Notebook format must be compatible with Fabric Notebooks; standard Jupyter .ipynb compatibility unknown
- ⚠Remote execution latency adds 500ms–2s per cell execution depending on cluster startup state and network conditions
- ⚠Debugging requires remote Spark pool support; local breakpoints may not map correctly to distributed execution context
- ⚠Metadata refresh rate unknown — may not reflect real-time changes to lakehouse structure
- ⚠Table preview limited to sample rows (exact row count limit not documented)
Requirements
Input / Output
UnfragileRank
UnfragileRank is computed from adoption signals, documentation quality, ecosystem connectivity, match graph feedback, and freshness. No artifact can pay for a higher rank.
About
Microsoft Fabric VS Code experience for Data engineering and Data science of Microsoft Fabric (Previously Synapse VS Code)
Categories
Alternatives to Fabric Data Engineering VS Code
Are you the builder of Fabric Data Engineering VS Code?
Claim this artifact to get a verified badge, access match analytics, see which intents users search for, and manage your listing.
Get the weekly brief
New tools, rising stars, and what's actually worth your time. No spam.
Data Sources
Looking for something else?
Search →