EXTRACT_VALUE - 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).

EXTRACT_VALUE

Creates a new column with an extracted value from a user-specified path. If the source column is of the Map, Array, or Struct type, each field in the path should be escaped using back ticks (for example, `name`).

Parameters
  • targetColumn – The name of the target column.

  • sourceColumn – Name of the source column from which the value is to be extracted.

  • path – The path to the specific key that the user wants to extract. If the source column is of the Map, Array, or Struct type, each field in the path should be escaped using back ticks (for example, `name`).

    Consider the following example of user information:

    user { name: “Ammy” address: { state: "CA", zipcode: 12345 }, phoneNumber:{"home": "123123123", "work": "456456456"} citizenship: ["Canada", "USA", "Mexico", "India"] }

    The following are examples of the paths you would provide, depending on the type of the source column:

    • If the source column is of the type map, the path for extracting the home phone number is:

      `user`.`phoneNumber`.`home`

    • If the source column is of the type array, the path for extracting the second "citizenship" value is:

      `user`.`citizenship`[1]

    • If the source column is of the type struct, the path for extracting the zip code is:

      `user`.`address`.`zipcode`

Example

{ "RecipeAction": { "Operation": "EXTRACT_VALUE", "Parameters": { "sourceColumn": "age", "targetColumn": "columnName", "path": "`age`.`name`", } } }