Skip to content

Microsoft Fabric / Azure Synapse

Live, over the same protocol as SQL Server.

How it connects
Live, over the same protocol as SQL Server. On Fabric it signs in with a Microsoft Entra app; on Synapse, with an Entra app or a SQL user. It does not store the data: it reads it where it lives.
What it reads
The warehouse's tables, views, external tables and procedures. Declared keys are shown, though the warehouse does not enforce them. Missing ones are only proposed for a person to review, based on the joins in views and the query history.
Which account it needs
The Entra app with read-only access to the warehouse (Read permission and SELECT) or, on Synapse, a read-only SQL user.
Can it write?
No: it is read-only.

Shall we connect it in your company?

We tell you what your case needs and leave it running on your server.