What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)
To determine if a query is too large to fit in memory, you need to look for indications that data is being spilled to storage. 'Bytes spilled to local cache' typically refers to data that does not fit in memory and is temporarily being stored in a cache. 'Bytes spilled to local storage' indicates that data is being written to local disk because it cannot be held in memory. Both of these statistics are strong indicators that the query is exceeding the available memory.
Bytes are spilled to local disk first , then out of memory goto remote disk
https://docs.snowflake.com/en/user-guide/ui-query-profile
https://www.bing.com/search?q=bytes+spilled+to+local+storage+snowflake&cvid=e844f19876134a32bab1cd2c43995f87&aqs=edge.2.0j69i57j0l7j69i11004.7813j0j9&FORM=ANAB01&PC=U531