Snowflake, Sql, Performance, Data Science, Data Engineering.
effective partition pruning: select session_id , sum(scanned) partitions_scanned , sum(total) partitions_total , partitions_scanned/partitions_total ratio , count(distinct qid) queries from analyze_table_scans2 group by 1 order by 1 Session 4 to 7 had 13% less total partitions, and scanned 36% less