AWS Security ChangesHomeSearch

AWS redshift: Document default_mv_auto_refresh_interval and generalize value syntax

Service: redshift · 2026-10-20 · Documentation low

File: redshift/latest/dg/r_ALTER_SYSTEM.md

Summary

Adds the new system-level configuration default_mv_auto_refresh_interval (60-86400 seconds, default 300) with an example, and generalizes the SET syntax from a boolean {true|t|on|false|f|off} to a generic _value_, clarifying that data_catalog_auto_mount and metadata_security still take boolean values.

Security assessment

The substantive addition is a materialized-view refresh interval setting with no security impact; the security-relevant options (metadata_security, data_catalog_auto_mount) are only re-described in the value-syntax rewrite.

Evidence

+A system-level configuration. Valid values: `data_catalog_auto_mount`, `metadata_security`, and `default_mv_auto_refresh_interval`.

Diff

diff --git a/redshift/latest/dg/r_ALTER_SYSTEM.md b/redshift/latest/dg/r_ALTER_SYSTEM.md
index 1b79ac7..3203fba 100644
--- a//redshift/latest/dg/r_ALTER_SYSTEM.md
+++ b//redshift/latest/dg/r_ALTER_SYSTEM.md
@@ -13 +13 @@ Amazon Redshift will no longer support the use of Python UDFs after June 30, 202
-Changes a system-level configuration option for the Amazon Redshift cluster or Redshift Serverless workgroup.
+Changes a system-level configuration option that applies cluster-wide on an Amazon Redshift provisioned cluster or workgroup-wide on an Redshift Serverless workgroup.
@@ -29 +29 @@ One of the following user types can run the ALTER SYSTEM command:
-    ALTER SYSTEM SET _system-level-configuration_ = {true| t | on | false | f | off}
+    ALTER SYSTEM SET _system-level-configuration_ = _value_
@@ -36 +36 @@ _system-level-configuration_
-A system-level configuration. Valid value: `data_catalog_auto_mount` and `metadata_security`.
+A system-level configuration. Valid values: `data_catalog_auto_mount`, `metadata_security`, and `default_mv_auto_refresh_interval`.
@@ -38 +38 @@ A system-level configuration. Valid value: `data_catalog_auto_mount` and `metada
-{true| t | on | false | f | off} 
+_value_
@@ -41 +41,3 @@ A system-level configuration. Valid value: `data_catalog_auto_mount` and `metada
-A value to activate or deactivate the system-level configuration. A `true`, `t`, or `on` indicates to activate the configuration. A `false`, `f`, or `off` indicates to deactivate the configuration.
+The value to set for the system-level configuration. For `data_catalog_auto_mount` and `metadata_security`, specify one of `true`, `t`, `on`, `false`, `f`, or `off` to activate or deactivate the configuration.
+
+For `default_mv_auto_refresh_interval`, specify an integer number of seconds between 60 and 86,400 (24 hours), which sets the cluster-wide default auto-refresh interval for materialized views that don't have a custom refresh interval. The default is 300 seconds (5 minutes).
@@ -48,0 +51,2 @@ For a serverliess workgroup, changes to `data_catalog_auto_mount` do not take ef
+Changes to `default_mv_auto_refresh_interval` don't require a reboot and take effect immediately.
+
@@ -60,0 +65,5 @@ The following example turns on metadata security.
+The following example sets the cluster-wide default materialized view auto-refresh interval to 10 minutes (600 seconds).
+    
+    
+    ALTER SYSTEM SET default_mv_auto_refresh_interval = 600;
+