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 connection60060 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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

Get tables

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