Exam SnowPro Core topic 1 question 971 discussion

D. The column name is case-insensitive and the element name is case-sensitive. https://docs.snowflake.com/en/user-guide/querying-semistructured Important Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name

https://docs.snowflake.com/en/user-guide/json-basics-tutorial-query

Column Names (Attributes): When querying JSON data stored in a column, the column names (also known as attributes) are case-sensitive. You must match the exact case of the column name in your query. Element Names (Keys within JSON Objects): The keys or element names within the JSON objects are case-insensitive. This means you can access the JSON elements using any case (upper or lower) without affecting the query results.