That's an interesting look at their internals; I wasn't aware of their dynamic sorting feature. At read time, though, Snowflake's zone map is the same as Redsh

That's an interesting look at their internals; I wasn't aware of their dynamic sorting feature. At read time, though, Snowflake's zone map is the same as Redshift's and Vertica's; you'll see similar pruning for many queries. Redshift however doesn't prune during joins, which is a huge deficiency. Snowflake looks more flexible about getting the data into its final ordering.