A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

Question

Elliott Leighton-Woodruff · Accepted Answer

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

Elliott Leighton-Woodruff · Answer

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

Elliott Leighton-Woodruff · Answer

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

Elliott Leighton-Woodruff · Answer

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 466 - SnowPro Core discussion

Suggested answer: D

0 comments