amazon-redshiftHow do I use Amazon Redshift's UNLOAD command?
The UNLOAD command in Amazon Redshift allows you to extract data from a cluster to one or more text files on Amazon S3. This command is useful for creating backups, archiving data, or transferring data to another system for further processing.
Example code
UNLOAD ('SELECT * FROM mytable')
TO 's3://mybucket/myfolder/mydata'
IAM_ROLE 'arn:aws:iam::123456789012:role/MyRedshiftRole'
The example code above will extract all data from the table mytable
and store it in the S3 bucket mybucket
in the folder myfolder
with the file name mydata
. The IAM role MyRedshiftRole
is used to provide access to the S3 bucket.
Code explanation
UNLOAD
- The command to initiate the unload process.('SELECT * FROM mytable')
- The SELECT statement to extract the data.TO 's3://mybucket/myfolder/mydata'
- The location of the S3 bucket where the data will be stored.IAM_ROLE 'arn:aws:iam::123456789012:role/MyRedshiftRole'
- The IAM role that provides access to the S3 bucket.
For more information on the UNLOAD command, please see the Amazon Redshift documentation.
More of Amazon Redshift
- How do I use the CASE WHEN statement in Amazon Redshift?
- How do I use the Amazon Redshift YEAR function?
- How can I optimize Amazon Redshift performance?
- How can I monitor Amazon RDS using Zabbix?
- How can I handle divide by zero errors when using Amazon Redshift?
- How do I use Amazon Redshift with YouTube?
- How can I use Amazon Redshift to store and query NoSQL data?
- How can I transfer data from Amazon Redshift to an Amazon S3 bucket?
- How can I calculate the serverless pricing for Amazon Redshift?
- How can I use Amazon Redshift UNION to combine data from multiple tables?
See more codes...