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.












