The TO_JSON function is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

The OBJECT_CONSTRUCT function in Snowflake is used to convert rows in a relational table into a single VARIANT column that represents each row as a JSON object. This function dynamically creates a JSON object from a list of key-value pairs, where each key is a column name and each value is the corresponding column value for a row. This is particularly useful for aggregating and transforming structured data into semi-structured JSON format for further processing or analysis.
References:
* Snowflake Documentation: Semi-structured Data Functions

The file format option in Snowflake can be specified in the following commands:
* CREATE STAGE: This command allows users to define the file format when creating a stage, which applies to any data loaded or unloaded via that stage.
* COPY INTO <location>: This command enables data export from a table to an external location, where the file format can be specified to ensure the data is structured as needed for downstream systems.
Other commands, such as PUT or GET, do not support the specification of file formats directly within the command syntax.