HI @Sanjeeb2022 @Ashok @David_Wong
We are looking for all the analysis and dashboards which are using this dataset. same listed under “Usage” tab on a dataset page.
HI @Sanjeeb2022 @Ashok @David_Wong
We are looking for all the analysis and dashboards which are using this dataset. same listed under “Usage” tab on a dataset page.
Hi @mukeshusc2018,
You would have to use ListAnalyses and ListDashboards first to get all the analysis IDs and dashboard IDs in your account. Then, loop through each one, call DescribeAnalysis/DescribeDashboard and look for the desired dataset ID in the response.
That’s how I would do it but maybe there’s a better way that I’m not aware of.
Hi David, can you pls check internally how it’s done on the quicksight dataset console in “Usage” tab ?
Hi @mukeshusc2018,
I’m not on the QuickSight team. Let’s see what @Ashok or other members of the QuickSight team have to say.
Hi @mukeshusc2018 - @David_Wong pointed rightly there is no direct api available which can provide you the usage details of a data set in QuickSight. This can be consider as a feature request. However a custom solution can be developed for the same. Essentially you need to list all dashboards, collect all analysis used the dashboard and for each analysis you need to find the data set details. Then you can create a file out of that script and can create a report the details.
Hi @ErikG @DylanM @duncan - Need your help on this. Can we raise a feature request and all get the details from QS internal team to understand how the usage information are displayed in UI. Can we get those details from backend?
Regards - Sanjeeb
Hello @mukeshusc2018, are you wanting to do this through the QuickSight API or just find this information in the QuickSight console? There is not a specific API call to find all of the resources a dataset is linked to, so the solution suggested by @Sanjeeb2022 to do this programatically is the best option. DescribeDashboard or DescribeAnalysis will provide you the DataSet Arns associated with each resources, so running those queries for your list of resources will likely be the best way to achieve this.
I can also tag this as a feature request, to add the usage data within the return values for the DescribeDataset API call. Let me know if you have further questions, otherwise I can archive this topic for our support team. Thank you!
We currently dont have API support for dataset usage. We can log it as feature request.
One of our SAs has built solution for QuickSight data lineage, which provides detailed information of dataset, fields and all assets that consume these data. Check if this solution and let us know if this helps ?
Hello @mukeshusc2018, since we have not heard back from you with any follow-up information, I will archive this topic for our support team. Thank you!