Microsoft Purview has introduced a public preview of a feature that allows for separation of scan levels for Azure SQL Database and Snowflake. Previously, scan levels couldn't be separated, limiting flexibility in the scanning process.
Data source administrators can now customize scan levels to better suit their needs, with an "Auto detect" setting available by default which selects the highest scan level. For example, Azure SQL Database will default to a Level-3 scan since it supports classification.
This new feature streamlines scanning by automatically applying the most appropriate scan level to data sources based on their capabilities. Moreover, administrators can select a lower scan level to reduce workload impacts or a higher one for comprehensive data analyses.
These flexible scanning options accommodate various usage scenarios, such as fast data profiling at Level-1 or detailed classification for governance at Level-3. This feature is part of an ongoing expansion, currently available for Azure SQL Database and Snowflake on Azure IR and Managed VNet IR v2.
Microsoft Purview's data management capabilities ensure that organizations can keep a handle on their data assets across diverse platforms like Azure SQL Database and Snowflake. With the introduction of customizable scan levels, administrators can now exercise greater control over the scanning process, ensuring that they can tailor the scope and detail of the scans to their specific requirements. Rather than employing a one-size-fits-all approach, the ability to distinguish between L1, L2, and L3 scans empowers teams to parse through their data swiftly for basic insights or dive deeper for meticulous classification and schema extraction. This not only enhances efficiency and saves resources but also aligns with the growing demand for flexible, scalable data governance frameworks that can adapt to different operational demands and compliance requirements.
Microsoft has announced a public preview of a feature enabling separation of scan levels in Microsoft Purview. This feature applies to Azure SQL Database and Snowflake scanning processes. Scan levels determine the depth of metadata analysis, with higher levels providing more detailed insights.
There are three primary scan levels defined: L1 scan gathers basic file information, L2 scans extract schema details for structured files and databases, and L3 scans incorporate data sampling and apply classification rules. Until now, these levels were inseparable in the scanning process. This meant users were unable to disable specific aspects like data sampling on classifications.
This new feature introduces flexibility, allowing users to customize scanning processes for different databases, such as Azure SQL Database and Snowflake. When setting up new scans or adjusting existing ones for Azure SQL Database, administrators will notice an option to set scan levels. This can tailor scanning operations to specific needs, enhancing usage scenarios.
Azure SQL Database Scan Levels, Snowflake Microsoft Purview, Public Preview Azure SQL, Microsoft Purview Separation Scan, Azure SQL Snowflake Integration, Microsoft Purview Snowflake Features, Azure Database Security Scanning, Snowflake Scan in Purview, Azure SQL Purview Update, Snowflake Data Governance Azure