https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6280#M2466 <P>What if the table is not in unity, is there other way to get the data lineage?</P> Tue, 11 Apr 2023 21:54:39 GMT Kit 2023-04-11T21:54:39Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6276#M2462 <P>I want to deprecate a query from our workspace. However, I don't know if there is any downstream dashboard needs it.</P><P></P><P>In case there is downstream dependency, then I can't just delete the query.</P><P></P><P>I tried the search by query name, but it only returns the query but not dashboards that use that query.</P><P></P><P>How can I get the list of downstream dashboards of a query?</P> Fri, 07 Apr 2023 05:13:50 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6276#M2462 Kit 2023-04-07T05:13:50Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6277#M2463 <P>2 questions:</P><UL><LI>do you mean Databricks dashboards?</LI><LI>have you enabled Unity?</LI></UL> Fri, 07 Apr 2023 07:03:19 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6277#M2463 -werners- 2023-04-07T07:03:19Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6278#M2464 <P>&gt; do you mean Databricks dashboards</P><P>yes</P><P>&gt; have you enabled Unity?</P><P>yes</P> Mon, 10 Apr 2023 22:33:25 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6278#M2464 Kit 2023-04-10T22:33:25Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6279#M2465 <P>databricks dashboards are included in the data lineage part of Unity.</P><P><A href="https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/data-lineage" target="test_blank">https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/data-lineage</A></P> Tue, 11 Apr 2023 07:03:08 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6279#M2465 -werners- 2023-04-11T07:03:08Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6280#M2466 <P>What if the table is not in unity, is there other way to get the data lineage?</P> Tue, 11 Apr 2023 21:54:39 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6280#M2466 Kit 2023-04-11T21:54:39Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6281#M2467 <P>hm I doubt that, not without extra software.</P> Wed, 12 Apr 2023 06:30:08 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6281#M2467 -werners- 2023-04-12T06:30:08Z https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6282#M2468 <P>Databricks support suggests me to check the query history, to find out any history of the query, then check which dashboard is using it.</P><P></P><P>Not an ideal solution but it works for me.</P> Tue, 25 Apr 2023 04:15:58 GMT https://community.databricks.com/t5/data-engineering/how-can-i-get-the-list-of-downstream-dashboards-of-a-query/m-p/6282#M2468 Kit 2023-04-25T04:15:58Z