Are Snowflake variant element names case-sensitive?

• A. Yes, element names are case-sensitive.
• B. No, element names are case-insensitive.
• C. Element names vary by data type.
• D. Only when using bracket notation.

Answer: (A)

Snowflake’s VARIANT type stores semi-structured data like JSON, and the keys inside that data are treated as exact strings. This means the name of a field must be matched exactly in queries, including its case. If the JSON contains a key named with a capital letter, you must reference that exact key (for example using a path with 'Name' rather than 'name' or 'NAME'), regardless of whether you use dot-style or bracket-style access. That’s why the correct answer is that element names are case-sensitive. The other options would imply the case could be ignored or vary by data type, which isn’t the behavior for JSON keys inside VARIANT, and the method of access doesn’t change the fundamental case sensitivity.