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
D correct
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 is correct: https://community.snowflake.com/s/article/faq-can-i-unload-a-relational-table-with-multiple-columns-to-json