copy table from redshift to s3
snippet in sql

copy table from redshift to s3

user6068

UNLOAD ('select * from my_schema.my_table')    
to 's3://bucket-name/file_’ 
iam_role 'arn:aws:iam::482569874589:role/RedshiftLoaderRole’;