🔥 3-day streak
Snowflake SnowPro Core (COF-C03)108 / 148
Question 108 of 148

A data engineer is ingesting JSON payloads from an IoT platform into Snowflake. Each message has a nested, inconsistent structure where some devices include extra fields. The engineer wants to load the raw messages into a single column without defining a fixed schema upfront, while still being able to query nested elements later. Which Snowflake data type should be used for this column?

Reviewed for accuracy · Report an issueNext question