Microsoft Fabric

Microsoft Fabric is a unified analytics platform that brings together data warehousing, data engineering, data science, and real-time analytics into a single SaaS experience.

Overview

Microsoft Fabric is a unified analytics platform that combines data movement, data lakes, data engineering, data integration, data science, real-time analytics, and business intelligence:

  • OneLake: A single, unified data lake for your entire organization
  • SQL Endpoints: Query lakehouse and warehouse data using familiar T-SQL
  • Data Warehouse: Full read-write SQL warehouse with ACID transactions
  • Lakehouse: Combine the best of data lakes and data warehouses with Delta Lake format
  • Real-time Analytics: Stream and analyze data in real time

Microsoft Fabric is ideal for organizations looking to consolidate their analytics workloads into a single, integrated platform on Azure.

Connecting

To connect to Microsoft Fabric in DBCode, you’ll need:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Complete connection form: Select Microsoft Fabric as the database type and enter:
    • Host (your Fabric SQL endpoint, e.g., your-workspace.fabric.microsoft.com)
    • Authentication (Microsoft Entra ID or SQL Server Authentication)
    • Database name (optional)
  4. Connect: Click save to connect to your Fabric workspace.
  5. Start Managing Your Data: Explore databases, schemas, tables, and run queries.

For detailed instructions on connecting to Microsoft Fabric, refer to the Connect article.

Authentication Methods

DBCode supports two authentication methods for Microsoft Fabric:

Microsoft Entra ID

Use your organizational Microsoft Entra ID credentials for secure, token-based authentication to your Fabric workspace.

SQL Server Authentication

Use a SQL username and password to connect to your Fabric SQL endpoints.

Microsoft Fabric Features in DBCode

DBCode enhances your Microsoft Fabric development experience with:

  • Schema browsing: Navigate through databases, schemas, tables, and views
  • SQL editing: Write and execute T-SQL queries with syntax highlighting and autocomplete
  • Data preview: Quickly view and explore data from Fabric tables
  • Warehouse and Lakehouse support: Connect to both Fabric Warehouse and Lakehouse SQL endpoints
  • Full DDL support: View and manage table definitions, views, and stored procedures

By using Microsoft Fabric with DBCode, you can efficiently develop SQL queries, explore your data warehouse, and manage your Fabric objects directly within Visual Studio Code.

For more information about Microsoft Fabric, check out Microsoft Fabric.