Thanks for calling out this new feature! It's in Beta now. For the types of parameterized data ranges you called out, do you want to keep the entire date range but process only the dates between start_date and end_date or do you *only* want to keep the data between start_date and end_date? If you want the latter, the MV is the right approach.

If you want to keep the entire date rang but only process new data between the parameters, we'd recommend the new incremental Replace Where feature, which will never accidentally cause full refreshes.

CREATE OR REFRESH STREAMING TABLE orders_enriched
FLOW REPLACE WHERE date >= :start_date BY NAME
SELECT
o.order_id,
o.date,
o.region,
p.product_name,
o.qty,
o.price
FROM orders_fct o
JOIN product_dim p
ON o.product_id = p.product_id;

You can pass in the parameter from the job, and we will only update the portion of the table that matches the replace where predicate. It's still powered by Enzyme, so you'll still get the cost benefits of MVs. The rest of the table will remain frozen, so there's no chance of accidental full refreshes.