Skip to content

IPv4 Address

Type Registry

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 technologyinternet
Casts to VARCHAR
Scope Universal

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://noon.sh/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"
}

Examples

192.168.1.18.8.8.8127.0.0.110.0.0.0

Also known as

ipv4

Types in technology