![]() Make sure that the IAM user who is going to create the schedule has the AmazonEventBridgeFullAccess IAM policy attached to it.To set this up, we need to make sure that the AWS Identity and Access Management (IAM) user (which we use to create the schedule and access the schedule history), the IAM role, and the AWS secret (which stores the database user name and password) are configured correctly. In this post, we describe how you can schedule SQL statements on Amazon Redshift using EventBridge, and also go over the required security privileges and the steps to schedule a SQL statement using both the AWS Management Console and the AWS CLI. This rule then runs as per the schedule using EventBridge. When creating a schedule using the Amazon Redshift console, you create an EventBridge rule with the specified schedule and attach a target (with the Amazon Redshift cluster information, login details, and SQL command run) to the rule. Beside scheduling SQL, you can also invoke the Amazon Redshift Data API in response to any other EventBridge event. Amazon Redshift integrates with EventBridge to allow you to schedule your SQL statements on recurring schedules and enables you to build event-driven applications. EventBridge delivers a stream of real-time data from your own applications, software as a service (SaaS) applications, and AWS services and routes that data to targets including Amazon Redshift clusters. ![]() Refresh materialized views manually at a regular frequencyĮventBridge is a serverless event bus service that makes it easy to connect your applications with data from a variety of sources.Delete older data from tables as per regulatory or established data retention policies.Unload data using UNLOAD nightly or at regular intervals throughout the day. ![]()
0 Comments
Leave a Reply. |