MeridianMERIDIAN

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.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.

Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "urn:isbn:0451450523"
→ technology.internet.urn

DuckDB

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.840

Aliases

uniform_resource_name

Type Registry