Azure Synapse Analytics
Connect Microsoft Azure Synapse Analytics to Lakehousecat using a connection URI. Azure Synapse uses the SQL Server wire protocol — the connection is established the same way as a Microsoft SQL Server connection.
Connection Fields
| Field | Required | Description |
|---|---|---|
| Connection URI | Yes | Full connection string including credentials, host, port, and database name. Example: azuresynapse://user:password@workspace.sql.azuresynapse.net:1433/mydb |
| Use SSH | No | Enable if the workspace endpoint is accessible only via an SSH bastion host. When enabled, SSH settings fields appear: Host, Port, Username, Password, Private Key, and Private Key Passphrase. See SSH Tunneling. |
Prerequisites
- Admin or Builder role in Lakehousecat
- An Azure Synapse Analytics workspace with a dedicated SQL pool or serverless SQL endpoint
- A SQL login with read access to the schemas and tables you want to expose
- Network connectivity from the Lakehousecat backend to the Synapse endpoint (direct or via SSH)
Notes
- Azure Synapse Analytics uses the same SQL Server wire protocol as Microsoft SQL Server. The connection URI scheme
azuresynapse://is normalized internally. - Use a read-only login to follow the principle of least privilege.
- For large warehouses, configure schema and table filters in the Filters tab after creation to limit the scope of semantic extraction.
- Serverless SQL pools and dedicated SQL pools are both supported via the same connection method.
Next Steps
After creating the datasource, go to the Operations tab to trigger semantic extraction.