View a markdown version of this page

json_serialization_parse_nested_strings - Amazon Redshift

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

json_serialization_parse_nested_strings

Values (default in bold)

false, true

Description

A session configuration that modifies the JSON serialization behavior of ORC, JSON, Ion, and Parquet formatted data. When both json_serialization_parse_nested_strings and json_serialization_enable are true, string values that are stored in complex types (such as, maps, structures, or arrays) are parsed and written inline directly into the result if they are valid JSON. If json_serialization_parse_nested_strings is false, strings within nested complex types are serialized as escaped JSON strings. For more information, see Serializing complex types containing JSON strings.