Explanation:
The question asks which file format command removes square brackets ([]) from JSON data when loading into Snowflake. According to the Snowflake documentation referenced in the community discussion, STRIP_OUTER_ARRAY = TRUE is specifically designed to remove outer brackets (i.e., [ ]) from JSON data. This is confirmed by the 100% community consensus on option D. The other options serve different purposes: STRIP_NULL_VALUES removes null values, REPLACE_INVALID_CHARACTERS handles invalid characters, and TRIM_SPACE removes whitespace, none of which address the removal of outer brackets.
When creating a file format to load JSON data into Snowflake, which command removes the square brackets ([]) from the data?
A
STRIP_NULL_VALUES = TRUE
B
REPLACE_INVALID_CHARACTERS = TRUE
C
TRIM_SPACE = TRUE
D
STRIP_OUTER_ARRAY = TRUE
No comments yet.