Snowflake, Sql, Performance, Data Science, Data Engineering.
session_id, tablename; Almost no partition pruning Turns out the tables shared by Snowflake on the snowflake_sample_data.tpch_sf10 schema have not been optimized for querying. To fix these, I rematerialized the 2 biggest tables in my own schema — this time ordering the rows by date: create table