Convert Alteryx workflows to Snowflake

-- Spatial Workflow: Store_Trade_Areas
-- Input: STORE_LOCATIONS (lat/lon)
-- Trade Area: 15-minute drive time
-- Spatial Match: Join CENSUS_TRACTS
--   where Trade Area contains Centroid

Input:         STORE_LOCATIONS
Trade Area:    Drive Time, 15 minutes
               Data source: TomTom
Spatial Match: CENSUS_TRACTS
               Target: Centroid
               Relation: Contains
Output:        STORE_CATCHMENT_AREAS
  Fields: Store_ID, Tract_ID, Population,
          Median_Income, Distance_Miles

-- Spatial → H3 hexagonal grid
WITH store_cells AS (
    SELECT
        store_id,
        H3_POINT_TO_CELL(
            ST_MAKEPOINT(longitude, latitude), 7
        ) AS h3_index
    FROM store_locations
),
trade_area AS (
    SELECT
        s.store_id,
        n.h3_index AS neighbor_cell
    FROM store_cells s,
    LATERAL FLATTEN(
        input => H3_GRID_DISK(s.h3_index, 4)
    ) n
)
SELECT
    t.store_id,
    c.tract_id,
    c.population,
    c.median_income,
    H3_GRID_DISTANCE(sc.h3_index, t.neighbor_cell)
        AS ring_distance
FROM trade_area t
JOIN census_tracts c
    ON c.h3_index = t.neighbor_cell
JOIN store_cells sc
    ON sc.store_id = t.store_id;