Batch execute on redshift

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.

Launch Stack
< Back to all workflows

GitHub icon View this workflow on GitHub


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.

Additional resources

Created by:

Shivam Rajawat

I am a Cloud Support Engineer (Serverless) at AWS and I love to solve complex problems.

Follow on LinkedIn