I am trying to create a database in RedShift so I can import from DynamoDB. My table in Dynamo contains STRING, NUMBER and BOOLEAN. I am unable to create the initial database in RedShift using:
create table subs(original_id string(255), auto_num number)
number are not acceptable. I have tried to create it using
varchar instead of string and
int instead of
number but when I import it fails with:
Invalid operation: Unsupported Data Type: Current Version only supports Strings and Numbers Details:
How can I create the initial table in RedShift using STRING and NUMBER so I can import?