EventBridge Rule to trigger stored procedures for Redshift Serverless Cluster

Question

Hi AWS, I am trying to create an EventBridge rule for Redshift Serverless cluster stored procedures. Also I was not able to find any documentation regarding the stored procedures for serverless in general.

Can you please help me with that?

Accepted Answer

This page https://docs.aws.amazon.com/redshift/latest/mgmt/data-api-calling-event-bridge.html provides the details of how to use Amazon Redshift Data API with Amazon EventBridge using a schedule. Instead of schedule you can switch to EventBridge event trigger.

Answer

Maybe you can use a Lambda function triggered by CW event that connects to Redshift and execute a [SQL CALL ](https://docs.aws.amazon.com/redshift/latest/dg/r_CALL_procedure.html) command.

EventBridge Rule to trigger stored procedures for Redshift Serverless Cluster

Contenido relevante