Using pipelines to execute post deploy scripts.

[WaffiAltaher]

Hi all, I am using CDK in python and using aws_cdk.pipelines.
My setup is that I have my pipeline running in one account (common services) and it deployed the actual workload to Dev account and eventually to PROD account.

For SQL scripts (and some other post deploy actions), I want to create a code build step per account ( so I can run it in the same VPC like my RDS database), and use that job to run my sql. How can I trigger my environment specific code build as a post deploy action? Any other recommended way to achieve this is also welcome!

Thanks!