Snowflake, Sql, Performance, Data Science, Data Engineering.
which queries: select qid, tablename, percentage_scanned_from_cache, bytes_scanned from analyze_table_scans2 where session_id=1 order by percentage_scanned_from_cache; Find out which tables had to bring data back from cold storage in the wh-Small 2nd run Here you can see that it’s the table