Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Copy AWS QuickSight analysis to another account

We have a lot of AWS quicksight reports in one account, which needs to be migrated to another account.

Within the same account, we can use the 'save-as' feature of the dashboard to create a copy of the report, but is there any way to export the analysis from one account and import into another account?

At present, it appears only we way is to recreate all the reports again from scratch in the new account, but anyone has any other options?

like image 284
yottabrain Avatar asked Oct 09 '19 06:10

yottabrain


People also ask

How do you share a QuickSight analysis?

Sharing an analysis You can only share analyses with users or groups who are in your Amazon QuickSight account. Add a user or group to share with. To do this, for Type a user name or email, enter the first user or group that you want to share this analysis with. Then choose Share.

Can one AWS account have multiple QuickSight accounts?

You can create multiple user accounts at once by choosing one or more Active Directory groups to integrate with Amazon QuickSight. All users in the selected groups are authorized to sign in to Amazon QuickSight.

How do I export from QuickSight dashboard?

To export a dashboard sheet as a PDFOpen Amazon QuickSight and choose Dashboards on the navigation pane at left. Open the dashboard that you want to export. At upper right, choose Export, Download as PDF. The download is prepared in the background.


2 Answers

In my organization, we are using the QuickSight APIs in AWS Lambda Functions and save the Analysis template in JSON format in an S3 bucket. This S3 bucket has access to multiple environments like Dev, QA, Staging, and Production. Leveraging the API again, we create analysis in other environments by using the template JSON file. We also store version information of the templates in a PostgreSQL database.

PS - The dataset in each environment needs to be created prior to migrating the analysis.

like image 120
aveek Avatar answered Oct 16 '22 20:10

aveek


You can do this programmatically through the API:

QuickSight API

However, it will take a bit of scripting. You will need to pull out the pieces with the API, and then rebuild on a new account. For example, DescribeTemplate will pull the JSON defining a template. Then you can use CreateTemplate to create on another account.

like image 25
Dutch Masters Avatar answered Oct 16 '22 20:10

Dutch Masters