Finds the host value from a valid URL. Input values must be of URL or String type and can be literals or column references.

In this implementation, a host value includes everything from the end of the protocol identifier (if present) to the end of the extension (e.g. .com).

URL literal examples:

derive type:single value: HOST('' ) as: 'myHost'

Output: Generates a column containing the value

Column reference example:

derive type:single value: HOST(myURLs) as: 'myHost'

Output: Generates the new myHost column containing the host values extracted from the myURLs column. 

derive type:single value: HOST(column_url)

ArgumentRequired?Data TypeDescription
column_urlYstringName of column or String or URL literal containing the host value to extract


Name of the column or URL or String literal whose values are used to extract the host value.


Required?Data TypeExample Value
YesString literal or column reference (URL)

Example - Domain, Host, Subdomain, and Suffix functions