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

UNNEST_STRUCT_N

Creates a new column for each field of a selected column of type struct.

For example, given the following struct:


            user {
               name: “Ammy” 
               address: {
                  state: "CA",
                  zipcode: 12345
               }
            }

This function creates 3 columns:

user.name user.address.state user.address.zipcode

Ammy

CA

12345
Parameters

  • sourceColumns — List of the source columns.

  • regexColumnSelector — A regular expression to select the columns to unnest.

  • removeSourceColumn — A Boolean value. If true, then remove the source column; otherwise keep it.

  • unnestLevel — The number of levels to unnest.

  • delimiter — The delimiter is used in the newly created column name to separate the different levels of the struct. For example: if the delimiter is “/”, the column name will be in this form: “user/address/state”.

  • conditionExpressions — Condition expressions.

Example

{
    "RecipeAction": {
        "Operation": "UNNEST_STRUCT_N",
        "Parameters": {
            "sourceColumns": "[\"address\"]",
            "removeSourceColumn": "true",
            "unnestLevel": "2",
            "delimiter": "/"
        }
    }
}