A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file…

Question

Options

• AIt removes the last element of the outer array.
• BIt removes the outer array structure and loads the records into separate table rows,
• CIt removes the trailing spaces in the last element of the outer array and loads the records into
• DIt removes the NULL elements from the JSON object eliminating invalid data and enables the

• A
  4% (1)
• B
  72% (18)
• C
  16% (4)
• D
  8% (2)

Explanation

https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

No community discussion yet for this question.