Azure Synapse Analytics

Supported Data warehouses & lakehouses

Catalog Synapse dedicated and serverless SQL pools with the SQL Server JDBC driver, with SQL lineage from views, procedures and query history.

Capabilities

CapabilitySupportNotes
Tables, views & columns Supported
Keys, constraints & indexes Partial
Procedures & functions Supported
Data lineage Supported
Lineage from query history Supported Statements collected from sys.dm_pdw_exec_requests.
Business glossary links Supported
Data quality probes Supported
Data profiling Supported
Data classification Supported
Chat with your data Supported

Connection settings

Create the connection on the Blindata Agent from Settings > Agents > Connections with the connection wizard, choosing Microsoft SQL Server in the technology step.

Driver classcom.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URLjdbc:sqlserver://<workspace>.sql.azuresynapse.net:1433;databaseName=<pool>;encrypt=true;
Authentication
Service principal (shared technical user)
User principal (personal credentials, BYOC)
Ephemeral credentials (asked at each run)
Crawling strategySQL

The driver is included in the Blindata Agent: no installation is needed. Driver properties can be added under Advanced settings in the connection wizard.

Prerequisites & permissions

  • A Blindata Agent installed with network access to Azure Synapse Analytics.
  • A database user with VIEW DEFINITION on the pool.
  • VIEW DATABASE STATE to read query history.
  • db_datareader for data quality, profiling and Chat with your data.

Set up metadata crawling

  1. Create the connection to Azure Synapse Analytics on the agent (see Connection settings) and use Test to verify it.
  2. Create or open the system that represents Azure Synapse Analytics in the catalog and link it to the connection.
  3. In the CRAWLING tab add a crawling job with strategy SQL.
  4. Run a TEST to check the number of extracted objects, then RUN or schedule the job.

The job options and the column aliases of every extraction query are described in the Generic JDBC reference.

Lineage from query history

The agent can periodically extract executed statements from Azure Synapse Analytics and send them to Blindata, where the SQL lineage engine turns them into dataflows. See the ready-made extraction query in Scheduling and statements extraction.

Updated on 16 Oct 2026