
Explanation:
The question asks for two methods to access a JSON object in Snowflake from a VARIANT column. According to Snowflake documentation and the community discussion (with 100% consensus for BD and upvoted comments), the column name in dot notation is case-insensitive, but element names (JSON keys) are case-sensitive. Options B (src:salesPerson.name) and D (SRC:salesPerson.name) are equivalent because 'SRC' (column alias) is case-insensitive, while 'salesPerson.name' (JSON path) matches the case shown in the reference image. Option A (src:salesperson.name) is incorrect due to the lowercase 'p' in 'salesperson', which does not match the case-sensitive JSON key. Options C and E are incorrect because 'Name' (uppercase 'N') does not match the actual key 'name' (lowercase 'n'). The community discussion confirms that only B and D are valid, as they correctly handle case sensitivity for JSON elements while respecting case insensitivity for column names.
Ultimate access to all questions.
Given the following table, which two methods can a Snowflake user employ to access a JSON object?
CREATE TABLE products (
id INTEGER,
name VARCHAR,
details VARIANT
);
CREATE TABLE products (
id INTEGER,
name VARCHAR,
details VARIANT
);

A
src:salesperson.name
B
src:salesPerson.name
C
src:salesPerson.Name
D
SRC:salesPerson.name
E
SRC:salesPerson.Name
No comments yet.