Azure SQL Data Discovery and Classification Unable to Discovery Our Tables
Data Discovery & Classification is built into Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It provides basic capabilities for discovering, classifying, labeling, and reporting the sensitive data in your databases.
However, the Data Discovery and Classification engine fails to identify a bunch of tables. At the moment, it is only able to identify our contacts table.
Can someone let me know if the table needs to be in a certain format for the Data Discovery to able to discover and classify tables?
If not, can someone explain why the Data Discovery and Classification engine is unable identify/discover other tables?
Azure SQL Data Discovery and Classification identify based on Information types of columns. It works using the column names.
To directly add classification, you can follow below steps:
Manage Information Types
To detect tables, it uses Information types of columns which are built-in as shown below it will match pattern with your column name and detect it. you can edit this Information Type by clicking on Configure and add the pattern of your column name and save it.
After creating table with column name matching the patterns mentioned in the Information Type It is successfully detecting tables.
