Amazon Redshift now supports the scheduling of SQL queries by integrating with Amazon EventBridge
Amazon Redshift now allows you to schedule your SQL queries for executions in recurring schedules and enables you to build event-driven applications by integrating with Amazon EventBridge. You can now schedule time sensitive or long running queries, loading or unloading your data, or refreshing your materialized views on a regular schedule.
You can use the Amazon Redshift Console or Amazon Redshift Data API to schedule your SQL queries. You can use flexible scheduling expressions for your schedule, including cron expressions. The query scheduling is secured as you can either leverage your IAM credentials or secrets stored in AWS Secrets Manager. For more information, including instructions on getting started with scheduling SQL in Amazon Redshift, please read the Amazon Redshift documentation or watch this demo.
The feature is available in all commercial regions except Africa (Cape Town) and Asia Pacific (Osaka) regions.
Amazon Redshift is a fast, scalable, secure, and fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. Tens of thousands of customers use Amazon Redshift to process Exabytes of data per day and power analytics workloads. For more information, please visit the Amazon Redshift product page, and view the Amazon Redshift pricing page to get started.