Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports SELECT FROM Stored ProceduresSnowflake has enhanced the experience of interacting with stored procedures with the “SELECT FROM Stored Procedures” feature. You can now…Sep 5Sep 5
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports Dynamic PivotSnowflake just made the PIVOT functionality more flexible and intuitive. You can now dynamically specify the list of values to pivot by…May 9May 9
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports Higher-order FunctionsSnowflake’s support for higher-order functions provides a new way to handle semi-structured data. The newly supported TRANSFORM and FILTER…May 96May 96
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceChoosing the Right Case Insensitive Collation in Snowflake: A Deep Dive into Upper and Lower…Collations play a critical role in comparing and sorting string data, enabling Snowflake to handle strings based on customized rules of…Apr 21Apr 21
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports GREATEST/LEAST_IGNORE_NULLSAt Snowflake, we are committed to continuously enhancing our platform with new functions for a better developer experience. In response to…Mar 28Mar 28
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports Trailing Comma for the SELECT ClauseYou asked, and we listened. Snowflake now supports a trailing comma at the end of the SELECT clause. We’re committed to providing SQL…Mar 131Mar 131
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports Named and Optional ArgumentsSnowflake now supports passing arguments by name and defining optional arguments in User-Defined Functions (UDFs), User-Defined Table…Nov 15, 2023Nov 15, 2023
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Expands Result Cache for Some Non-deterministic FunctionsSnowflake has now enabled result caching for queries involving functions that generate non-deterministic results. We’ve identified certain…Nov 1, 2023Nov 1, 2023
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports IF [NOT] EXISTS at Column LevelFor database administrators and developers, adding or dropping columns are routine operations. But there are situations where you’d want to…Oct 23, 2023Oct 23, 2023
Qinyi DinginSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake Supports SELECT * ILIKE/REPLACESnowflake keeps the expansion of the SELECT * syntax by introducing two new features: “SELECT * ILIKE” and “SELECT * REPLACE”. This blog…Aug 4, 20231Aug 4, 20231