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

Episode Highlights:

Rich BW


As Enterprise Data Solutions Architect at INTRICITY, Rich has deployed Snowflake in several dozen Fortune 500 accounts and designs and delivers orchestration, modeling, security and strategy to enable elastic cloud data warehousing.

Jared BW


Jared acts as our Vice President of Emerging Technologies and is the host of our Snowflake ProTalk webinar series. Listed as one of the “Top Marketing Operations Leaders You Should Know” and is the author and creator of our INTRICITY101 video series.

Arkady BW


As Executive VP and Co-Founder of INTRICITY, Arkady has over 30 years of experience in engineering, architecting, developing and deploying the most intricate enterprise business solutions in America and Europe. 

Register Here

appears invalid. We can send you a quick validation email to confirm it's yours