Sensitive data discovery
Also called data discovery and classification, sensitive data classification, PII discovery
Sensitive data discovery is the automated process of finding and classifying data that needs protection, such as personal, financial, health or secret information, across databases, file stores and cloud services, so it can be inventoried, monitored and secured.
Organisations rarely know every place their sensitive data lives. Customer records get copied into reporting schemas, test databases and spreadsheets; new columns appear with each release. Sensitive data discovery scans these stores, labels what it finds, and keeps that map current, so that access controls, monitoring and audit can focus on the data that matters.
How it works
Discovery tools combine several techniques:
| Technique | How it works | Trade-off |
|---|---|---|
| Pattern matching | Regular expressions and checksums for card numbers, IDs and similar | Precise for structured formats, blind to context |
| Machine learning or AI classification | Models judge whether content or metadata looks sensitive | Covers fuzzy cases, needs review |
| Exact data match | Compares against a list of known sensitive values | Very precise, needs the source list |
| Metadata classification | Reads column names, types and catalog information only | Never touches values, may miss misnamed fields |
Cloud vendors document these methods. Amazon Macie discovers sensitive data in S3 using machine learning and pattern matching, with managed and custom data identifiers and sampling for automated discovery. Microsoft Purview classifies content with sensitive information types, exact data match, trainable classifiers and credential detection.
Why it matters
Controls depend on knowing where data is. NIST SP 800-122 gives context-based guidance for identifying PII and choosing a protection level for each instance. NIST SP 800-53 Rev. 5 control PM-5(1) requires an inventory of systems that process personally identifiable information, and RA-2 requires categorising systems by the information they hold. Discovery also feeds database activity monitoring: an alert on a mass read only works if the table has been flagged as sensitive.
Sensitive data discovery vs DLP
Discovery finds and labels sensitive data at rest. Data loss prevention uses those labels to control data in motion, for example blocking an email or upload. DLP without discovery has little to go on; discovery without monitoring or DLP produces a map nobody acts on.
Examples
- A new
customer_dobcolumn in a reporting schema is classified as personal data the day after it is created. - A table of card numbers in a test database is flagged and moved behind stricter access.
- A security team limits mass-read alerts to tables classified as personal or financial.
How SWOT supports it
In SWOT DAM, the Sensitive Data Sentinel classifies new columns every 24 hours as personal, financial, health or secret data with an AI model. It reads the catalog, so it sees column names and types, never the values. You choose the model: OpenAI, your own Azure OpenAI deployment, or Ollama on your own server so nothing leaves the network. Flagged tables then drive alerts such as mass reads of PII. See database security.
Questions
- Does sensitive data discovery need to read the data itself?
- Not always. Content scanning samples or reads values and matches them against patterns or models, which finds sensitive data in free text but exposes values to the scanner. Metadata classification looks only at catalog information such as column names and types, which never touches values but can miss data stored in badly named fields. Many programmes use both.
- How often should discovery run?
- Continuously or on a short schedule, because schemas and buckets change. New tables, columns and files appear with every release, and a classification done once at the start of an audit is out of date within weeks. Running discovery daily or on each schema change keeps the inventory, and the monitoring that depends on it, current.
In SWOT
Sources
Related terms
- Database activity monitoring (DAM)Database activity monitoring (DAM) is the practice of capturing, analysing and alerting on who does what inside a database, including queries, schema changes, privilege grants and sign-ins, so that misuse is detected and every action is attributable.
- Least privilegeLeast privilege is the security principle that every user, process and system should hold only the access rights it needs to perform its assigned tasks, and nothing more, so that a mistake or compromise affects as little as possible.
- Zero trustZero trust is a security model that grants no implicit trust based on network location or asset ownership, and instead authenticates, authorises and evaluates every request to a resource on its own merits, with least privilege, before and during each session.
- Identity securityIdentity security is the discipline of protecting every human and machine identity, together with its credentials and entitlements, across its lifecycle, so that only verified identities gain the access they need and misuse of that access is detected quickly.
