Understand Your Microsoft Fabric Lakehouse at a Glance

Build a clearer workflow for Microsoft Fabric Lakehouse: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Microsoft Fabric Lakehouse Features Download Microsoft Fabric Lakehouse JDBC Driver · All drivers

What happens after you download?

Get to your first Microsoft Fabric Lakehouse schema diagram in minutes. No account, no credit card.

Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

Connect to Microsoft Fabric Lakehouse or open a sample

Reverse engineer an existing Microsoft Fabric Lakehouse database or open a sample model to explore tables, relationships, and indexes.

Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

Connecting to Fabric Lakehouse via the SQL Analytics Endpoint

Microsoft Fabric Lakehouse stores data as Delta Parquet files and exposes them for SQL queries through a SQL Analytics Endpoint — a read-oriented T-SQL interface backed by automatic metadata registration. DbSchema connects to this endpoint, introspects the available tables and views, and renders the lakehouse schema as an ER diagram. This gives data engineers and architects a structured, navigable view of the lakehouse data model that the Fabric portal's table list does not provide, and makes it straightforward to understand table relationships across a large lakehouse.

Download DbSchema Free See Microsoft Fabric Lakehouse Features

Visualize and Design Lakehouse Schemas

DbSchema renders Fabric Lakehouse tables as entities on a diagram canvas, showing columns, data types, and relationships. Engineers can use this view to draft schema designs and document the intended structure before implementing changes through the Fabric portal.

Visualizing Microsoft Fabric Lakehouse table schemas in DbSchema

Build and Run T-SQL Queries Against the Lakehouse

The visual query builder generates T-SQL compatible with the SQL Analytics Endpoint, letting analysts join lakehouse tables, apply column filters, and retrieve results from Delta Parquet data without writing SQL. Queries execute against the endpoint and results display in the integrated data grid.

Running T-SQL queries on Microsoft Fabric Lakehouse via the DbSchema query builder

Document the Lakehouse Data Model

DbSchema produces HTML schema documentation from the Fabric Lakehouse metadata — including table definitions, column types, and ER diagrams — suitable for sharing with stakeholders and for maintaining data governance records without requiring live Fabric workspace access.

Auto-generated Microsoft Fabric Lakehouse schema documentation in DbSchema

Setting Up DbSchema's Fabric Lakehouse Connection

Reaching a live Fabric Lakehouse diagram takes these steps:

Get DbSchema installed — it is free, with no account required.
Start a new connection and choose SQL Server as the driver type; DbSchema downloads the SQL Server JDBC driver automatically, since that is what the SQL Analytics Endpoint speaks.
Enter the JDBC URL jdbc:sqlserver://workspace-id.datawarehouse.pbidedicated.windows.net:1433;database=LakehouseName, substituting your workspace ID and lakehouse name.
Append ;authentication=ActiveDirectoryPassword to the URL and provide your Azure Active Directory username and password.
Connect — DbSchema introspects the available tables and views and renders the schema as an ER diagram.

Because the SQL Analytics Endpoint is primarily read-oriented, schema modifications such as creating or altering tables must be performed through the Fabric portal rather than through DbSchema's synchronization tool.

Why Fabric Lakehouse Teams Add DbSchema

Visualize the SQL Analytics Endpoint schema as a navigable ER diagram
Run T-SQL queries on Delta Parquet data from a standalone desktop client
Document the lakehouse data model for governance and onboarding purposes
Draft schema designs locally before implementing them through the Fabric portal
Give analysts a query interface without requiring Fabric workspace membership

Instead of clicking through the Fabric portal's table list, see the whole lakehouse structure at once. Download DbSchema and diagram your Fabric Lakehouse in minutes, free of charge.

Teams working with Microsoft Fabric Lakehouse often use these engines too. Explore dedicated guides and JDBC setup for each.