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.
You can get more details about the COPY command at http://docs.aws.amazon.com/red-
shift/latest/dg/r_COPY.html and http://docs.aws.amazon.com/redshift/latest/dg/
r_COPY_command_examples.html .
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.
Search WWH ::




Custom Search