Flattens (explodes) compound values into multiple rows

Question

Flatten can be used for following semi structure and structure data, or only semi structure.

score 0 · Answer 1 · answered Jul 22 '20 at 18:55

0

Flatten is for a VARIANT, OBJECT, or ARRAY. Unpivot will work on structured data.

answered Jul 22 '20 at 18:55

Mike Gohl

Thanks! I have one more question Mike. If we want to delete data in fail safe whether user or snowflake support can delete it before 7 days period expires. – Prats Jul 23 '20 at 18:03
There is no option to delete data from failsafe. To avoid failsafe, use transient tables. – Mike Gohl Jul 23 '20 at 18:26

1 Answers1