RedShift Metadata Security feature requirement

The metadata_security system parameter in Amazon Redshift was introduced in version 1.0.24739 of the Redshift engine.

Prior to version 1.0.24739, the metadata_security parameter did not exist. The parameter allows you to configure the level of metadata access control for your Redshift cluster.

So, the minimum Redshift engine version required to use the metadata_security parameter is 1.0.24739.

You can check the current version of your Redshift cluster by running the following SQL query:

SELECT version();

The output will show the current Redshift engine version, for example:

version
--------------------------
Amazon Redshift (v1.0.24739)

If your Redshift cluster is running an older version, you may need to consider upgrading to version 1.0.24739 or later to take advantage of the metadata_security parameter and the associated metadata access control features.

It's always a good practice to review the Redshift documentation for the latest information on system parameters and feature availability, as Amazon frequently updates the Redshift service.

To utilize metadata_security system parameter in Amazon redshift, your Redshift cluster must be running version 1.0.24739 or later. https://docs.aws.amazon.com/redshift/latest/dg/t_metadata_security.html

You can verify your current cluster version by executing the following SQL command:

sql
SELECT version();

If your cluster is on version 1.0.24739 or newer, you can enable metadata security with the following command:

sql
ALTER SYSTEM SET metadata_security = true;