Answer-first summary for fast verification
Answer: data:Employee.name
The correct answer is C because Snowflake treats column names as case-insensitive but element names within semi-structured data as case-sensitive. The column is named 'Data' (case-insensitive), but the JSON structure shows 'employee' with lowercase 'e' and 'name' with lowercase 'n'. Option C uses 'data:Employee.name' where 'Employee' has a capital 'E', which does not match the actual JSON structure where it's lowercase 'employee'. The community discussion confirms this with upvoted comments stating that column names are case-insensitive but element names are case-sensitive, and Jacobr5000's comment provides official documentation supporting this behavior.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A column named "Data" contains VARIANT data and stores values as follows:
{
"employee": {
"name": "John Doe",
"id": 12345
}
}
{
"employee": {
"name": "John Doe",
"id": 12345
}
}
How can you extract the employee's name from the column data in Snowflake?
A
Data:employee.name
B
DATA:employee.name
C
data:Employee.name
D
data:employee.name
No comments yet.