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