URL_PARAMS - AWS Glue DataBrew

URL_PARAMS

Extracts query parameters from a URL string, formats them as a JSON object, and returns the result in a new column.

For example, consider the following URL.

https://example.com/?firstParam=answer&secondParam=42

If you use this value as an input to URL_PARAMS, the output value is as follows.

{"firstParam": ["answer"], "secondParam": ["42"]}
Parameters

  • sourceColumn – The name of an existing column.

  • value – A character string to evaluate.

  • targetColumn – The name of the new column to be created.

You can specify either sourceColumn or value, but not both.

Example

{
    "RecipeAction": {
        "Operation": "URL_PARAMS",
        "Parameters": {
            "sourceColumn": "my_url",
            "targetColumn": "URL_PARAMS Column 1"
        }
    }
}