Snowflake ProTalk
Four New Features in Snowflake

Additions to Search Optimization, Sending Email Notifications, Tracking Notification History, and Anonymous Procedures

Many new features have been recently added to Snowflake. In our next ProTalk, we would like to highlight and review four of them. 

1. Search Optimization Service Newly Added Abilities
   We will show the new abilities added to the search optimization service that can significantly improve the performance of certain types of lookup and analytical queries that use an extensive set of predicates for filtering support, including: 
   1. Column configuration
   2. Support for substring and regular expression searches
   3. Support for fields in VARIANT, OBJECT, and ARRAY columns
   4. Support for geospatial functions with GEOGRAPHY objects
2. System Stored Procedure for Sending Email Notifications
   We will review how to use the built-in SYSTEM$SEND_EMAIL() stored procedure to send email notifications by: 
   1. Creating a Notification Integration
   2. Verifying email addresses of Notification Recipients
   3. Granting the privilege to use the Notification Integration
   4. Sending an Email Notification
3. Information Schema Table Function: NOTIFICATION_HISTORY
   We will review the new table function that can query the history of notifications sent through Snowflake for: 
   1. Notifications from tasks
   2. Notifications from Snowpipe
   3. Email notifications
4. Anonymous Procedure (One-Time Use)
   This new feature allows for creating and calling an anonymous procedure that is like a stored procedure but is not stored for later use. We will show you how to: 
   1. Create an anonymous procedure defined by parameters in the WITH clause
   2. Call that procedure