Automating DBA tasks on Amazon Redshift securely using AWS IAM, AWS Lambda, Amazon EventBridge, and stored procedures - For this post, we create two DBA tasks in the form of a stored procedure and views inside the Amazon Redshift cluster: Drop unused tables Clean up idle connections We then schedule the running of these tasks using EventBridge and Lambda. For this solution, we use the following AWS services: AWS Lambda – To run a specified query and invoke views or stored procedures inside your Amazon Redshift cluster.