IPv6 Address

technology.internet.ip_v6

Standard IPv6 address format with 8 16-bit hex groups separated by colons. May use :: notation for zero compression. Resolves to VARCHAR.

Domain

technology

Try it

CLI

$ finetype infer -i "2001:0db8:85a3:0000:0000:8a2e:0370:7334"
→ technology.internet.ip_v6

DuckDB

Detect

SELECT finetype('2001:0db8:85a3:0000:0000:8a2e:0370:7334');
-- → 'technology.internet.ip_v6'

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.ip_v6';

JSON Schema

finetype schema technology.internet.ip_v6

{
  "$id": "https://meridian.online/schemas/technology.internet.ip_v6",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Standard IPv6 address format with 8 16-bit hex groups separated by colons. May use :: notation for zero compression. Resolves to VARCHAR.",
  "examples": [
    "2001: 0db8: 85a3: 0000: 0000: 8a2e: 0370: 7334",
    "2001:db8: 85a3:: 8a2e: 370: 7334",
    ":: 1",
    "fe80:: 1"
  ],
  "pattern": "^([0-9a-fA-F]{1,4}:){7}[0-9a-fA-F]{1,4}$",
  "title": "IPv6 Address",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

2001:0db8:85a3:0000:0000:8a2e:0370:73342001:db8:85a3::8a2e:370:7334::1fe80::1

Aliases

ipv6