IPv4 Address

technology.internet.ip_v4

Standard 4-octet IPv4 address format (e.g., 192.168.1.1). Resolves to VARCHAR with INET validation. Can optionally parse to DuckDB INET type with the inet extension.

Domain

technology

Try it

CLI

$ finetype infer -i "192.168.1.1"
→ technology.internet.ip_v4

DuckDB

Detect

SELECT finetype('192.168.1.1');
-- → 'technology.internet.ip_v4'

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_v4';

JSON Schema

finetype schema technology.internet.ip_v4

{
  "$id": "https://meridian.online/schemas/technology.internet.ip_v4",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Standard 4-octet IPv4 address format (e.g., 192.168.1.1). Resolves to VARCHAR with INET validation. Can optionally parse to DuckDB INET type with the inet extension.",
  "examples": [
    "192.168.1.1",
    "8.8.8.8",
    "127.0.0.1",
    "10.0.0.0"
  ],
  "pattern": "^(?:(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
  "title": "IPv4 Address",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

192.168.1.18.8.8.8127.0.0.110.0.0.0

Aliases

ipv4