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
-- Unload the data to a file in a stage
COPY INTO @mystage
FROM (SELECT OBJECT_CONSTRUCT('id', id, 'first_name', first_name, 'last_name', last_name, 'city', city, 'state', state) FROM mytable)
FILE_FORMAT = (TYPE = JSON);
-- The COPY INTO location statement creates a file named data_0_0_0.json.gz in the stage.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
t945123456
1 month, 3 weeks ago37ceea2
1 month, 3 weeks ago37ceea2
2 months, 2 weeks ago37ceea2
2 months, 1 week agobor4un
2 months, 3 weeks agoMatthieuDN
2 months, 3 weeks agoMohit78jain
3 months, 1 week ago