RedShift Metadata Security feature requirement

Question

Do you know what the minimum version you need to be on to use the new metadata_security system parameter in Redshift?

Answer

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:

```sql
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.

RedShift Metadata Security feature requirement

Relevant content