A Snowflake user needs to import a JSON file larger than 16 MB.
What file format option could be used?
A Snowflake user needs to import a JSON file larger than 16 MB.
What file format option could be used?
To import a JSON file larger than 16 MB into Snowflake, the 'strip_outer_array = true' option should be used. This setting removes the outer array structure of the JSON file, allowing its contents to be split across multiple table rows, thereby bypassing the 16 MB per row limitation.
The correct answer is C. strip_outer_array = true will remove the outer array structure and copy the file into multiple table rows instead of row. (the limitation for table rows is max 16MB) with this solution it will be fine. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#semi-structured-data-size-limitations
C is correct
C correct - https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare