Work with Amazon Redshift as a relational database

Extract data from Redshift

You can use any Database to Flow type to extract data from Amazon Redshift.

Load data into Redshift

Amazon Redshift is a column-based relational database that is loosely based on PostgreSQL. Therefore, you can use the same techniques you would normally use to work with relational databases in Etlworks Integrator. It is, however, important to understand that inserting data into Redshift row by row can be painfully slow.

So, it is recommended that you use set operations, such as insert into select from or Redshift optimized Flows to load data into Amazon Redshift.

Data Types

The following data types are available in Amazon Redshift.

Redshift includes a Text data type, which is used as a CLOB in PostgreSQL. However, Redshift automatically translates it to VARCHAR(255). There are other similar restrictions.