2 Antworten
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
beantwortet vor 3 Jahren
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren