Design Query on managing multiple dashboards across multiple accounts

Question & Answer
,
1

Background:

XYZ is a web app that uses separate AWS Accounts to isolate individual projects.

Accounts
Each AWS account will have a data catalog with overlapping table schemas. We track what accounts have what tables in Dynamo DB in a centralized account.

For example:

  • Account A has Tables: Dogs, Cats, and Birds
  • Account B has Tables: Dogs, Birds, and Fish
  • Account C has Tables: Birds and Fish

Reports
Each Quicksight Template will require access to multiple tables. We are not currently capturing this information anywhere – but obviously could if need be.

For example:

  • Report A requires tables: Dogs and Fish – so can only be run on Account B
  • Report B only requires table: Birds – so can run in any account

Users
The same user may have access to multiple accounts:

For Example:

  • User A has access to: Account A, B, and C
  • User B has access to: Account B and C

Objectives

  • Minimize Cost. Design and publish Quicksight dashboards.
  • Avoid replication of templates (if Report A changes – it should change globally)
  • Determine what costs are attributed to what accounts for different approaches that you may suggest ?
2

Hello gdsrini,

First of all welcome to the QuickSight community.

According to me, your question needs broad understanding of your Account and data architecture.

I would highly recommend to reach to your AWS account manager if there are any and aslo involve Solution Architect to deep dive and review the architecture of your accounts, data and setup.

I strongly believe with this you could get the best practice advices on all the questions/objectives you have and it is doable.

Hope this gives you some directions.

Thank you.
Cheers,
Deep