Amazon Redshift (Preview)
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service from Amazon. Connect to Amazon Redshift database to read data from tables.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://aws.amazon.com/redshift/ |
Privacy policy | https://aws.amazon.com/privacy/ |
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Shareable |
Applicable: All regions
Parameters for creating connection.
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 |
---|---|---|---|
Server | string | Specify the server in the format [:] | True |
Database Name | string | Specify the database name. Eg. dev | True |
Authentication Type [Select Basic] | string | Authentication type to connect to your database | |
Username | securestring | Username credential | True |
Password | securestring | Password credential | True |
Encrypt Connection | bool | Encrypt Connection |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 300 | 60 seconds |
Get row |
This operation gets a row from a table. |
Get rows |
This operation gets rows from a table. |
Get tables |
This operation gets tables from a database. |
This operation gets a row from a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Name of schema
|
dataset | True | string |
Name of schema |
Name of table
|
table | True | string |
Name of table |
Unique identifier of the row to retrieve
|
id | True | string |
Unique identifier of the row to retrieve |
Returns
This operation gets rows from a table.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Name of schema
|
dataset | True | string |
Name of schema |
Name of table
|
table | True | string |
Name of table |
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries. |
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all). |
|
Skip Count
|
$skip | integer |
The number of entries to skip (default = 0). |
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all). |
Returns
This operation gets tables from a database.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Schema name
|
dataset | True | string |
Name of schema |
Returns
Represents a list of tables.
- Body
- TablesList
Represents a table.
Name | Path | Type | Description |
---|---|---|---|
Name
|
Name | string |
The name of the table. The name is used at runtime. |
DisplayName
|
DisplayName | string |
The display name of the table. |
Represents a list of tables.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Table |
List of Tables |