- Le plus récent
- Le plus de votes
- La plupart des commentaires
Hello,
In this context, please note that STV_MV_INFO table contains DDL used while creating the materialized view.
If the materialized view is created with below command:
—> CREATE MATERIALIZED VIEW globaldata.vwdeviceplatform AS select xyz..
After creating the mv we can turn on AUTO REFRESH Using -
—> ALTER MATERIALIZED VIEW globaldata.vwdeviceplatform AUTO REFRESH YES;
[+] https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_MATERIALIZED_VIEW.html
Now even if autorefresh=’t’ in STV_MV_INFO table, the view definition will be same as below:
CREATE MATERIALIZED VIEW globaldata.vwdeviceplatform AS select xyz..
Same goes with pg_get_viewdef function. So, in both the cases you will get the DDL used while creating the mv only.
That being said, if you would like resource based troubleshooting, please raise a support case with AWS for further information. If a support case has already been created please be assured that we will get back to you and assist you in the best way possible.
Contenus pertinents
- Réponse acceptéedemandé il y a un an
- demandé il y a un an
- demandé il y a un mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans