Azure Synapse
Connect to Azure Synapse Analytics dedicated SQL pools or serverless SQL pools.
Connection Properties
| Property | Description |
|---|---|
| Workspace Name | Your Synapse workspace name. |
| SQL Pool Name | The dedicated SQL pool name, or Built-in for the serverless pool. |
| Database | The database name. |
| Username | SQL login username (only for SQL Auth). |
| Password | SQL login password (only for SQL Auth). |
Authentication Methods
- Entra ID (MFA): Signs in with your Microsoft account. Works on all platforms.
- SQL Authentication: Username and password.
Tips
- For serverless SQL pools, set the SQL Pool Name to
Built-in. - Ensure your account has the necessary permissions on the Synapse workspace.