Collations play a critical role in comparing and sorting string data, enabling Snowflake to handle strings based on customized rules of locale, case sensitivity, accent sensitivity, and punctuation…

Snowflake Community is a platform for users of the Snowflake cloud data platform to share knowledge, ask questions, and collaborate. Readers can learn about cloud data warehousing, data analytics, and data engineering best practices. With forums, user groups, and community events, Snowflake Community provides resources for Snowflake users to connect and learn from each other.

Snowflake Community

Learn about the new `upper` and `lower` collations in Snowflake that offer more efficient options for case-insensitive string handling.

Choosing the Right Case Insensitive Collation in Snowflake: A Deep Dive into Upper and Lower Collations