Extracting data from Redshift
You can use any "database to..." flow type to extract data from Amazon Redshift.
Loading 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.
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.