SnowPro Core RecertificationRetired

By Snowflake · Question Mode

QuestionQ31

VerifiedSQL

Which function can be used with the COPY INTO <location> statement to transform rows from a relational table into a single VARIANT column and unload the rows to a JSON file?

Explanation

OBJECT_CONSTRUCT(*) constructs one JSON-style object per relational row, using the table columns as object fields. That semi-structured object can be emitted as a single value by a COPY INTO <location> query and unloaded using a JSON file format.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!