ALTER SYSTEM - Amazon Redshift
Required privilegesSyntaxParametersUsage notesExamples
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

ALTER SYSTEM

Changes a system-level configuration option for the Amazon Redshift cluster or 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 = {true| t | on | false | f | off}

Parameters

system-level-configuration

A system-level configuration. Valid value: data_catalog_auto_mount and metadata_security.

{true| t | on | false | f | off}

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.

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.

Examples

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

ALTER SYSTEM SET data_catalog_auto_mount = true;

The following example turns on metadata security.

ALTER SYSTEM SET metadata_security = true;