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.
UUID
representation.identifier.uuidUniversally 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
Category
identifier
Casts to
UUID
Scope
Universal
Try it
CLI
$ finetype infer -i "550e8400-e29b-41d4-a716-446655440000"
→ representation.identifier.uuidDuckDB
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": "UUID",
"x-finetype-transform": "CAST({col} AS UUID)"
}Examples
550e8400-e29b-41d4-a716-4466554400006ba7b810-9dad-11d1-80b4-00c04fd430c8f47ac10b-58cc-4372-a567-0e02b2c3d479Aliases
guid