Connectors

Databases & Data Warehouses

AWS Redshift Data API

Run SQL on Redshift without a driver: execute statements, fetch results, and read table metadata
Signs in with
AWS access keys
Runs on
Cloud or On-Prem Worker
Operations
12
Ready-made triggers
0

Connect AWS Redshift Data API

  1. In Neblex open Connect › Connections and click New Connection.
  2. Search for AWS Redshift Data API and give the connection a clear name.
  3. Fill in the fields. Secret values are encrypted and never shown again.
  4. Click Test, then Create Connection.
FieldWhat to enter
Access key IDRequiredSecretThe access key ID of an IAM user or role session.
Secret access keyRequiredSecretThe secret access key that belongs to the access key ID.
Session tokenOptionalSecretOnly for temporary credentials (an assumed role or federated session).
RegionRequiredThe AWS Region of the Redshift cluster or serverless workgroup, for example us-east-1.Example: us-east-1

Use it in a flow

  1. Open a flow, open the node library and search for AWS Redshift Data API.
  2. Drag it onto the canvas and choose an Operation and your connection.
  3. Map the operation's fields from earlier steps, or click Map with Matt.
  4. Use Test this step to see what it returns, then save.

To start a flow from AWS Redshift Data API without a ready-made trigger: a Poll for changes trigger can check one of its list operations on a schedule and pass on only what is new; if AWS Redshift Data API can send webhooks, a Webhook trigger receives them at its own URL.

Operations

12 operations in 3 groups. Each one is a step you can add to a flow.

Database metadata4
Describe tabledescribeTablePOSTDescribes the detailed information about a table from metadata in the cluster.
List databaseslistDatabasesPOSTList the databases in a cluster.
List schemaslistSchemasPOSTLists the schemas in a database.
List tableslistTablesPOSTList the tables in a database.
Sessions1
List sessionslistSessionsPOSTLists the sessions that the caller created in the last 24 hours.
Statements7
Batch execute statementbatchExecuteStatementPOSTRuns one or more SQL statements, which can be data manipulation language (DML) or data definition language (DDL).
Cancel statementcancelStatementPOSTCancels a running query.
Describe statementdescribeStatementPOSTDescribes the details about a specific instance when a query was run by the Amazon Redshift Data API.
Execute statementexecuteStatementPOSTRuns an SQL statement, which can be data manipulation language (DML) or data definition language (DDL).
Get statement resultgetStatementResultPOSTFetches the temporarily cached result of an SQL statement in JSON format.
Get statement result v 2getStatementResultV2POSTFetches the temporarily cached result of an SQL statement in CSV format.
List statementslistStatementsPOSTList of SQL statements.