Partilhar via

Amazon Redshift (Preview)

  • Reference

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/

Creating a connection

The connector supports the following authentication types:
Default Parameters for creating connection. All regions Shareable

Default

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

Throttling Limits

Name Calls Renewal Period
API calls per connection 300 60 seconds

Actions

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.

Get row

Operation ID:
GetItem

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

The outputs of this operation are dynamic.

Get rows

Operation ID:
GetItems

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

The outputs of this operation are dynamic.

Get tables

Operation ID:
GetTables

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

Definitions

Table

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.

TablesList

Represents a list of tables.

Name Path Type Description
value
 value array of Table

List of Tables