Snowflake-Labs/sfguide-time-series-in-retail ? reverse-engineered prompt

Build me a Snowflake demo that shows how a retail company could forecast athletic shoe sales with time series data.

I want a setup script that creates the database, schema, warehouse, role, and the three tables for purchases, daily sales, and competitor pricing. Then make a notebook that generates realistic sample sales and competitor price data, rolls it up by day, matches the competitor prices to the right timestamps, adds rolling averages and lag based features, and runs Snowflake’s native forecasting so I can see predicted sales over time.

Please also include a few clear charts in the notebook so the trend and forecast are easy to understand, and make sure the whole thing is something I can run step by step in Snowflake Notebooks. If you need to check the latest Snowflake notebook or ML forecasting docs online, go ahead.