[Enhancement]: aws_redshift_cluster enable the ability to set metadata_security

[clarkflowers]

Description

I would like aws_redshift_cluster resource to have the ability to set the system setting metadata_security.

Like Amazon Redshift’s row-level security, metadata security gives you more granular control over your metadata. If metadata security is enabled for your provisioned cluster or serverless workgroup, users can see metadata for the objects for which they have viewing access. Metadata security lets you separate visibility based on your needs. For example, you can use a single data warehouse to centralize all of your data storage. However, if you store data for multiple sectors, managing security can become troublesome. With metadata security enabled, you can configure your visibility. Users of one sector can have more visibility over their objects, while you restrict viewing access to users of another sector. Metadata security supports all object types, such as schemas, tables, views, materialized views, stored procedures, user-defined functions, and machine learning models.

ALTER SYSTEM SET metadata_security=[true|t|on|false|f|off];

Affected Resource(s) and/or Data Source(s)

aws_redshift_cluster

Potential Terraform Configuration

ALTER SYSTEM SET metadata_security=[true|false];

References

https://docs.aws.amazon.com/redshift/latest/dg/t_metadata_security.html

Would you like to implement a fix?

None

[github-actions]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.