Explanation:
The schema_of_json function is designed to generate a schema based on an example JSON string. This schema is then used by FROM_JSON to parse JSON strings into structs with the appropriate data types, ensuring accurate data representation and manipulation.
Ultimate access to all questions.
No comments yet.
What is the primary function of schema_of_json in SQL?
A
To validate the structure of a JSON string.
B
To create a new JSON string from a struct.
C
To generate a schema that can be used to parse a JSON string into a struct.
D
To compress the JSON data for storage efficiency.