Database Reference
In-Depth Information
rows are discarded. The number of rows to sample is decided by the parameter
COMPROWS
the default value of which is
10000
rows.
Note
If your data contains multibyte characters (Mandarin (Chinese) characters), then you
should use VARCHAR columns in Redshift tables to load data. VARCHAR supports
4-byte UTF-8 characters. The CHAR data type supports only single-byte characters. You
cannot load data comprising more than 4-byte characters.
With Redshift being the data warehouse, the majority of the time, there would be a use
case of only exporting data from DynamoDB to Redshift, and in a very rare situation
someone would think of importing data back from Redshift to DynamoDB, hence there is
no such best method available till date.