Azure SQL Data Warehouse
Microsoft Azure SQL Data Warehouse is a relational database management system developed by Microsoft. Connect to Azure SQL Data Warehouse to view your data.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions and Integration Service Environments (ISEs) |
| Power Automate | Premium | All Power Automate regions |
| Power Apps | - | Not available |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://azure.microsoft.com/services/synapse-analytics/ |
Virtual Network support
When the connector is used in a Power Platform environment linked to a Virtual Network, limitations apply:
The following actions are the only supported actions:
Any action outside of this list will return a "403 Unauthorized" error
On-premise data gateway is not supported
When using Microsoft Entra ID Integrated authentication, please type in the database name manually as a Custom Value
Known issues and limitations
The followings are some of the known limitations of using Azure SQL Data Warehouse connector
- Due to the backend service limitation only the first 10000 tables are returned by 'Get tables' operation and pagination feature is not supported yet
Known limitations with Microsoft Entra ID authentication
Due to current authentication pipeline limitations, Microsoft Entra ID guest users aren't supported for Microsoft Entra ID connections to Azure SQL Data Warehouse. When using Microsoft Entra ID authentication only V2 actions are supported. Deprecated actions will continue to work with sql authentication, but will fail if used with an Microsoft Entra ID connection.
Creating a connection
The connector supports the following authentication types:
| Azure AD Integrated | Use Azure Active Directory to access your SQL pools. | MOONCAKE and US Government (GCC) only | Not shareable |
| Azure AD Integrated (Azure Government) | Use Azure Active Directory to access your SQL pools. | Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC-High) only | Not shareable |
| Basic username and password | The username and password and such | All regions | Shareable |
| Microsoft Entra ID Integrated | Use Microsoft Entra ID to access your SQL pools. | All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High) | Not shareable |
| Default [DEPRECATED] | This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. | All regions | Not shareable |
Azure AD Integrated
Auth ID: oauth
Applicable: MOONCAKE and US Government (GCC) only
Use Azure Active Directory to access your SQL pools.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Azure AD Integrated (Azure Government)
Auth ID: oauth
Applicable: Azure Government and Department of Defense (DoD) in Azure Government and US Government (GCC-High) only
Use Azure Active Directory to access your SQL pools.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Basic username and password
Auth ID: sqlAuthentication
Applicable: All regions
The username and password and such
This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs
| Name | Type | Description | Required |
|---|---|---|---|
| Azure SQL Data Warehouse server name | string | Azure SQL Data Warehouse server name | True |
| Azure SQL Data Warehouse database name | string | Azure SQL Data Warehouse database name | True |
| Authentication Type to connect to your Azure SQL Data Warehouse database | string | Authentication type to connect to your Azure SQL Data Warehouse database | |
| Username | securestring | Username credential | True |
| Password | securestring | Password credential | True |
Microsoft Entra ID Integrated
Auth ID: oauth
Applicable: All regions except Azure Government and Department of Defense (DoD) in Azure Government and MOONCAKE and US Government (GCC) and US Government (GCC-High)
Use Microsoft Entra ID to access your SQL pools.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Default [DEPRECATED]
Applicable: All regions
This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| Azure SQL Data Warehouse server name | string | Azure SQL Data Warehouse server name | True |
| Azure SQL Data Warehouse database name | string | Azure SQL Data Warehouse database name | True |
| Authentication Type to connect to your Azure SQL Data Warehouse database | string | Authentication type to connect to your Azure SQL Data Warehouse database | |
| Username | securestring | Username credential | True |
| Password | securestring | Password credential | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 600 | 60 seconds |
Actions
| Execute a SQL query (V2) |
Execute a SQL query |
| Execute a SQL query [DEPRECATED] |
Execute a SQL query |
| Execute stored procedure |
This operation runs a stored procedure. |
| Execute stored procedure (V2) |
This operation runs a stored procedure. |
| Get rows (V2) |
This operation gets rows from a table. |
| Get rows [DEPRECATED] |
This operation gets rows from a table. |
| Get tables (V2) |
This operation gets tables from a database. |
| Get tables [DEPRECATED] |
This operation gets tables from a database. |
Execute a SQL query (V2)
Execute a SQL query
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
server name of the database
|
server | True | string |
server name of the database |
|
name of the database
|
database | True | string |
name of the database |
|
Query
|
query | True | dynamic |
query body |
Returns
Execute a SQL query [DEPRECATED]
Execute a SQL query
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Query
|
query | True | dynamic |
query body |
Returns
Execute stored procedure
This operation runs a stored procedure.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Procedure name
|
procedure | True | string |
Name of stored procedure |
|
Parameters list
|
parameters | True | dynamic |
Input parameters to the stored procedure |
Returns
Execute stored procedure (V2)
This operation runs a stored procedure.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
server name of the database
|
server | True | string |
server name of the database |
|
name of the database
|
database | True | string |
name of the database |
|
Procedure name
|
procedure | True | string |
Name of stored procedure |
|
Parameters list
|
parameters | True | dynamic |
Input parameters to the stored procedure |
Returns
Get rows (V2)
This operation gets rows from a table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
server name of the database
|
server | True | string |
server name of the database |
|
name of the database
|
database | True | string |
name of the database |
|
Table name
|
table | True | string |
Name of SQL table |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned |
|
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries |
|
|
Skip Count
|
$skip | integer |
Number of entries to skip (default = 0) |
|
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all) |
|
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all) |
Returns
Get rows [DEPRECATED]
This operation gets rows from a table.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of SQL table |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned |
|
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries |
|
|
Skip Count
|
$skip | integer |
Number of entries to skip (default = 0) |
|
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all) |
|
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all) |
Returns
Get tables (V2)
This operation gets tables from a database.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
server name of the database
|
server | True | string |
server name of the database |
|
name of the database
|
database | True | string |
name of the database |
Returns
- Body
- TablesList
Get tables [DEPRECATED]
Definitions
Table
| Name | Path | Type | Description |
|---|---|---|---|
|
Name
|
Name | string | |
|
DisplayName
|
DisplayName | string |
TablesList
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value | array of Table |