Reporting on Purview in Databricks

Question

I am looking to create a notebook that can connect & ingest purview data (in particular Data Assets & their Owners) & create a table in Databricks to allow reporting/sharing

Answer 1

@Cross87 - Thanks for the question and using MS Q&A platform.

To connect and ingest Purview data in Databricks, you can use the Purview REST API to retrieve the data assets and their owners. You can then use the Databricks API to create a table in Databricks to allow reporting and sharing.

Exporting Data Assets from Microsoft Purview using the REST API in Python enables a streamlined process to retrieve structured metadata and asset information. By leveraging the REST API and Python, users can effortlessly access and export Data Assets, ensuring a programmatic and efficient approach. The powerful combination of the REST API and Python empowers users with flexibility and automation capabilities, facilitating the extraction of Microsoft Purview Data Assets and seamless integration with various data management and analytics workflows.

For more details, refer to Exporting Microsoft Purview Data Assets using the REST API and Exploring Purview’s REST API with Python.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.