
Explanation:
The question requires converting relational table rows to a single VARIANT column and unloading them as JSON. OBJECT_CONSTRUCT is the correct function as it builds JSON objects from key-value pairs, creating VARIANT data. COPY is the correct command for unloading data to files, specifically supporting JSON format when used with FILE_FORMAT = (TYPE = 'JSON'). PUT is for uploading files to stages, GET is for downloading files, and EXPORT is not a valid Snowflake command for data unloading.
Ultimate access to all questions.
No comments yet.