Default data patterns

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read
  • Review the default data pattern regular expressions included in Data Discovery. These default data patterns can be used to filter table entries for further classification.

    The following are available default patterns for data discovery.

    Name Regular Expression
    Credit Card- Visa \b4[0-9]{12}(?:[0-9]{3})?\b
    Credit Card- American Express \b3[47][0-9]{13}\b
    Credit Card- Mastercard \b(?:5[1-5][0-9]{2}|222[1-9]|22[3-9][0-9]|2[3-6][0-9]{2}|27[01][0-9]|2720)[0-9]{12}\b
    Credit Card- Diners Club \b3(?:0[0-5]|[68][0-9])[0-9]{11}\b
    Credit Card- Discover \b6(?:011|5[0-9]{2})[0-9]{12}\b
    Social security number \b(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}\b
    Email \b[\w!#$%&'*+/=?`{|}~^-]+(?:\.[\w!#$%&'*+/=?`{|}~^-]+)*@(?:[a-zA-Z0-9-]+\.)+[a-zA-Z]{2,6}\b
    USA- Phone Number \b\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})\b