1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Introduction to Redshift
Connected

Bài tập

Extracting nested JSON keys

The field team would now like you to extract the current temperature and the temperature at 4AM. They said the hour_temperature key contains an array that starts at 12AM or midnight. The JSON is in the CTE for you again.

Hướng dẫn

100 XP
  • Extract the current temperature AS current_temp from the weather station data.
  • Extract the 'hourly_temperature' at 4AM as four_am_temp from the weather station data.