79389823

Date: 2025-01-27 05:50:41
Score: 0.5
Natty:
Report link

Instead of getting Names and Value in separate UNNSET we can read using UNNEST OBJECT_PAIRS

select data.id as id, sched_n.name as schedule, month.name as month from
AIR_CONFIG.SCHEDULE.Flight_Schedule data
UNNEST OBJECT_PAIRS(data.value.schedules) as sched_n
UNNEST OBJECT_PAIRS(sched.flightConfigs) as month 
where data.id like "1111"
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Bhushan Phalak