URL_PARAMS - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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" } } }