SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ149

Load and leverage structured, semi-structured, and unstructured data

The following SQL query is executed against semi-structured data:

SELECT -  
weather:station.temp[0]  
  
FROM -  
weather_data;

What can be determined about the temp key?

Explanation

The [0] notation accesses the element at index 0, which indicates that temp has an array value. It does not indicate the value of that element or restrict the types of values it may contain.

Community Discussion

No comments yet. Be the first to start the discussion!