Engineering
Snowflake Hybrid Tables get faster without request fees
Row-store Snowflake Hybrid Tables handle OLTP-style work, and new preview optimizations report up to 8 times the throughput.
Performance
Micro-partitions, pruning, clustering, and the query profile: how to make Snowflake queries fast without just renting a bigger warehouse.
Snowflake
Snowflake Gen2 warehouses: faster compute you have to opt into
Snowflake Gen2 standard warehouses run on faster hardware and finish most queries quicker, but they bill at a higher credit rate and you often have to switch with a SQL clause. Whether they save money depends entirely on whether the speedup beats the rate.
Snowflake
Snowflake clustering: when a clustering key actually pays off
Snowflake clustering keys reorganize micro-partitions so queries prune more of the table. On a well-clustered date column a one-day query can scan 140 micro-partitions instead of 9,800, but automatic clustering bills credits, so it only pays on big, filtered, slow-changing tables.