Password

identity.person.password

Authentication credential. Broad categorization due to high variance in format and strength requirements. Should never be stored in plaintext. Hash or encrypt passwords immediately.

Domain

identity

Try it

CLI

$ finetype infer -i "aB3#xY9@mK2"
→ identity.person.password

DuckDB

Detect

SELECT finetype('aB3#xY9@mK2');
-- → 'identity.person.password'

Cast expression

CAST({col} AS VARCHAR)

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.person.password';

JSON Schema

finetype schema identity.person.password

{
  "$id": "https://meridian.online/schemas/identity.person.password",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Authentication credential. Broad categorization due to high variance in format and strength requirements. Should never be stored in plaintext. Hash or encrypt passwords immediately.",
  "examples": [
    "aB3#xY9@mK2",
    "MySecureP@ss123",
    "correct-horse-battery-staple"
  ],
  "maxLength": 255,
  "minLength": 1,
  "title": "Password",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

aB3#xY9@mK2MySecureP@ss123correct-horse-battery-staple