taking redshift backup as s3 file code example

Example: copy table from redshift to s3

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