Posted On: Nov 29, 2023

Amazon Redshift now supports metadata security that enables administrators to restrict the visibility on their catalog data based on user roles and permissions. Users can now see only the metadata for databases, schema, and tables/views that they have access to. It enables customers to deploy multi-tenant applications on a provisioned cluster or Serverless namespace. 

You can enable metadata security for your provisioned or serverless data warehouses by running a simple “ALTER SYSTEM set METADATA_SECURITY=true” command. You can leverage this feature using native or third-party tools that leverage JDBC/ODBC/Python drivers or the Redshift Data API.

Metadata security is now available in all AWS commercial and the AWS GovCloud (US) Regions where Amazon Redshift is available. You can learn more about this feature from the Redshift management guide.