Snowflake's string min/max is truncated to ~40 chars, and it's undocumented

Other: database performance(gist.github.com)view on HackerNews
Snowflakedatabaseperformancestring lengthmin/maxpruningmicro-partitions

Author: river_wu

Date: 7/22/2026

Article Summary:
A user discovers that Snowflake's string min/max length for pruning micro-partitions is around 40-41 characters, which is undocumented.