Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
529 questions
Limit the scope of Scan in Azure Synapse
Sharma, Praghya (CONTRACTOR)
0
Reputation points
Hello,
If I want to scan certain tables only in Azure Synapse via Purview is it possible to select desired tables and scan only those?
Any recommendation here?
{count} votes
-
ShaikMaheer-MSFT 31,721 Reputation points Microsoft Employee2023-05-25T13:30:18.87+00:00 Hi Sharma, Praghya (CONTRACTOR),
Thank you for posting query in Microsoft Q&A Platform.
I guess it is possible to scan only certain tables in Azure Synapse Analytics via Purview. Here are some steps you can take to select the desired tables and scan only those:
Create a new scan: Go to the Purview portal and select the "Data Map" tab. From there, you can create a new scan for your Azure Synapse Analytics data source.
Select the tables to scan: In the scan settings, you can select the tables you want to scan by specifying a list of table names or patterns. You can also use the "Exclude by name" option to exclude specific tables from the scan.
Configure the scan settings: In the scan settings, you can configure various options for the scan, such as the scan frequency, the depth of the scan, and the types of metadata to collect.
Run the scan: Once you have configured the scan settings, you can run the scan to collect metadata for the selected tables.
Review the results: After the scan is complete, you can review the results in the Purview portal. The results will include metadata for the selected tables, such as column names, data types, and descriptions.
It's worth noting that scanning only certain tables may not provide a complete view of your data landscape, especially if there are dependencies between tables. You may want to consider scanning all tables and using custom classification rules or tags to filter out tables that do not meet your criteria.
Additionally, you should consider the impact of the scan on your Synapse Analytics environment. Scanning large tables or running frequent scans can impact performance and increase costs. You should carefully consider the scan settings and schedule to minimize the impact on your environment.
Please let me know how it goes. Thank you.
-
ShaikMaheer-MSFT 31,721 Reputation points Microsoft Employee
2023-05-29T11:58:32.9133333+00:00 Hi Sharma, Praghya (CONTRACTOR), Just checking if you get chance to share updates. Please let me know if any further queries.
Please consider hitting
Accept Answerbutton if above helps. Accepted answers help community as well. Thank you. -
ShaikMaheer-MSFT 31,721 Reputation points Microsoft Employee
2023-05-30T16:13:47.96+00:00 Hi Sharma, Praghya (CONTRACTOR), Just checking if below answer helps. If yes, please consider hitting
Accept Answerbutton. Accepted answers help community as well. Please let me know if any further queries. -
Sharma, Praghya (CONTRACTOR) 0 Reputation points
2023-06-01T11:27:12.2566667+00:00 @ShaikMaheer-MSFT it doesn't work like this, we don;t have exclude by name option in purview. Please check and confirm again.
-
Sharma, Praghya (CONTRACTOR) 0 Reputation points
2023-06-01T11:28:49.4333333+00:00 @ShaikMaheer-MSFT it doesn't work like this, we don;t have exclude by name option in purview. Please check and confirm again.
-
ShaikMaheer-MSFT 31,721 Reputation points Microsoft Employee
2023-06-01T13:46:03.1866667+00:00 Hi Sharma, Praghya (CONTRACTOR), Apologies, Yes It seems its currently product limitation.
Sign in to comment