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
4 months ago_yyukta
8 months, 3 weeks ago[Removed]
1 year, 1 month agofellpond
8 months, 2 weeks agoMarge23
1 year, 2 months agoc0d3g
1 year, 6 months agoSV1122
1 year, 10 months agohalol
1 year, 11 months ago