prepare_polygon_index.sql

CREATE TABLE waze.polygons_geo
WITH (
      external_location = 's3://...',
      format = 'Parquet') AS
WITH dataset AS (
  SELECT 
     polygons
  FROM waze.polygons)
SELECT 
     pol.polygon,
     pol.polygon_slug,
     pol.url_base,
     ST_Polygon(concat(
       'polygon ((',
         array_join(
           transform(
            split(pol.polygon, ';'),
            l -> replace(l, ',', ' ')
      ),','),'))')) as polygon_geo
FROM dataset 
CROSS JOIN UNNEST(polygons) as t(pol)

query_table_by_polygon.sql

SELECT 
 *
FROM test.main
WHERE polygon_slug IN (
     SELECT polygon_slug
     FROM (SELECT 
        polygon_slug,
        st_intersects(polygon_geo,
               st_polygon('polygon ((-96.984 19.583, -96.974 19.498, 96.875 19.589))')) as inte
      FROM polygons) WHERE inte = true)