Databricks Unity Catalog data classification
ID databricks
pii
Data classification in Databricks Unity Catalog scans the tables of a catalog with an AI agent and tags columns with classes such as class.email_address, class.iban_code or class.us_ssn. Global classes apply everywhere; regional classes for national identifiers are detected only in the matching cloud regions.
- Website
- https://docs.databricks.com/aws/en/data-governance/unity-catalog/data-classification-tags
- Supported types
- 83
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| aadhaar | Indian Aadhaar number by known name PII | pii, persons | IN | Indian Aadhaar number by known name identifier |
| aeemiratesid | UAE Emirates ID Number PII | pii, persons | AE | UAE Emirates ID number used for identification of UAE citizens and residents |
| age | Age PII draft | datetime | global | Age of the person or organization in years |
| 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,... |
| bankaccount | Bank account | finances | global | A bank account is a financial account maintained by a bank or other financial institution in which the financial transactions between... |
| 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,... |
| bankcard_expiry | Payment card expiration date draft | finances, datetime | global | Month and year after which a payment card is no longer valid, printed on the card next to the card number. Payment card rules treat it... |
| bic | SWIFT/BIC code draft | finances | global | Datatype for 'SWIFT/BIC code' (bic) from rules in context 'finances'. |
| birthday | Birthday PII | pii, datetime | global | A birthday is the anniversary of the birth of a person, or figuratively of an institution. Birthdays of people are celebrated in... |
| brcpf | CPF number (Cadastro de Pessoas Fisicas) PII | pii, persons | BR | The CPF number (Cadastro de Pessoas Fisicas; Portuguese for Natural Persons Register) is the Brazilian individual taxpayer registry,... |
| bsn | Dutch citizen service number (BSN) PII | pii, persons, finances | NL | Burgerservicenummer (BSN), the personal number of everyone registered in the Dutch population register (BRP). It replaced the sofinummer... |
| ca_pr_card | Canadian permanent resident card number PII draft | pii, persons | CA | Document number of the permanent resident card, the status document that Immigration, Refugees and Citizenship Canada (IRCC) issues to... |
| casin | Canada social insurance number (SIN) PII | pii, persons | CA | Social insurance number (SIN) is a number issued in Canada to administer various government programs. |
| chahv | Swiss AHV Number PII | pii, persons | CH | Swiss AHV (Alters- und Hinterlassenenversicherung) social security number |
| cif | CIF por nombre de campo PII | finances | ES | ES datatype for 'CIF por nombre de campo' (cif) from rules in context 'finances'. The CIF (Código de Identificación Fiscal) is a Spanish... |
| cnpj | Brazilian CNPJ (Cadastro Nacional de Pessoa Jurídica) by known name | finances | BR | Brazilian CNPJ (Cadastro Nacional de Pessoa Jurídica) by known name identifier |
| cpf | Brazilian CPF (Cadastro de Pessoa Física) by known name PII | finances | BR | Brazilian CPF (Cadastro de Pessoa Física) by known name identifier |
| curp | Mexican CURP (Clave Única de Registro de Población) by known name PII | common | MX | Mexican CURP (Clave Única de Registro de Población) by known name identifier |
| depersonalausweis | German identity card number (Personalausweis) PII | pii, persons | DE | Serial number (Ausweisnummer) of a German identity card (Personalausweis). Cards issued since 1 November 2010 have nine characters: a... |
| dkcprnum | CPR-Number, Personal identification number (Denmark) PII | pii, persons | DK | The Danish Personal Identification number is a national identification number, which is part of the personal information stored in the... |
| driver_license | Driver's license number (universal) PII draft | pii, persons | global | Number of a driving licence, the document that a public authority issues to allow a person to drive motor vehicles. Each country or... |
| 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,... | |
| es_dni | Spanish national identity document number (DNI) PII draft | pii, persons | ES | Documento Nacional de Identidad, the identity number of Spanish citizens: eight digits and a check letter, which is the number modulo 23... |
| 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 |
| fr_nif | French tax identification number (numéro fiscal) PII draft | finances, pii | FR | Numéro fiscal de référence, also called NIF or SPI number, the 13-digit number that the French tax administration gives to each person... |
| frcni | French national identity card PII | pii, persons | FR | The French national identity card (CNI) is an official identity document consisting of an electronic ID-1 card bearing a photograph,... |
| frnir | French social security number (NIR) PII | pii, persons | FR | French national identification number (numéro d'inscription au répertoire, NIR), known as the social security number. INSEE assigns it... |
| gender | Gender PII draft | pii, persons | global | Gender flag and/or any other identification value |
| geopoint | Geopoint draft | geo | global | Basic geopoint as coordinates |
| hk_hkid | Hong Kong identity card number (HKID) PII draft | pii, persons | HK | Number of the Hong Kong identity card: one or two letters, six digits and a check character (a digit or A), which is often written in... |
| 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... |
| idcard | Chinese ID card (身份证) by known name PII | pii, persons | CN | Citizen identification number of the People's Republic of China, printed on the Resident Identity Card (居民身份证). Since 1999 it has 18... |
| il_idnr | Israeli identity number (Mispar Zehut) PII draft | pii, persons | IL | Mispar Zehut (מספר זהות), the 9-digit identity number given to Israeli citizens at birth. The last digit is a Luhn check digit; leading... |
| imei | International Mobile Equipment Identity (IMEI) PII | telecom, pii | global | Number that identifies a mobile device of 3GPP networks (GSM, UMTS, LTE, 5G) and of some satellite networks. It has 15 digits; the... |
| 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_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... |
| jp_pension_number | Japanese basic pension number PII draft | pii, persons | JP | Ten-digit number that identifies a person across all Japanese public pension schemes. It was introduced in January 1997 and stays the... |
| krbusinessreg | Korean business registration number by field name | finances | KR | Korean business registration number by field name identifier |
| krrrn | Korean RRN by field name PII | pii, persons | KR | Korean RRN by field name identifier |
| mac_address | MAC address (Media Access Control) PII | internet, identifiers, pii | global | 48-bit hardware address (EUI-48) of a network interface in Ethernet, Wi-Fi, Bluetooth and other IEEE 802 networks, used to deliver... |
| marital_status | Marital status PII draft | persons, pii | global | Civil status of a person with respect to marriage: single, married, divorced, widowed, separated or in a civil partnership. Data sets... |
| medicare | Australian Medicare number by known name PII draft | pii, persons | AU | Australian Medicare number by known name identifier |
| mynumber | Japanese My Number (マイナンバー) by known name PII | pii, persons | JP | Japanese My Number (マイナンバー) by known name identifier |
| nhsnumber | NHS number PII draft | pii | global | Datatype for 'NHS number' (nhsnumber) from rules in context 'pii'. |
| no_fodselsnummer | Norwegian national identity number (fødselsnummer) PII draft | pii, persons | NO | Fødselsnummer, the 11-digit national identity number in Norway, kept in the National Population Register by the Norwegian Tax... |
| npi | US NPI identifier PII draft | medical | global | Datatype for 'US NPI identifier' (npi) from rules in context 'medical'. |
| nric | Singapore NRIC (National Registration Identity Card) by known name PII | finances | SG | Singapore NRIC (National Registration Identity Card) by known name identifier |
| nz_ird | New Zealand IRD number PII draft | finances | NZ | Inland Revenue Department number (Te Tari Taake), the tax number of individuals and businesses in New Zealand. It has eight or nine... |
| nz_nhi | New Zealand National Health Index number (NHI) PII draft | pii, persons, medical | NZ | National Health Index number assigned by the New Zealand Ministry of Health. Microsoft Purview looks for three letters other than I and... |
| nz_nzbn | New Zealand Business Number (NZBN) draft | companies | NZ | New Zealand Business Number (NZBN), the 13-digit identifier of a business, charity, trust or government body in New Zealand.... |
| pan | Indian PAN (Permanent Account Number) by known name PII | pii, persons | IN | Indian PAN (Permanent Account Number) by known name identifier |
| passport | Person passport number (universal) PII draft | pii, persons | global | Person passport, usually unique personal information that should be shared online. Identifies personal document issued to person by... |
| 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 |
| race_ethnicity | Race or ethnicity PII draft | persons, pii | global | Race or ethnic group of a person as recorded in surveys, health records and administrative data, for example Asian, Black or African... |
| religion | Religion PII draft | persons, pii | global | Religion, religious denomination or worldview of a person or a group, such as Catholic, Sunni Islam or Buddhism. Censuses and surveys... |
| rfc | Mexican RFC (Registro Federal de Contribuyentes) by known name PII | finances | MX | Mexican RFC (Registro Federal de Contribuyentes) by known name identifier |
| rg | Brazilian RG (Registro Geral) by known name PII | common | BR | Brazilian RG (Registro Geral) by known name identifier |
| sepersonnummer | Sweden personal identity number (personnummer) PII | pii, persons | SE | The personal identity number (Swedish: personnummer) is the Swedish national identification number. It is a ten digit number that is... |
| 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. |
| steuerid | German tax identification number (Steuer-ID, IdNr.) PII | finances, pii | DE | Steuerliche Identifikationsnummer (IdNr., Steuer-ID), the personal tax number that the Federal Central Tax Office (BZSt) assigns once to... |
| street_address | Street address line PII draft | geo, pii | global | First line of a postal address: the house or building number and the street name, such as 10 Downing Street or Unter den Linden 77. The... |
| swiftcode | Bank SWIFT code (ISO 9362) | finances | global | ISO 9362 defines a standard format of Business Identifier Codes (also known as SWIFT-BIC, BIC, SWIFT ID or SWIFT code) approved by the... |
| 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... |
| uksortcode | UK sort code draft | finances | global | Datatype for 'UK sort code' (uksortcode) from rules in context 'finances'. |
| ukutr | Unique Taxpayer Reference (UTR) PII | pii, persons | GB | A UTR (unique taxpayer reference) number is a 10-digit number completely unique to each and every UK taxpayer. |
| 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 |
| 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... |
| usnpi | US National Provider Identifier (NPI) PII | pii, persons | US | A National Provider Identifier (NPI) is a unique 10-digit identification number issued to health care providers in the United States by... |
| 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... |
| vehiclenumber | Vehicle number draft | transport | global | Number of the vehicle (vehicle plate number) |
| vin | Vehicle Identification Number by field name draft | transport | global | Vehicle Identification Number by field name number |
| za_id | South African identity number PII draft | pii, persons | ZA | South African identity number: 13 digits made of the date of birth (YYMMDD), four digits, a citizenship digit, a digit that is usually 8... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/pii/databricks.yamlon GitHub