Which function can be used with the copy into statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

Question

Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

rita whitfield · Accepted Answer

<div style="font-size:12pt;font-family:Calibri, sans-serif;"><p style="margin:0;"> TO VARIANT</p></div>

rita whitfield · Answer

<div style="font-size:12pt;font-family:Calibri, sans-serif;"><p style="margin:0;"> FLATTEN</p></div>

rita whitfield · Answer

<div style="font-size:12pt;font-family:Calibri, sans-serif;"><p style="margin:0;"> OBJECT_AS</p></div>

rita whitfield · Answer

OBJECT_CONSTRUCT

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 438 - SnowPro Core discussion

Suggested answer: D

0 comments