Key features include
SPICE engine refresh on-demand
Section titled “SPICE engine refresh on-demand”Trigger create-ingestion directly from Aurora-MySQL stored procedures. This is useful for pushing new MySQL data to the SPICE engine.
Duplicate datasets & analyses
Section titled “Duplicate datasets & analyses”Replicate datasets and analyses while changing underlying data sources, pointing to different databases with identical schemas. This is managed via Aurora-MySQL stored procedures.
Create assets from S3 JSON objects
Section titled “Create assets from S3 JSON objects”Deploy QuickSight data-sets and analyses assets from JSON definitions stored in S3.
- create-data-set
- create-analysis
QuickSight asset inventory
Section titled “QuickSight asset inventory”List and save basic information (like assetId and name) for all QuickSight assets across multiple AWS accounts in Aurora-MySQL.
- list-analyses
- list-dashboards
- list-data-sets
- list-data-sources
- list-groups
- list-groups-memberships
- list-users
- list-vpc-connections
QuickSight asset backup to S3
Section titled “QuickSight asset backup to S3”After listing assets, batch invoke describe commands to save JSON definitions in S3 and update MySQL with metadata like importMode, ingestionId, ingestionSizeInBytes, ingestionTimeInSeconds, etc.
- describe-analysis
- describe-analysis-definition
- describe-dashboard
- describe-dashboard-definition
- describe-dashboard-permissions
- describe-data-set
- describe-data-set-permissions
- describe-user
- describe-vpc-connection
- describe-data-source
- describe-data-source-permissions
- describe-group
- describe-group-membership
- (*) Backup schedules are managed with events in Aurora-MySQL.
Delete QuickSight assets
Section titled “Delete QuickSight assets”- delete-analysis
- delete-data-set
Project architecture:
- Lambda functions: Invoke QuickSight APIs.
- S3: Store QuickSight asset JSON files.
- Aurora-MySQL: Orchestrate flows, invoke Lambda functions, and store QuickSight asset information and user activity.
Coming soon
Section titled “Coming soon”create-dashboard, with lambda and stored procedure.create-data-source, with lambda and stored procedure.register-user, with lambda and stored procedure.- Gather usage statistics of dashboards and save it in MySQL.
- Gather all user permissions and save it in MySQL.
- A web interface for administrators to call actions.
Contact
Section titled “Contact”This project is maintained by Factor BI. If you need help or support, you can contact us at: quicksight@factorbi.com