WITH dataset AS( USING EXTERNAL FUNCTION get_pentagons(res INT) RETURNS ARRAY(BIGINT) LAMBDA '' SELECT get_pentagons(5) as pentagons) SELECT pentagon FROM dataset CROSS JOIN unnest(pentagons) AS t(pentagon) -- [599119489002373119, 599471332723261439, 599823176444149759, 600315757653393407, 600702785746370559, 601019445095170047, 601195366955614207, 601512026304413695, 601899054397390847, 602391635606634495, 602743479327522815, 603095323048411135]