-- get all h3 that covers Toulouse, Nantes, Lille, Paris, Nice USING EXTERNAL FUNCTION polygon_to_cells(polygonWKT VARCHAR, res INT) RETURNS ARRAY(BIGINT) LAMBDA '' SELECT polygon_to_cells('POLYGON ((43.604652 1.444209, 47.218371 -1.553621, 50.62925 3.05726, 48.864716 2.349014, 43.6961 7.27178, 43.604652 1.444209))', 2) -- Polyfill and compact USING EXTERNAL FUNCTION compact_cells(h3array ARRAY(BIGINT)) RETURNS ARRAY(BIGINT) LAMBDA '' SELECT compact_cells(polyfillh3s) FROM ( USING EXTERNAL FUNCTION polygon_to_cells(polygonWKT VARCHAR, res INT) RETURNS ARRAY(BIGINT) LAMBDA '' SELECT polygon_to_cells('POLYGON ((43.604652 1.444209, 47.218371 -1.553621, 50.62925 3.05726, 48.864716 2.349014, 43.6961 7.27178, 43.604652 1.444209))', 4) AS polyfillh3s)