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

JSON_TO_STRUCTS

Converts a JSON string to statically typed structs. During conversion, it detects the schema of every JSON object and merges them in order to get the most generic schema to represent the entire JSON string. The “unnestLevel” parameter specifies how many levels of JSON objects to convert to structs.

Parameters

  • sourceColumns – A list of source columns.

  • regexColumnSelector – A regular expression to select the columns.

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

  • unnestLevel – The number of levels to unnest.

  • conditionExpressions – Condition expressions.

Example

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