Dynamic Table Creation with Event Logging In the ever-evolving world of data management, streamlining processes and ensuring data freshness are crucial. Snowflake, a cloud-based data platform, provides a revolutionary feature known as Dynamic Tables. This blog post showcases a novel approach combin...
SQL Scripting with Event Tables During the previous post we discussed the usage of EVENT table with Python and Javascript procedure. In continuation of the same we will explore how we can leverage the EVENT tables in SQL scripting. We will use the EVENT tables to log the error and other details thr...
JS Proc with Event Tables During the last post we discussed about the Event tables and how these are used for Error logging in your process. The scenario we discussed was related to the Python User Defined Tabular function(UDTF). The UDTF was responsible of parsing JSON data in a tabular format and...
Snowflake: Logging with Event tables we will explore the utilization of EVENT tables to capture erroneous data. Snowflake newly introduced public preview feature enables developers to actively monitor and debug their applications. Based on business requirement, a streamlined process is developed to...
Keeping an Eye on Your Snowflake Warehouse: Automated Monitoring and Email Alerts In the world of data warehousing, keeping track of changes to your Snowflake warehouse size is crucial. Unexpected adjustments can impact performance and potentially incur additional costs. This blog post introduces a...