Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
When traversing semi-structured data, column names are case-insensitive but element names are case-sensitive. This means that for column names, 'SRC' and 'src' would be considered the same, whereas for element names, 'name' and 'Name' would be considered different.
Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, (src is a column name) in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name
D is correct; https://docs.snowflake.com/en/user-guide/querying-semistructured
D is correct