# Where can I see the relation between the objects within my team's Quick Sight? **URL:** \ **Category:** Q&A\ **Tags:** qls-monitor-reports, admin, quick-sight\ **Created:** [May 20, 2024, 4:08pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264 "2024-05-20T16:08:40Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![guilopec](https://avatars.discourse-cdn.com/v4/letter/g/919ad9/32.png) [@guilopec](https://community.amazonquick.com/u/guilopec)\ **Post date:** [May 20, 2024, 4:08pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/1 "2024-05-20T16:08:40Z")
I’m working on a project to optimize the management of the Quick Sight objects that are on my team AWS account. To do so, I’m build tables containing the relation between our QS objects like which dashboards are from which dataset that are from which datasource… But I’m having trouble getting this kind of data. ---
**Author:** ![neelay](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/neelay/32/12168_2.png) [@neelay](https://community.amazonquick.com/u/neelay)\ **Post date:** [May 20, 2024, 4:38pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/2 "2024-05-20T16:38:38Z")
@guilopec https://{region}.quicksight.aws.amazon.com/sn/console/asset-management?# click on user icon on top right corner, click on manage quicksight, and then from left nav bar, click on Manage assets. ---
**Author:** ![guilopec](https://avatars.discourse-cdn.com/v4/letter/g/919ad9/32.png) [@guilopec](https://community.amazonquick.com/u/guilopec)\ **Post date:** [May 27, 2024, 4:43pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/3 "2024-05-27T16:43:15Z")
@neelay With the instructions you sent I can see the assets, but I still can’t see the relational information about the objects as I asked on the title. Like, which dataset is being used by that analysis or dashboard. ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [May 28, 2024, 4:08am UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/4 "2024-05-28T04:08:01Z")
Hi @guilopec - Welcome to AWS Quick Sight and thanks for posting the question. If I understood your problem statement, you are looking for an approach or solution which will provide the lineage of the Quick Sight artifacts. Unfortunately there is NO direct solution available now. You have to develop a custom solution using boto3 quicksight APIs. You need to list all dashboards, then for each dashboards, extract all analysis and table information. Please give a try and this can be a very good usecase for the whole community. I am also tagging other experts to get their advise on this @WLS-D @David_Wong @sagmukhe Regards - Sanjeeb ---
**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\ **Post date:** [May 28, 2024, 6:24am UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/5 "2024-05-28T06:24:03Z")
This can be achieved by leveraging the boto3 SDK methods. There’s a very good and detailed blog post around this topic. That should help you with the necessary implementation detail. > **[Centrally tracking dashboard lineage, permissions, and more with Amazon...](https://aws.amazon.com/blogs/big-data/centrally-tracking-dashboard-lineage-permissions-and-more-with-amazon-quicksight-administrative-dashboards/)** > > This post is co-written with Shawn Koupal, an Enterprise Analytics IT Architect at Best Western International, Inc. A common ask from Amazon QuickSight administrators is to understand the lineage of a given dashboard (what analysis is it built from,... Hope this helps ---
**Author:** ![neelay](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/neelay/32/12168_2.png) [@neelay](https://community.amazonquick.com/u/neelay)\ **Post date:** [May 28, 2024, 4:26pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/6 "2024-05-28T16:26:08Z")
@guilopec If you are proficient with the command line, you can use the AWS CLI or the Boto3 library to build the table. Start by listing the dashboards. For each `dashboard`, use the describe command to obtain the `dataset` associated with it. Then, for each dataset, use the describe dataset command to get the `datasource` information. [https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html](https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html) refer below Apis list\_dashboards, describe\_dashboard, describe\_dashboard\_permissions, describe\_data\_set ---
**Author:** ![guilopec](https://avatars.discourse-cdn.com/v4/letter/g/919ad9/32.png) [@guilopec](https://community.amazonquick.com/u/guilopec)\ **Post date:** [June 4, 2024, 4:04pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/7 "2024-06-04T16:04:30Z")
Hello @Sanjeeb2022! I already did the list and describe for the dashboards and analysis managed by my team AWS account. The problem is that I was looking for a way to get it automated for regular basis analyses, but by doing it on CloudShell, I don’t know how to automate it as well as how to clean the data extract from CLI. Currently, I’m loading the data manually from the JSON file that I got for the list and describe to an Excel sheet. ---
**Author:** ![guilopec](https://avatars.discourse-cdn.com/v4/letter/g/919ad9/32.png) [@guilopec](https://community.amazonquick.com/u/guilopec)\ **Post date:** [June 4, 2024, 4:12pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/8 "2024-06-04T16:12:07Z")
Hi @neelay I already did that, except the part of building the table. I did the list and describe on the dashboard and analysis objects to get the relational between them, and the dataset each one originate. It will be a great improvement if I could construct the table directly on the CLI instead of manually building it on Excel after extracting the data from CloudShell. ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [June 4, 2024, 4:49pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/9 "2024-06-04T16:49:29Z")
Hi @guilopec - You can create a lambda function ( using python and boto3 api) and schedule the script via event bridge. This way you can easily automate the activity. Please give a try. Regards - Sanjeeb ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [June 24, 2024, 5:09pm UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/10 "2024-06-24T17:09:54Z")
Hi @guilopec, It’s been awhile since we last heard from you. Were you able to try Sanjeeb’s latest suggestion or are you still in need of additional assistance? If we do not hear back from you within 3 business days, I’ll go ahead and archive this topic. Thank you! ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [June 28, 2024, 3:10am UTC](https://community.amazonquick.com/t/where-can-i-see-the-relation-between-the-objects-within-my-teams-quick-sight/30264/11 "2024-06-28T03:10:19Z")