Extracts the query parameters of a URL into an Object. The Object keys are the parameter's names, and its values are the parameter's values. Input values must be of URL or String type.

This function is part of a set of functions for processing URL data.


URL literal examples:

derive type:single value: URLPARAMS('http://example.com?color=blue&shape=square' ) as: 'myURLParams'

Output: Generates the myURLParams column containing the following Object:

{"color": "blue","shape": "square"}

Column reference example:

derive type:single value: URLPARAMS(myURLs) as: 'myURLParams'

Output: Generates the new myURLParams column containing the query parameters extracted from the URLs in the myURLs column. 

derive type:single value: URLPARAMS(column_url)

ArgumentRequired?Data TypeDescription
column_urlYstringName of column or String or URL literal containing the parameters and their values to extract


Name of the column or URL or String literal containing the query parameters and their values to extract.


Required?Data TypeExample Value
YesString literal or column reference (URL)http://www.example.com?q1=hello&q2=goodbye

Example - Domain, Subdomain, Host, and Suffix functions