Setting up refresh schedules for Amazon Redshift materialized view

Question

I am looking to refresh materialized views in Amazon Redshift on a schedule. Having read various documentation, I am unable to find details on how (if at all possible) to create a schedule to automatically update the materialized view.

Accepted Answer

There are several ways this could be achieved -
* Amazon Redshift now has a scheduler feature to schedule running of queries on a cluster which can easily take care of this. For more details refer [Video: Schedule a query][2] or [Schedule a query][3]
* To use the new [Redshift Data APIs][1] from AWS Lambda to run the `REFRESH` statement and schedule the AWS Lambda Function through Amazon EventBridge or to add the call to the AWS Lambda in the ETL workflow.
* Using AWS Glue and AWS Glue Workflow a AWS Glue Python Shell job would also work.

[1]: https://aws.amazon.com/about-aws/whats-new/2020/09/announcing-data-api-for-amazon-redshift/
[2]:https://youtu.be/qvtb3ONjj8o
[3]:https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-schedule-query.html

Answer

Amazon Redshift can automatically refresh materialized views with up-to-date data from its base tables when materialized views are created with or altered to have the autorefresh option. For more details, refer to the documentation here, https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html.

Setting up refresh schedules for Amazon Redshift materialized view

Relevant content