Amazon Redshift is a column-based relational database which 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 the
COPY command 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.