Which function unloads data from a relational table to JSON?
Which function unloads data from a relational table to JSON?
The function that unloads data from a relational table to JSON is OBJECT_CONSTRUCT. This function can be used in combination with the COPY command to convert the rows in a relational table to a single VARIANT column, which can then be unloaded into a JSON file.
d is correct: https://community.snowflake.com/s/article/faq-can-i-unload-a-relational-table-with-multiple-columns-to-json
D is correct: Unloading a relational table to JSON You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file. https://docs.snowflake.com/en/user-guide/data-unload-considerations
D correct
d is correct
No, D is not correct. As long as Variant column is not part of the action, it is about TO_JSON, since, we do not need to construct any object, like Variant column.
Sorry, my answer is B