Database Reference
In-Depth Information
• The DynamoDB table names can contain up to 255 characters, including "
.
"
(dot) and "
-
'' (dash), whereas in Amazon Redshift table names are limited to 127
characters. Also, in DynamoDB, you are allowed ASCII letters, digits, underscore
characters (
_
), or dollar signs (
$
) for standard SQL identifiers.
• Amazon Redshift-reserved keywords cannot be used as table names.
• DynamoDB does not support the null concept of SQL.
• DynamoDB data types do not match completely with those of Amazon Redshift.
Throughput will count against that table's read capacity. So, once you are done with the
copying process, your queries written in Redshift won't be affected in any manner in Dy-
namoDB.
Tip
The DynamoDB data must be created in the same region as your cluster, otherwise, you
have to explicitly mention the region in which your actual DynamoDB table has been cre-
ated. This can also be done using the
REGION
parameter.
Using the
COPY
command, Amazon Redshift can leverage the
massively parallel pro-
cessing (MPP
) architecture to load and read data from the DynamoDB table. The
COPY
command will match the attribute names with the data retrieved from the DynamoDB
table, to column names with the existing Redshift table, by the previously mentioned
rules.
