MeridianMERIDIAN

IPv4 Address

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.

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
Category
internet
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://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)",
  "x-finetype-transform-ext": "CAST({col} AS INET)"
}

Examples

192.168.1.18.8.8.8127.0.0.110.0.0.0

Aliases

ipv4

Type Registry