Snowflake, Sql, Performance, Data Science, Data Engineering.
Partition pruning There’s something interesting happening in all these queries — we can see that there almost no partition pruning happened: select sum(scanned) partitions_scanned, sum(total) partitions_total, partitions_scanned/partitions_total ratio from analyze_table_scans2 order by qid,