Admin
1
How can I unload data from the Redshift to S3? I was reading the following document but where can I use this command?
https://docs.aws.amazon.com/redshift/latest/dg/t_Unloading_tables.html
unload ('select * from venue')
to 's3://mybucket/tickit/unload/venue_'
iam_role 'arn:aws:iam::0123456789012:role/MyRedshiftRole';
is it a bash command or py?
You execute this query against your Redshift cluster using your SQL connection.
This is executed in the similar way to how you would run the COPY command.
Ensure that the IAM role in question has been attached to the Redshift cluster and that it has permissions to call S3:PutObject for your bucket.
You have to connect to your cluster. For example, using workbench:
There are also other ways, as listed in the following link:
