striping a list into individual members in BigQuery

Try below

SELECT IP, range.owner as owner
FROM `shared_ips` sp join `nodes` sn on sp.value = sn.value 
cross join UNNEST (sn.details_ip_ranges) as range

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top