Copy file from S3 to redshift using Copy Command
Copy file from S3 to redshift using Copy Command,
I am using Aginity tool to connect to Redshift.
############
copy public.annual
from 's3://test-deltafrog-out/annual_final0910.csv'
iam_role 'arn:aws:iam::222161883511:role/copy_s3_redshift3'
delimiter ','
IGNOREHEADER as 1
csv;
#############