Implement a backup strategy for Amazon Quick Sight BI assets
Summary
Amazon Quick Sight assets such as dashboards, analyses, datasets, and data sources can be backed up using the `AssetsAsBundle` APIs described in this post. This strategy protects against accidental deletions, unintended modifications, and regional disruptions, which is critical for regulated industries. The article details asset selection, the `AssetsAsBundle` APIs (`StartAssetBundleExportJob`, `StartAssetBundleImportJob`, `DescribeAssetBundleExportJob`), and a sample automation tool. It also covers backing up users, groups, and account settings using other Quick Sight APIs, storing this data in Amazon DynamoDB. A scheduled execution architecture is outlined, leveraging Amazon EventBridge, AWS Step Functions, and AWS Lambda for automated, serverless backups. Cost estimations for Amazon S3 and DynamoDB storage indicate minimal expenses, even for extensive deployments.
Key takeaway
For Data Engineers or IT Professionals managing Amazon QuickSight BI assets, implementing a comprehensive backup strategy is crucial. You should utilize the `AssetsAsBundle` APIs to export dashboards, analyses, datasets, and data sources, ensuring all dependencies are included. Additionally, back up user and group configurations to Amazon DynamoDB for complete point-in-time recovery. Consider automating this process with AWS EventBridge, Step Functions, and Lambda to maintain continuous protection and meet your RPO/RTO requirements.
Key insights
Amazon QuickSight BI assets can be backed up programmatically using `AssetsAsBundle` APIs for disaster recovery and versioning.
Principles
- Protect BI assets against human error and regional outages.
- Meet Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
- Consider asset dependencies for full restorability.
Method
The backup process involves listing assets, filtering unsupported types, grouping them into bundles (max 100), initiating `StartAssetBundleExportJob`, polling status, and uploading the resulting ZIP to Amazon S3.
In practice
- Use `AssetsAsBundle` APIs for QuickSight asset export.
- Store user and group data in DynamoDB.
- Implement exponential backoff for API calls.
Topics
- Amazon QuickSight
- BI Asset Backup
- AWS AssetsAsBundle APIs
- Disaster Recovery
- AWS S3 Storage
- AWS Serverless Automation
Code references
Best for: Data Engineer, DevOps Engineer, IT Professional
Related on AIssential
Editorial summary, takeaway, and curation by AIssential. Original article published by Artificial Intelligence.