Forecast the What-If, Not the Copy: Scenario Branches Meet Time-Series Forecasting
· 7 min read
Two queries. One word different. Two futures.
FROM ts_forecast_by('sales', product_id, date, quantity, 'AutoETS', 7, '1d')
FROM ts_forecast_by('promo.sales', product_id, date, quantity, 'AutoETS', 7, '1d')
The first forecasts your actual demand. The second forecasts a promotional scenario that exists nowhere on disk. Neither one copied a row.