The results of a query are discarded after 24 hours. Once a query has been evicted from the cache, trying to reuse the result in post-processing will result in the error you're seeing.

I was able to reproduce your scenario and observed the exact same results.

Since the current version of Snowpark Python is erroring out, they're likely attempting to use the cached results of the query instead of attempting to re-run the base query.