> ## Documentation Index
> Fetch the complete documentation index at: https://dune-tables-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# URL functions

## Extraction functions

The URL extraction functions extract components from HTTP URLs (or any
valid URIs conforming to `2396`\{.interpreted-text role="rfc"}). The
following syntax is supported:

```text
[protocol:][//host[:port]][path][?query][#fragment]
```

The extracted components do not contain URI syntax separators such as
`:` or `?`.

#### url\_extract\_fragment()

**`url_extract_fragment(url)`** → varchar

Returns the fragment identifier from `url`.

#### url\_extract\_host()

**`url_extract_host(url)`** → varchar

Returns the host from `url`.

#### url\_extract\_parameter()

**`url_extract_parameter(url, name)`** → varchar

Returns the value of the f query string parameter named `name` from `url`. Parameter extraction is handled in the typical manner as specified by RFC 1866#section-8.2.1.

#### url\_extract\_path()

**`url_extract_path(url)`** → varchar

Returns the path from `url`.

#### url\_extract\_port()

**`url_extract_port(url)`** → bigint

Returns the port number from `url`.

#### url\_extract\_protocol()

**`url_extract_protocol(url)`** → varchar

Returns the protocol from `url`.

#### url\_extract\_query()

**`url_extract_query(url)`** → varchar

Returns the query string from `url`.

## Encoding functions

#### url\_encode()

**`url_encode(value)`** → varchar

Escapes `value` by encoding it so that it can be safely included in URL query parameter names and values.

#### url\_decode()

**`url_decode(value)`** → varchar

Unescapes the URL encoded `value`. This function is the inverse of `url_encode`.