I work with a Redshift cluster that receives a lot of routine queries that could be turned into materialized views. I thought enabling auto_mv = true
would create materialized views of these queries, but it turns out that this parameter is enabled by default and as such was already enabled on my cluster. How can one enforce the creation of auto-matviews? Is there a requirement of a certain percentage of resources not be used to initiate this process?
1