QuestionQ44

VerifiedData Operations and Support

A data engineer has completed testing an Amazon Redshift stored procedure that processes and inserts data into a non-mission-critical table. The engineer needs the stored procedure to run automatically each day.

Which solution meets this requirement in the MOST cost-effective manner?

Explanation

Amazon Redshift Query Editor v2 can schedule a SQL statement to run automatically at specified intervals or times. Scheduling a CALL statement for the stored procedure directly provides daily execution while avoiding the additional compute and operational cost of an EC2 instance, Lambda-based scheduling infrastructure, or an AWS Glue job.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!