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" --mode column
→ technology.internet.url

DuckDB

Detect

SELECT ft_infer('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(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(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 taxonomy technology.internet.url -o json-schema

{
  "$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-label": "technology.internet.url",
  "x-finetype-pii": false
}

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