Amazon Redshift (Preview)

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.

Throttling Limits

Name Calls Renewal Period
API calls per connection 300 60 seconds

Creating a connection

To connect your account, you will need the following information:

Server
string
Specify the server in the format <server>[:<port>]
Database Name
string
Specify the database name. Eg. dev
Authentication Type [Select Basic]
string
Authentication type to connect to your database
Username
securestring
Username credential
Password
securestring
Password credential

Actions

Get row

This operation gets a row from a table.

Required Parameters

Name of schema
string
Name of schema
Name of table
string
Name of table
Unique identifier of the row to retrieve
string
Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

This operation gets rows from a table.

Required Parameters

Name of schema
string
Name of schema
Name of table
string
Name of table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
integer
The number of entries to skip (default = 0).
Select Query
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.

Required Parameters

Schema name
string
Name of schema

Returns

Body
TablesList

Represents a list of tables.

Definitions

Table

Represents a table.

DisplayName
string
The display name of the table.
Name
string
The name of the table. The name is used at runtime.

TablesList

Represents a list of tables.

value
array of Table
List of Tables