USING EXTERNAL FUNCTION cell_to_boundary_wkt(h3 VARCHAR) RETURNS ARRAY(VARCHAR) LAMBDA '' WITH dataset AS ( SELECT h3_cell, cell_to_boundary_wkt(h3_cell) AS coords FROM( USING EXTERNAL FUNCTION lat_lng_to_cell_address(lat DOUBLE, lng DOUBLE, res INTEGER) RETURNS VARCHAR LAMBDA '' SELECT lat_lng_to_cell_address(latitude, longitude, 10) AS h3_cell FROM demo.earthquakes WHERE latitude BETWEEN 18 AND 70) ) SELECT h3_cell, ST_GEOMETRY_FROM_TEXT(p) as point from dataset CROSS JOIN unnest(coords) AS t(p)