Creating a query schedule with query editor v2 - Amazon Redshift
Demo video

Creating a query schedule with query editor v2

You can create a schedule to run a SQL statement with Amazon Redshift query editor v2. You create a schedule to run your SQL statement at the time intervals that match your business needs. When it's time for the scheduled query to run, the query is started by Amazon EventBridge and uses the Amazon Redshift Data API.

To create a schedule to run a SQL statement

  1. On the Editor Editor view, choose Schedule Schedule to create a schedule to run a SQL statement.

  2. When you define the schedule, you provide the following information.

    • The IAM role that assumes the required permissions to run the query. This IAM role is also attached to your cluster or workgroup.

    • The authentication values for either AWS Secrets Manager or temporary credentials to authorize access your cluster or workgroup. These authentication methods are supported by the Data API. For more information, see Authenticating a scheduled query.

    • The cluster or workgroup where your database resides.

    • The name of the database that contains the data to be queried.

    • The name of the scheduled query and its description. The query editor v2 prefixes the scheduled query name you provide with "QS2-". The query editor v1 prefixes its scheduled query names with "QS-".

    • The SQL statement to be run on the schedule.

    • The schedule frequency and repeat options or a cron formatted value that defines the schedule. For more information, see Cron Expressions in the Amazon CloudWatch Events User Guide.

    • Optionally, you can enable standard Amazon SNS notifications to monitor the scheduled query. You might need to confirm the email address you provide to the Amazon SNS notification. Check your email for a link to confirm the email address for the Amazon SNS notification. For more information, see Email notifications in the Amazon Simple Notification Service Developer Guide. If your query is being run but you don't see messages published in your SNS topic, see My rule runs, but I don't see any messages published into my Amazon SNS topic in the Amazon EventBridge User Guide.

  3. Choose Schedule query to save and activate the schedule and add the schedule to the list of queries in the Scheduled queries view.

The Scheduled queries Scheduled queries view lists all the scheduled queries for your clusters and workgroups. With this view, you can display schedule query details, activate or deactivate the schedule, edit the schedule, and delete the scheduled query. When you view query details, you can also view the history of running the query with the schedule.

Note

A schedule query run is only available in the Schedule history list for 24 hours. Queries that run on a schedule don't appear in the Query history view of query editor v2.

Demo of scheduling a query

For a demo of scheduling a query, watch the following video.