1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Introduction to Redshift

Connected

अभ्यास

Extracting top level JSON keys

The Idaho field team is back at it again, they got a new weather station that is outputting JSON strings that they'd like you to get data out of for them. The JSON is in the CTE named weather_station for you to work with. It has the JSON string in the data column.

निर्देश

100 XP
  • Extract the 'date' value from the data as weather_date.
  • Extract the 'weather' value from the data as weather_state.