hi everyone,
i have a trouble in building agg. reflection for a big volumn dataset, instead of using group by, i use the window function for fast computing. But I don’t know how to build the agg. reflection on this parent dataset in order to accelerate my child dataset , is there a way to build agg. reflection on top of window function?
eg:
CASE WHEN FIRST_VALUE(accessory_id) OVER (PARTITION BY cal._month, room_id ORDER BY accessory_id DESC )=accessory_id THEN TRUE ELSE FALSE END AS _is_dedup_mac_per_mth
many thanks in advance!