MeridianMERIDIAN

Hostname

Fully qualified domain name or simple hostname. Does not include protocol or path. Allows alphanumeric characters, hyphens, and dots. Subdomains supported.

Hostname

technology.internet.hostname

Fully qualified domain name or simple hostname. Does not include protocol or path. Allows alphanumeric characters, hyphens, and dots. Subdomains supported.

Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "example.com"
→ technology.internet.hostname

DuckDB

Detect
SELECT finetype('example.com');
-- → 'technology.internet.hostname'
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.hostname';

JSON Schema

finetype schema technology.internet.hostname
{
  "$id": "https://meridian.online/schemas/technology.internet.hostname",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Fully qualified domain name or simple hostname. Does not include protocol or path. Allows alphanumeric characters, hyphens, and dots. Subdomains supported.",
  "examples": [
    "example.com",
    "www.google.com",
    "subdomain.example.org",
    "localhost"
  ],
  "pattern": "^(?:(?:[a-z0-9](?:[a-z0-9-]{0,61}[a-z0-9])?\\.)*[a-z0-9](?:[a-z0-9-]{0,61}[a-z0-9])?)$",
  "title": "Hostname",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

example.comwww.google.comsubdomain.example.orglocalhost

Aliases

domain_name

Type Registry