Redshift Query Scheduler is State: Enabled but the queries are not running. IAM Permission problem?

Question

I am attempting to use the Redshift Scheduler to run an UNLOAD to S3. The database is connected properly and when I connect and run the query from the Console it runs. I have enabled a scheduled query to run every hour, but it is not executing.

Am I missing something? I have set up the IAM role with the AmazonRedshiftFullAccess and Secret Manager access. The Trust Policy has scheduler.redshift.amazonaws.com and redshift.amazonaws.com as trusted entity providers and can assume role as my user.

I'm not getting any errors, it just is not running. State is enabled, but the S3 bucket is not updating and there are no query records in the history.

Answer 1

I needed to add the EventBridge permissions - events.amazonaws.com as a trusted provider and AmazonEventBridgeFullAccess policy.