79632758

Date: 2025-05-21 21:05:49
Score: 1
Natty:
Report link

Sorry for this stupid question, I found the solution here BigQuery: Extract values of selected keys from an array of json objects

select ARRAY(
  SELECT JSON_EXTRACT_SCALAR(json_array, '$.start') from UNNEST(JSON_EXTRACT_ARRAY(metadata,"$.mentions"))json_array
) as extracted_start
Reasons:
  • Blacklisted phrase (1): stupid question
  • Whitelisted phrase (-2): I found the solution
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: DataScienceAmateur