View a markdown version of this page

🏆 Live Soccer TV: redshift/latest/dg/r ALTER SYSTEM.html - Info Live Streaming 2026
Required privilegesSyntaxParametersUsage notesExamples

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

ALTER SYSTEM

Changes a system-level configuration option that applies cluster-wide on an Amazon Redshift provisioned cluster or workgroup-wide on an Redshift Serverless workgroup.

Required privileges

One of the following user types can run the ALTER SYSTEM command:

  • Superuser

  • Admin user

Syntax

ALTER SYSTEM SET system-level-configuration = value

Parameters

system-level-configuration

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

value

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).

Usage notes

For a provisioned cluster, changes to data_catalog_auto_mount take effect on the next reboot of the cluster. For more information, see Rebooting a cluster in the Amazon Redshift Management Guide.

For a serverliess workgroup, changes to data_catalog_auto_mount do not take effect immediately.

Changes to default_mv_auto_refresh_interval don't require a reboot and take effect immediately.

Examples

The following example turns on automounting the AWS Glue Data Catalog.

ALTER SYSTEM SET data_catalog_auto_mount = true;

The following example turns on metadata security.

ALTER SYSTEM SET metadata_security = true;

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;

Setting a default identity namespace

This example is specific to working with an identity provider. You can integrate Redshift with IAM Identity Center and an identity provider to centralize identity management for Redshift and other AWS services.

The following sample shows how to set the default identity namespace for the system. Doing this subsequently makes it more simple to run GRANT and CREATE statements, because you don't have to include the namespace as a prefix for each identity.

ALTER SYSTEM SET default_identity_namespace = 'MYCO';

After running the command, you can run statements like the following:

GRANT SELECT ON TABLE mytable TO alice;

GRANT UPDATE ON TABLE mytable TO salesrole;
               
CREATE USER bob password 'md50c983d1a624280812631c5389e60d48c';

The effect of setting the default identity namespace is that each identity doesn't require it as a prefix. In this example, alice is replaced with MYCO:alice. This happens with any identity included. For more information about using an identity provider with Redshift, see Connect Redshift with IAM Identity Center to give users a single sign-on experience.

For more information about settings that pertain to Redshift configuration with IAM Identity Center, see SET and ALTER IDENTITY PROVIDER.