UUID

representation.identifier.uuid

Universally Unique Identifier (RFC 4122). Standard formats include UUID v1 (timestamp-based), v4 (random), and v5 (name-based). Canonical format: 8-4-4-4-12 hex groups with hyphens.

Domain

representation

Try it

CLI

$ finetype infer -i "550e8400-e29b-41d4-a716-446655440000"
→ representation.identifier.uuid

DuckDB

Detect

SELECT finetype('550e8400-e29b-41d4-a716-446655440000');
-- → 'representation.identifier.uuid'

Cast expression

CAST({col} AS UUID)

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS UUID) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.identifier.uuid';

JSON Schema

finetype schema representation.identifier.uuid

{
  "$id": "https://meridian.online/schemas/representation.identifier.uuid",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Universally Unique Identifier (RFC 4122). Standard formats include UUID v1 (timestamp-based), v4 (random), and v5 (name-based). Canonical format: 8-4-4-4-12 hex groups with hyphens.",
  "examples": [
    "550e8400-e29b-41d4-a716-446655440000",
    "6ba7b810-9dad-11d1-80b4-00c04fd430c8",
    "f47ac10b-58cc-4372-a567-0e02b2c3d479"
  ],
  "pattern": "^[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}$",
  "title": "UUID",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS UUID)"
}

Examples

550e8400-e29b-41d4-a716-4466554400006ba7b810-9dad-11d1-80b4-00c04fd430c8f47ac10b-58cc-4372-a567-0e02b2c3d479

Aliases

guid