How Zynga scaled multi-warehouse data governance with Amazon Redshift federated permissions

This article describes how Zynga implemented Amazon Redshift federated permissions to manage data governance across multiple warehouse environments for its gaming studios.

• Zynga needed centralized data governance across multiple Redshift clusters for different studios
• Amazon Redshift federated permissions enable cross-cluster queries without explicit data shares
• AWS IAM Identity Center provides unified authentication through Okta federation with automatic role mapping
• Dual-grant approach grants permissions to both IAM Identity Center groups and federated IAM roles
• Stored procedures encapsulate grant logic for consistent permission management across clusters
• Immediate permission propagation replaced manual synchronization processes
• Amazon Redshift Serverless provides scalable compute for Socialpoint without pre-sizing
• No additional infrastructure costs; removed need for custom Lambda and Airflow workflows

Zynga successfully scaled multi-warehouse data governance using federated permissions, eliminating custom synchronization infrastructure while maintaining consistent access controls across provisioned and serverless Redshift environments.