URN
Uniform Resource Name — a persistent, location-independent identifier in the format urn:nid:nss. Used for namespaced identifiers like ISBN URNs, OIDs, and UUID URNs.
URN
technology.internet.urnUniform Resource Name — a persistent, location-independent identifier in the format urn:nid:nss. Used for namespaced identifiers like ISBN URNs, OIDs, and UUID URNs.
Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal
Try it
CLI
$ finetype infer -i "urn:isbn:0451450523"
→ technology.internet.urnDuckDB
Detect
SELECT finetype('urn:isbn:0451450523');
-- → 'technology.internet.urn'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.internet.urn';Struct Expansion
Expression
nid: REGEXP_EXTRACT({col}, '^urn:([^:]+):')
nss: REGEXP_EXTRACT({col}, '^urn:[^:]+:(.+)$')JSON Schema
finetype schema technology.internet.urn
{
"$id": "https://meridian.online/schemas/technology.internet.urn",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Uniform Resource Name — a persistent, location-independent identifier in the format urn:nid:nss. Used for namespaced identifiers like ISBN URNs, OIDs, and UUID URNs.",
"examples": [
"urn:isbn: 0451450523",
"urn:ietf:rfc: 2648",
"urn:uuid: 6e8bc430-9c3a-11d9-9669-0800200c9a66",
"urn:oid: 2.16.840"
],
"pattern": "^urn:[a-z0-9][a-z0-9\\-]{0,31}:.+$",
"title": "URN",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}Examples
urn:isbn:0451450523urn:ietf:rfc:2648urn:uuid:6e8bc430-9c3a-11d9-9669-0800200c9a66urn:oid:2.16.840Aliases
uniform_resource_name