Snowflake Supports GREATEST/LEAST_IGNORE_NULLS

Photo by Glenn Carstens-Peters on Unsplash

At Snowflake, we are committed to continuously enhancing our platform with new functions for a better developer experience. In response to a common request from our community, we have added two new functions: GREATEST_IGNORE_NULLS and LEAST_IGNORE_NULLS. These functions will return the greatest and least non-null values from the list of arguments, so that you don’t need to wrap your arguments with NVL/COALESCE anymore. For more information, please visit our documentation.