Microsoft Fabric Data Warehouse with DBine

How to connect DBine to Microsoft Fabric Data Warehouse and what you can do once it's connected. This page is written from what the Microsoft Fabric Data Warehouse driver says about itself, so it matches the version of DBine you download.

Connect

In DBine, open New connection.
Pick Microsoft Fabric Data Warehouse in the list of engines.
Fill in the fields below, press Test connection and then Save.

Default port: 1433.

General

Field	Description
Server required	The warehouse's “SQL connection string” (Settings → Connection strings). Example: `xxxxxxxx.datawarehouse.fabric.microsoft.com`
Port	Example: `1433`
Database required	The name of the warehouse or SQL endpoint. Example: `MyWarehouse`
Authentication	Interactive Entra ID opens the browser and supports MFA; with user and password there is no MFA. Integrated uses the Windows session (or the Kerberos ticket) with the organization's ADFS. Managed identity only works if DBine runs in Azure. Default tries, in order, the variables AZURE_TENANT_ID/AZURE_CLIENT_ID/AZURE_CLIENT_SECRET, managed identity, Azure CLI (az login) and Azure Developer CLI (azd auth login). Options: Microsoft Entra ID: interactive (MFA), Microsoft Entra ID: user and password, Microsoft Entra ID: integrated (Windows), Microsoft Entra ID: service principal, Microsoft Entra ID: managed identity, Microsoft Entra ID: default, Microsoft Entra ID: access token Default: `Microsoft Entra ID: user and password`
User	The Entra ID account (user@domain): required with integrated, optional with interactive. Only with Authentication: sql, Microsoft Entra ID: user and password, windows_ntlm, Microsoft Entra ID: interactive (MFA), Microsoft Entra ID: integrated (Windows).
Password	Kept in the system keychain, never in DBine's files. Only with Authentication: sql, Microsoft Entra ID: user and password, windows_ntlm.
Tenant (tenant ID)	Required for the service principal. With the other methods, optional: without it, the account's tenant is used. Example: `00000000-0000-0000-0000-000000000000 or contoso.onmicrosoft.com` Only with Authentication: Microsoft Entra ID: user and password, Microsoft Entra ID: service principal, Microsoft Entra ID: interactive (MFA), Microsoft Entra ID: integrated (Windows), Microsoft Entra ID: default.
Application ID (client ID)	Service principal: the registered application's ID. Managed identity (also in default): the client ID of a user-assigned identity; empty for the system-assigned one. Otherwise, optional. Only with Authentication: Microsoft Entra ID: user and password, Microsoft Entra ID: service principal, Microsoft Entra ID: interactive (MFA), Microsoft Entra ID: integrated (Windows), Microsoft Entra ID: managed identity, Microsoft Entra ID: default.
Application secret	Kept in the system keychain, never in DBine's files. Only with Authentication: Microsoft Entra ID: service principal.
Access token	A token for https://database.windows.net/ (for example, from `az account get-access-token --resource https://database.windows.net/`). It expires in one hour. Only with Authentication: Microsoft Entra ID: access token.
Read-only	On or off.

SSH tunnel. The connection can go through an SSH server, even through a chain of bastions, with a password, a private key or the SSH agent. The server's fingerprint is checked against known_hosts or confirmed the first time.

What the explorer shows

Under the connection: Databases, each with its schemas. Inside each one:

Tables
Views
Procedures
Functions

Query editor

The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.

Ready-made templates for new objects:

New view
New procedure
New function

Tools for Microsoft Fabric Data Warehouse

Available

Graphical execution plans
Live query profiler
Server monitor
Sessions and running queries
End a session
Manual transactions (commit and rollback)
Relations in the ER diagram
Visual designer for new objects
Rename objects
Compare and sync schemas
Users and permissions

Not available for Microsoft Fabric Data Warehouse

Locks: who blocks whom
Cancel another session's query from the sessions list
Index usage
Create databases
Drop databases
Database properties
Clone tables
Native bulk load when migrating data
Backups

Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.

Generated from the Microsoft Fabric Data Warehouse driver 0.1.15, which DBine downloads the first time you connect to Microsoft Fabric Data Warehouse.

Download DBine All engines