COPY command on a csv uploading zero rows to REDSHIFT

Viewed 15

I have the following csv

I run the following command:

            copy table_name_1
            from 's3://path/to/manifest'
            -- iam_role '{REDSHIFT_S3_READ_IAM_ROLE}';
            access_key_id '{ACCESS_KEY_ID}'
            secret_access_key '{SECRET_ACCESS_KEY_ID}'
            csv
            IGNOREHEADER 1

The command executes without error however when i check the table, zero rows were added. I checked this however if i download one of the csv files from s3 and run od -t a downloaded-csv-prototype.csv i see an nl character (eg:“0x0A”) so that does not appear to be the issue?

Any hints on how to proceed? Thanks in advance!

0 Answers
Related