Geek Answers Handbook

Redshift COPY command with delimiter "^ A"

I am trying to use a file with limited control A ("^ A") to load into redshift using the COPY command, I see that the default delimiter is pipe (|) and the CSV is a comma.

I could not specify the method of use ^Awhen I tried the COPY command with ^Aor \x01, it throws a message below. Has anyone tried this before? the documentation says we can use a delimiter, but we don’t know how to use it ^A.

Password: ERROR: COPY delimiter must be a single character

+4
source share
1 answer

'\\001' ctrl + A redshift, Pig.

:

copy redshiftinfo from 's3://mybucket/data/redshiftinfo.txt' 
credentials 'aws_access_key_id=<access-key-id>;aws_secret_access_key=<secret-access-key>' 
delimiter '\\001'
+4

More articles:


All Articles