technology.cryptographic.token_hexRandom token as hex string (e.g., secure session tokens). Distinguished from cryptographic hashes by variable length that does NOT match standard hash lengths (32=MD5, 40=SHA1, 64=SHA256, 128=SHA512). Tokens are typically 16-48 hex chars at non-standard lengths.
$ finetype infer -i "a1b2c3d4e5f67890ab"
→ technology.cryptographic.token_hexSELECT finetype('a1b2c3d4e5f67890ab');
-- → 'technology.cryptographic.token_hex'CAST({col} AS VARCHAR)-- 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) = 'technology.cryptographic.token_hex';{
"$id": "https://meridian.online/schemas/technology.cryptographic.token_hex",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Random token as hex string (e.g., secure session tokens). Distinguished from cryptographic hashes by variable length that does NOT match standard hash lengths (32=MD5, 40=SHA1, 64=SHA256, 128=SHA512). Tokens are typically 16-48 hex chars at non-standard lengths.",
"examples": [
"a1b2c3d4e5f67890ab",
"1234567890abcdef1234",
"deadbeefcafebabe00ff11"
],
"pattern": "^[0-9a-f]{16,48}$",
"title": "Hexadecimal Token",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}a1b2c3d4e5f67890ab1234567890abcdef1234deadbeefcafebabe00ff11