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

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

URL