Compartir a través de

Azure SQL Data Warehouse

  • Reference

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)

Operation ID:
ExecutePassThroughNativeQueryV2

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

The outputs of this operation are dynamic.

Execute a SQL query [DEPRECATED]

Operation ID:
ExecutePassThroughNativeQuery

Execute a SQL query

Parameters

Name Key Required Type Description
Query
 query True dynamic

query body

Returns

The outputs of this operation are dynamic.

Execute stored procedure

Operation ID:
ExecuteProcedure

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

The outputs of this operation are dynamic.

Execute stored procedure (V2)

Operation ID:
ExecuteProcedureV2

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

The outputs of this operation are dynamic.

Get rows (V2)

Operation ID:
GetItemsV2

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

The outputs of this operation are dynamic.

Get rows [DEPRECATED]

Operation ID:
GetItems

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

The outputs of this operation are dynamic.

Get tables (V2)

Operation ID:
GetTablesV2

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]

Operation ID:
GetTables

This operation gets tables from a database.

Returns

Body
TablesList

Definitions

Table

Name Path Type Description
Name
 Name string
DisplayName
 DisplayName string

TablesList

Name Path Type Description
value
 value array of Table