AWS QuickSight's cross-account Athena access unifies siloed data insights
Query Athena data across AWS accounts with costs billed to the data owner.
AWS has introduced cross-account Athena access for Amazon QuickSight, solving a long-standing challenge for enterprises that centralize their BI deployment in a single AWS account while data lives across multiple business unit accounts. Previously, querying Athena data across accounts required either managing multiple QuickSight subscriptions or absorbing all query costs in the central account. The new feature uses IAM role chaining: QuickSight assumes a RunAsRole in the central account, which then chains into a consumer account role with permissions to query Athena and the AWS Glue Data Catalog. Query costs are billed to the consumer account where the data resides, enabling accurate cost allocation.
The setup involves creating two IAM roles: Role A (RunAsRole) in the central QuickSight account with no data permissions but trust to chain, and Role B (Consumer Account Role) in each consumer account granting Athena, Glue, and S3 access. An ExternalId condition (set to the DataSource ARN) prevents confused deputy attacks. Enterprises can now build unified datasets from multiple accounts without duplicating infrastructure or managing separate subscriptions. This empowers financial services, healthcare, and other regulated industries to combine insights from retail banking, investment banking, risk management, and other silos into a single QuickSight experience while maintaining security boundaries and cost transparency.
- Uses IAM role chaining to securely query Athena data across AWS accounts without sharing long-term credentials.
- Query compute costs are billed to the consumer account where the data resides, not the central QuickSight account.
- Eliminates the need for multiple QuickSight subscriptions or central cost absorption, enabling unified BI across siloed business units.
Why It Matters
Enterprises can now unify BI across organizational silos without exploding costs or complexity.