Amazon Redshift now supports federated permissions across multi-warehouse architectures

Amazon Redshift Federated Permissions Across Multi-Warehouse Architectures

Amazon Redshift now supports federated permissions, simplifying permissions management across multiple Redshift data warehouses. This feature allows you to define data permissions once and enforce them across all warehouses in your account.

With federated permissions, Redshift warehouses are auto-mounted in every Redshift warehouse, and you can use existing workforce identities with AWS IAM Identity Center or existing IAM roles to query data across warehouses. Row-level, column-level, and masking controls apply automatically, ensuring fine-grained access compliance.

To get started, register a Redshift Serverless namespace or Redshift provisioned cluster with AWS Glue Data Catalog and start querying across warehouses using Redshift Query Editor V2 or any supported SQL client. This feature provides horizontal scalability with multiple warehouses, allowing you to add new warehouses without increasing governance complexity.

What to do

• Register a Redshift Serverless namespace or Redshift provisioned cluster with AWS Glue Data Catalog.
• Start querying across warehouses using Redshift Query Editor V2 or any supported SQL client.
• Use existing workforce identities with AWS IAM Identity Center or existing IAM roles.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.