2 回答
- 最新
- 投票最多
- 评论最多
0
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 or Schedule a query
- To use the new Redshift Data APIs 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.
0
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.
已回答 3 年前
相关内容
- AWS 官方已更新 1 年前
- AWS 官方已更新 6 个月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前