A user is unloading data to a stage using this command: ```sql COPY INTO @message FROM (SELECT OBJECT_CONSTRUCT('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman')) FILE_FORMAT = (TYPE = JSON) ``` What will the output file in the stage contain?

A user is unloading data to a stage using this command:

COPY INTO @message
FROM (SELECT OBJECT_CONSTRUCT('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman'))
FILE_FORMAT = (TYPE = JSON)

COPY INTO @message
FROM (SELECT OBJECT_CONSTRUCT('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman'))
FILE_FORMAT = (TYPE = JSON)

What will the output file in the stage contain?

Exam-Like

Snowflake SnowPro Core

Get started today

Comments