Execute an UNLOAD query on Amazon Redshift Serverless
This workflow executes an UNLOAD query on Amazon Redshift Serverless via the Amazon Redshift Data API and stores the results in an Amazon S3 bucket.
As input, this workflow expects the name of a Redshift Serverless workgroup, database, and the query to be executed.
As output, this workflow provides a list of objects in S3 that contain the query results data.
The Redshift UNLOAD command unloads the result of a query to one or more text, JSON, or Apache Parquet files on Amazon S3, using Amazon S3 server-side encryption (SSE-S3).
Learn more about the UNLOAD command in the Amazon Redshift Database Developer Guide (see resources).
< Back to all workflows
Clone repo
git clone https://github.com/aws-samples/step-functions-workflows-collection/tree/main/redshift-serverless-unload/cd step-functions-workflows-collection/redshift-serverless-unload/lib
Deploy
npx cdk deploy
Testing
See the GitHub repo for detailed testing instructions.
Cleanup
1. Delete the stack:
npx cdk destroy.Additional resources
Created by:
