Below is a summary of the key topics Administration and BIOps Solutions of Quick Sight, including four main areas:
- Quick Sight asset and user management – Who creates, owns, or has viewer permissions for an asset? (Assets include dashboards, datasets, etc.) If a user changes roles or leaves the company, Quick Sight should provide a way for the BI team to update user roles, transfer asset ownership, and manage related changes.
- Usage metrics for Quick Sight assets – For example, tracking how many times a dashboard has been viewed in the last 30 days.
- Data dictionary – Understanding relationships between assets, such as which datasets are being consumed by a specific dashboard. The size of SPICE datasets, and so on.
- BIOps – The ability to build a CI/CD pipeline to migrate Quick Sight assets from one account to another, such as deploying assets to a production account.
For topics 1 and 2, Quick Sight does not provide an out-of-the-box solution in the UI. However, using the API, we can build a solution to achieve these capabilities.
Here are the resources:
- Blog on asset and user/group information, as well as usage metrics:
Measure the adoption of your Amazon QuickSight dashboards and view your BI portfolio in a single pane of glass | AWS Business Intelligence Blog - Source code: GitHub - Admin Console: amazon-quicksight-sdk-proserve/Admin_Console at master · aws-samples/amazon-quicksight-sdk-proserve · GitHub
- YouTube video: Amazon Quick Sight Admin Console Overview: https://www.youtube.com/watch?v=HpOX0QNtjWY&t=1s
For editing access permissions, refer to:
- Blog: Build a centralized granular access control to manage assets and data access in Amazon QuickSight | AWS Big Data Blog
- Source code: amazon-quicksight-sdk-proserve/granular_access at master · aws-samples/amazon-quicksight-sdk-proserve · GitHub
- YouTube video: Granular Access Control in Quick Sight: https://www.youtube.com/watch?v=HpOX0QNtjWY&t=1s
For topic 3 (Data Dictionary), you can use the Admin Console solution to obtain most of the data dictionary insights. If you’re looking for SPICE size analysis, a Quick Sight SA built a solution:
For topic 4 (BIOps & CI/CD for Quick Sight), you have 3 different options:
- Quick Sight also provides an API called Assets as Bundles, which allows you to batch export and import assets efficiently. Documentation: Assets as Bundles API This API can help streamline the migration and deployment of Quick Sight assets across environments. This blog provided the solution to trigger CICD with EventBridge rules: Automate your Amazon QuickSight assets deployment using the new Amazon EventBridge integration | AWS Business Intelligence Blog
- Customized solutions by using describe and create assets APIs: Blog: BIOps: Amazon Quick Sight Object Migration and Version Control and the YouTube video: BIOps for Quick Sight
- You can also refer to this workshop to learn more about the Quick Sight API in detail: Amazon Quick Sight Admin Workshop – Content Porting This workshop provides hands-on guidance on using the API for migrating Quick Sight assets.