Execute batch statements on redshift
This serverless pattern creates a State Machine with BatchExecuteStatement state and allows users to perform one or more SQL statements on a Redshift cluster directly via step function.
Statemachine will access the CSV file which is present in the S3 bucket and it will then create a table and upload the CSV data to that table directly.
< Back to all workflows
Clone repo
git clone https://github.com/aws-samples/step-functions-workflows-collection/tree/main/stepfunction-redshift-batchexecutestatement-sam/cd step-functions-workflows-collection/stepfunction-redshift-batchexecutestatement-sam/
Deploy
sam deploy --guided
Testing
See the GitHub repo for detailed testing instructions.
Cleanup
1. Delete the stack:
sam delete.