Cryptographic Hash

technology.cryptographic.hash

Output of a cryptographic hash function (MD5, SHA-1, SHA-256, etc.). Detected as hex string of fixed length. Broad categorization by length.

Domain

technology

Try it

CLI

$ finetype infer -i "5d41402abc4b2a76b9719d911017c592"
→ technology.cryptographic.hash

DuckDB

Detect

SELECT finetype('5d41402abc4b2a76b9719d911017c592');
-- → 'technology.cryptographic.hash'

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) = 'technology.cryptographic.hash';

Struct Expansion

Expression

algorithm: CASE WHEN LENGTH({col}) = 32 THEN 'MD5' WHEN LENGTH({col}) = 40 THEN 'SHA1' WHEN LENGTH({col}) = 64 THEN 'SHA256' WHEN LENGTH({col}) = 128 THEN 'SHA512' ELSE 'UNKNOWN' END

JSON Schema

finetype schema technology.cryptographic.hash

{
  "$id": "https://meridian.online/schemas/technology.cryptographic.hash",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Output of a cryptographic hash function (MD5, SHA-1, SHA-256, etc.). Detected as hex string of fixed length. Broad categorization by length.",
  "examples": [
    "5d41402abc4b2a76b9719d911017c592",
    "aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d",
    "2c26b46911185131006dfb3b57a99d73"
  ],
  "pattern": "^[0-9a-f]{32}$|^[0-9a-f]{40}$|^[0-9a-f]{64}$|^[0-9a-f]{128}$",
  "title": "Cryptographic Hash",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

5d41402abc4b2a76b9719d911017c592aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d2c26b46911185131006dfb3b57a99d73