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!