QuickSight Migration

Question & Answer
,
1

Hi Team, I have a customer who is facing the below issues with QuickSight:

  1. One of the main issues is their struggle to promote a QuickSight analysis from dev to prod, since the two environments use different names for the data sources. The CLI doesn’t let you replace any names as you promote, and as a consequence they are doing a lot of manual effort and recreation for the promotion process. And if you change anything like the name of a column, the whole analysis “is toast” and needs to be recreated. For this process they have to zip it, download it, extract it, edit it, re-zip, and upload it to prod.
  2. They are experiencing an issue with calculated fields, where the Cloud Formation Stack won’t create the dependent fields before trying to create the calculated fields. This is still with the promotion from dev to test. They’ve tested downloading an analysis file and re-uploading the same file immediately and they have the same issue.
  3. They’ve had an issue where an analysis has an error referencing a filter group that’s not in the list of filter groups. A control or a widget was deleted, but it keeps the error and the only way to reset it is to delete the whole sheet and paste back the widgets into a new sheet. And of course you can’t deploy a sheet with an error.

Any suggestions, insights and references would be highly appreciated.

1 Like
2

Hi @ppdoshi - Thanks for the question. There are many steps engaged here and to be honest, at present there is no complete tool or utility available which can make the deployment process smoother. This is something we should start thinking build a tool or utility to help in deployment. However please find some details on the deployment process.

Regards - Sanjeeb

2 Likes
3

Hi @Sanjeeb2022 , thank you for the quick reply !
Any specific suggestion or references for point 2 and 3?

1 Like
4

For 2 and 3, check out the new lenient mode support in analysis and dashboard APIs. I believe the issues you described can be handled via lenient mode. If you use the asset bundle APIs to export/import, lenient mode is on by default.

3 Likes