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公式更新しました 4ヶ月前
- AWS公式更新しました 2年前