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 except the following: - US Government (GCC High) |
| 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/ |
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
Creating a connection
The connector supports the following authentication types:
| Default | Required parameters for creating connection. | All regions |
Default
Applicable: All regions
Required parameters for creating connection.
| Name | Type | Description |
|---|---|---|
| Azure SQL Data Warehouse server name | string | Azure SQL Data Warehouse server name |
| Azure SQL Data Warehouse database name | string | Azure SQL Data Warehouse database name |
| 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 |
| Password | securestring | Password credential |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 600 | 60 seconds |
Actions
| Execute a SQL query |
Execute a SQL query |
| Execute stored procedure |
This operation runs a stored procedure. |
| Get rows |
This operation gets rows from a table. |
| Get tables |
This operation gets tables from a database. |
Execute a SQL query
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
Get rows
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
Definitions
Table
| Name | Path | Type | Description |
|---|---|---|---|
|
Name
|
Name | string | |
|
DisplayName
|
DisplayName | string |
TablesList
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value | array of Table |