Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
When unloading data from a relational table into a JSON file, the TO_JSON function is recommended. TO_JSON transforms SQL data into JSON formatted text, making it suitable for exporting data into a JSON file.
It's the same as question 1070
Yes, it is same with 1070. But, there the answer was TO_JSONE Even for this one the answer is TO_JSON. As long as the question does not mention anything related to construct an object, like Variant column, the answer is TO_JSONE
Correction: this question is the same as 1070 and 1053. Second, the answer for 1070 was Object Construct, as well, not TO_JSON. The real problem is that the answer for identical question 1053, is TO_JSON. Any idea?