AWS redshift: Document default_mv_auto_refresh_interval and generalize value syntax
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; +