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.
Password
identity.person.passwordAuthentication 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
Category
person
Casts to
VARCHAR
Scope
broad_characters
Try it
CLI
$ finetype infer -i "aB3#xY9@mK2"
→ identity.person.passwordDuckDB
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-pii": true,
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}Examples
aB3#xY9@mK2MySecureP@ss123correct-horse-battery-staple