Finds the value a subdomain value from a valid URL. Input values must be of URL or String type.

In this implementation, a subdomain value is the first group of characters in the URL after any protocol identifiers ( http:// or https://, for example).

URL literal example:

derive type:single value: SUBDOMAIN('' ) as: 'myDomain'

Output: Generates a column containing the value www

derive type:single value: SUBDOMAIN('') as: 'myDomain'

Output: Generates a column containing the value www.exampl

Column reference example:

derive type:single value: SUBDOMAIN(myURLs) as: 'myDomain'

Output: Generates the new myDomain column containing the subdomain values extracted from the myURLs column. 

derive type:single value: SUBDOMAIN(column_url)

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


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


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

Example - Domain, Subdomain, Host, and Suffix functions