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
Use dot notation to traverse a path in a JSON object: <column>:<level1_element>.<level2_element>.<level3_element>. Optionally enclose element names in double quotes: <column>:"<level1_element>"."<level2_element>"."<level3_element>".
Insert a colon : between the VARIANT column name and any first-level element: <column>:<level1_element>.
https://docs.snowflake.com/en/user-guide/querying-semistructured.html
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Mallikharjuna452
9 months, 4 weeks ago_yyukta
1 year, 2 months ago[Removed]
1 year, 7 months agofellpond
1 year, 2 months agoMarge23
1 year, 7 months agoc0d3g
2 years agoSV1122
2 years, 4 months agohalol
2 years, 5 months ago