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.
Comments
0 comments
Please sign in to leave a comment.