What Snowflake function should be used to unload relational data to JSON?
What Snowflake function should be used to unload relational data to JSON?
The correct function to unload relational data to JSON in Snowflake is OBJECT_CONSTRUCT(). This function constructs an object from a set of key-value pairs, which can then be converted into JSON format. The other options do not relate specifically to converting relational data into JSON format.
correct https://community.snowflake.com/s/article/Generating-a-JSON-Dataset-using-Relational-Data-in-Snowflake
https://docs.snowflake.com/en/user-guide/data-unload-considerations
B - OBJECT_CONSYRUCT
B. OBJECT_CONSTRUCT()
Correct