Overview

Amazon Redshift is a data warehousing service in the cloud.

Use Snaps in this Snap Pack to:

• Lookup records in the target Redshift table and return a selected set of fields for every matched record.

• Output a list of tables in a database.

• Fetch data from a database by providing a table name and configuring the connection. 

• Execute a Redshift bulk load or bulk upsert.

• Execute a SQL delete, a SQL Insert statement, or a SQL update.

• Provide functionality of SCD (Slowly Changing Dimension) Type 2 on the target Redshift table.

Limitations

Redshift operations against Redshift system views and tables are not supported.

Articles in this section

Supported Versions

This Snap Pack is tested against:

• PostgreSQL 8.0.2

• Redshift 1.0.69065 (Redshift-JDBC 42-2.1.0.29.jar)