How can I scan views from the same Azure Synapse Analytics schema to multiple collections?

Question

I have multiple collections in Microsoft Purview. I have registered an Azure Synapse Analytics source to a parent collection. Depending on the ownership of the datasets I need to scan in views from the same schema to different collections.

When I scan a subset of views from 1 schema to a collection, views that have been added to a different collection using the same schema are removed. The views that are added to these 2 collections from the same schema are different. I nee to ensure the views are not removed from either collection.

Any help would be appreciated.

Answer 1

Hi @HR
Welcome to Microsoft Q&A platform and thanks for posting your question here.

when you scan a subset of views from 1 schema to a collection in Microsoft Purview, views that have been added to a different collection using the same schema are removed because the scan is configured to only scan the selected views for that specific collection. This means that if you have the same views in multiple collections, and you scan a subset of those views for one collection, the views that are not included in that subset will be removed from that collection.

To avoid this issue and ensure that the views are not removed from either collection, you can create separate scans for each collection and configure each scan to scan only the required views. By doing so, you can ensure that each scan is only scanning the views that are required for that specific collection, and the views that are not included in the scan will not be removed from that collection.

By creating separate scans for each collection, you can optimize the scan performance by scanning only the required views for each collection. This can help reduce the time and resources required for the scan.

Reference
https://learn.microsoft.com/en-us/purview/how-to-create-and-manage-collections

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.

Answer 2

In Microsoft Purview, asset mappings allow you to determine how different assets are assigned to collections based on specific criteria. You can set up asset mapping rules that differentiate the assets based on your required criteria (for example naming conventions, metadata).

https://learn.microsoft.com/en-us/purview/how-to-metamodel

You can configure scoped scans to only include specific views in each scan. This way, you can ensure that only the views relevant to a particular collection are scanned into that collection, without affecting the views in other collections.

Customize the settings of each scan to target different views. You can do this by specifying filters or SQL queries within the scan settings that limit the scope of the scan to only the views you want to include in each collection.