Tools

OpenMetadata auto-classification

ID openmetadata

catalogs

OpenMetadata's auto-classification workflow samples table columns and tags them PII.Sensitive or PII.NonSensitive. It matches column names against regular expressions and checks sampled values with Microsoft Presidio recognizers and a spaCy model. Each PII tag holds a list of recognizers that administrators can change; the default list, seeded from piiTagsWithRecognizers.json, covers card numbers, IBAN, email, IP addresses, phone numbers, person names and national identifiers of the US, UK, Spain, Italy, Poland, Singapore, Australia, India and Finland.

Website
https://docs.open-metadata.org/latest/how-to-guides/data-governance/classification/auto-classification/auto-pii-tagging
Supported types
47

Supported semantic types

IDNameCategoriesCountriesDescription
aadhaar Indian Aadhaar number by known name PII pii, persons IN Indian Aadhaar number by known name identifier
aba US ABA routing number draft finances global Datatype for 'US ABA routing number' (aba) from rules in context 'finances'.
abaroutingnum American Banking Association (ABA) routing number finances US In the United States, an ABA routing transit number (ABA RTN) is a nine-digit code printed on the bottom of checks to identify the...
abn Australian ABN (Australian Business Number) by known name finances AU Australian ABN (Australian Business Number) by known name identifier
auabn Australian Business Number (ABN) companies AU The Australian Business Number (ABN) is a unique 11-digit identifier issued by the Australian Business Register (ABR) which is operated...
auacn Australian Company Number (ACN) companies AU An Australian Company Number (usually shortened to ACN) is a unique identifier required by every company registered under Australia’s...
aumedicarenum Australian medicare number PII pii, persons AU Medicare number is a unique identifier issued by Australian Government that enables the cardholder to receive a rebates of medical...
autfn Australian Tax File Number (TFN) PII pii, persons AU The tax file number (TFN) is a unique identifier issued by the Australian Taxation Office to each taxpaying entity — an individual,...
bankcard Bank card (credit/debit card) PII pii, finances global A bank card is typically a plastic card issued by a bank to its clients that performs one or more of a number of services that relate to...
bankcard_cvv Payment card security code (CVV, CVC, CID) PII draft pii, finances global Short code printed on a payment card that card-not-present transactions use to show that the payer holds the card. Visa calls it CVV2,...
date Date datetime global Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype.
email Email address PII common, internet, pii global Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,...
esnie Spanish Foreigner Identity Number (NIE) PII pii, persons ES The NIE is a tax identification number in Spain, known in Spanish as the NIE, or more formally the Numero de identidad de extranjero
esnif Spanish Tax identification number PII pii, persons ES Spanish tax identification number used to identify tax paying individuals
fi_hetu Finnish personal identity code (HETU) PII draft pii, persons FI Henkilötunnus, the personal identity code of people registered in Finland. It is the date of birth (DDMMYY), a century sign (+ for the...
iban International Bank Account Number finances global The International Bank Account Number (IBAN) is an internationally agreed system of identifying bank accounts across national borders to...
in_epic Indian voter ID card number (EPIC) PII draft pii, persons IN Number of the Indian Electors Photo Identity Card (voter ID) issued by the Election Commission of India: three letters and seven digits.
ipaddr IP address (IPv4 or IPv6) PII internet, pii global Address of a network interface in the Internet Protocol: a 32-bit IPv4 address in dotted-decimal form (192.0.2.1) or a 128-bit IPv6...
it_codicefiscale Italian tax code (codice fiscale) PII draft pii, persons IT Codice fiscale, the tax code of people in Italy, issued by the Agenzia delle Entrate: 16 characters derived from the surname, the first...
it_driver_license Italian driver's license number PII draft pii, persons IT Number of a driving licence issued in Italy. Microsoft Purview looks for ten letters and digits: a letter, a letter or digit, seven...
it_id_card Italian identity card number PII draft pii, persons IT Number of an Italian identity card (carta d'identità). The electronic card (CIE) issued since 2016 has nine characters: two letters,...
it_iva Italian VAT number (partita IVA) draft finances IT Partita IVA, the 11-digit VAT number in Italy: seven digits that identify the taxpayer, a 3-digit tax office code (mostly the province...
it_passport Italian passport number PII pattern draft pii, persons IT Number of a passport issued by Italy. Microsoft Purview looks for two letters or digits and seven digits.
medicare Australian Medicare number by known name PII draft pii, persons AU Australian Medicare number by known name identifier
nhsnumber NHS number PII draft pii global Datatype for 'NHS number' (nhsnumber) from rules in context 'pii'.
nif NIF por nombre de campo PII finances ES ES datatype for 'NIF por nombre de campo' (nif) from rules in context 'finances'. The Spanish tax identification number (Número de...
nric Singapore NRIC (National Registration Identity Card) by known name PII finances SG Singapore NRIC (National Registration Identity Card) by known name identifier
p2pkhaddr Bitcoin P2PKH address cryptocurrency global Legacy Bitcoin address of the pay-to-public-key-hash (P2PKH) type. It is the Base58Check encoding of the version byte 0 and the 20-byte...
p2shaddr Bitcoin P2SH address cryptocurrency global Bitcoin address of the pay-to-script-hash (P2SH) type, defined by BIP 13 and BIP 16. It is the Base58Check encoding of the version byte...
p2wpkhaddr Bitcoin P2WPKH address (native SegWit, bc1q) cryptocurrency global Native SegWit address of the pay-to-witness-public-key-hash (P2WPKH) type: witness version 0 with a 20-byte public key hash (BIP 141),...
p2wshaddr Bitcoin P2WSH address (native SegWit, bc1q) cryptocurrency global Native SegWit address of the pay-to-witness-script-hash (P2WSH) type: witness version 0 with the 32-byte SHA-256 hash of a witness...
pan Indian PAN (Permanent Account Number) by known name PII pii, persons IN Indian PAN (Permanent Account Number) by known name identifier
person_fullname Person fullname PII draft persons, pii global Full name of the person as combination of last, first, and sometimes middle name
phone Phone number PII pii, common, telecom global Telephone number in standard format (RFC3966), without 'tel:' prefix
plpesel Polish PESEL by field name PII pii, persons PL Polish PESEL by field name identifier
sg_uen Singapore Unique Entity Number (UEN) draft companies SG Identification number that the government of Singapore gives to every entity that operates in Singapore: businesses, local companies,...
sgnric The Singapore National Registration Identity Card (NRIC) PII pii, persons SG The National Registration Identity Card (NRIC) is the compulsory identity document issued to citizens and permanent residents of Singapore.
tfn Australian TFN (Tax File Number) by known name PII finances AU Australian TFN (Tax File Number) by known name identifier
uknhsnum UK NHS Number PII pii, persons, medical GB NHS numbers are the unique numbers allocated to registered users of the three public health services in England, Wales and the Isle of...
uknino UK National Insurance number PII pii, persons GB The National Insurance number is a number used in the United Kingdom in the administration of the National Insurance or social security...
url Uniform Resource Locator (URL) common, internet global Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query...
usbankaccount Bank account in United States pattern finances US A bank account in the financial institutuin in United States
usdeanumber USA DEA Registration (cerficicate) Number PII pii, persons, medical US A DEA number (DEA Registration Number) is an identifier assigned to a health care provider (such as a physician, physician assistant,...
usdriverlic US driver license number PII pii, persons US Alphanumeric value of the United States driver license
usitin US ITIN (Individual Taxpayer Identification Number) PII pii, persons US A Taxpayer Identification Number (TIN) is an identifying number used for tax purposes in the United States and in other countries under...
uspassport US passport number PII pattern draft pii, persons US Number of US Passport
usssn US Social Security Number PII pii, persons US In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary...

Use this record