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)

Both string and 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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.