Although I can't supply a valid way to trigger this error message instantaneously, I can give other readers a snapshot of the current response Snowflake returns in this scenario after I waited the 24 hours for the cache to expire. The error message reads: Result for query "{queryId}" has expired

Some of the relevant data in the response includes:

code: 000710
name: OperationFailedError
sqlState: 02000

Unfortunately although Snowflake provides guidance on how to handle query responses, they don't appear to offer a comprehensive list of error messages and their meaning.