URL

technology.internet.url

Uniform Resource Locator (complete web address including scheme). Includes protocol (http, https, ftp, etc.), hostname, and optional path.

Domain

technology

Try it

CLI

$ finetype infer -i "https://example.com/path/to/resource"
→ technology.internet.url

DuckDB

Detect

SELECT finetype('https://example.com/path/to/resource');
-- → 'technology.internet.url'

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

Struct Expansion

Expression

hostname: REGEXP_EXTRACT({col}, '(?:https?://)?([^/?]+)')
path: REGEXP_EXTRACT({col}, '(?:https?://[^/]+)?(/.*)$')
scheme: REGEXP_EXTRACT({col}, '^([^:]+):')

JSON Schema

finetype schema technology.internet.url

{
  "$id": "https://meridian.online/schemas/technology.internet.url",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Uniform Resource Locator (complete web address including scheme). Includes protocol (http, https, ftp, etc.), hostname, and optional path.",
  "examples": [
    "https://example.com/path/to/resource",
    "http://www.google.com",
    "ftp://ftp.example.org/file.txt",
    "https://example.com: 8080/path?query=value#anchor"
  ],
  "pattern": "^(?:(?:https?|ftp|file)://)(?:[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?\\.)+[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?(?::\\d+)?(?:/[^?#]*)?(?:\\?[^#]*)?(?:#.*)?$",
  "title": "URL",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

https://example.com/path/to/resourcehttp://www.google.comftp://ftp.example.org/file.txthttps://example.com:8080/path?query=value#anchor

Aliases

web_urluri