I have created a Quick Sight DataSource, DataSet, an Analysis, and published it as a Dashboard. Then, I created an asset bundle for each asset using the Quick Sight API and stored the bundles in an S3 bucket.
Now, I’m trying to delete assets and then restore them using the Quick Sight API. Deleting and restoring a Dashboard works well since a dashboard bundle includes all its dependencies.
However, when I delete and then restore a DataSet, the Analysis and Dashboard that use the restored dataset are not working. The Usage menu of the restored dataset shows the names of the Analysis and Dashboard. The Analysis shows two error notifications: “Unable to load dataset” and “Cannot access data for this visual.” (s. screenshots)
Is there any detail that I am probably missing while calling the Quick Sight Bundle Import API?
I haven’t use the APIs but my experience dealing with datasets and analysis is that if you rebuild the dataset, then the analysis would loose reference to the dataset fields.
For example;
If I edit a dataset which has table a and b in a join. Let us say I remove table b in the edit window of the dataset and then add table b again. Logically nothing should change but the act of deleting the table during the edit has impact on analysis as it looses the link to those fields.
Hi @Giridhar.Prabhu
Yes you are accurately describing what is happening in my use case. I’ve even used the describe-data-set API to compared the DataSet attributes such as dataSetId, physicalTableMap and logicalTableMap. They were exactly the same before deletion and after restoring the dataset.
Hi @nasa,
It’s been awhile since last communication took place on this thread, are you still working on this scenario or were you able to find a work around in the interim?
If we do not hear back within the next 3 business days, I’ll close out this topic.
When a dataset gets deleted, I have to delete its analyses and dashboards manually, and finally restore the deleted dataset, analysis and dashboard using their backup files.
