I am planning to write a series of articles on working with Snowpark in Python. Prior to starting any coding examples or sessions, we will first take a look at what Snowpark is and the advantages we can gain from using it. Snowpark Library: The Snowpark library offers a user-friendly…

This topic covers the JavaScript API for Snowflake stored procedures. The API consists of JavaScript objects and the methods in those objects. A stored procedure contains logic you write so you can call it from SQL. A stored procedure’s typically performs database operations or transactions by executing SQL statements. Let’s…

Read Time:2 Minute, 40 Second During the last post we discussed how to handle the TASK failure and send an alert to respective stakeholders. We leveraged SYSTEM$SEND_EMAIL() function with TASK to notify the users. But in real time it is very much possibility that all process are not tied to…

This article will use snowflake Snowpark to produce utility reports on your mailbox. Executive Summary: Using Snowpark to Extract Snowflake Utilities Consumption Details Creating Reports using Pandas and Matplotlib Libraries Triggering Reports on your mailbox using Python References: For this article, I am referring to two nice topics which helped explore more on…

Here at Snowflake, the Developer Productivity organization (DPE for short) is tackling some important problems we face as a company: namely, lengthening build times and complex development environments. A key strategy we are pursuing to resolve these is the migration of key build processes from CMake and Maven to Bazel. …

Snowflake, as we all know is cloud agnostic hence one very essential aspect is to have a way of securely integrating this platform with cloud hyperscalers. When it comes to security we should always follow methods where the integration happens in a way without sharing the secrets like over here…

TL;DR: To make masked PII data look realistic in Snowflake, you can create and apply dynamic data masking policies that cross-walk raw PII values to randomly reshuffled values from the same list of distinct values. Introduction Dynamic data masking is one of the most widely used Snowflake data governance features. It enables…

Hex: The Snowpark for Python Easy Button With packages to install and environments to configure, the road to getting started with Snowpark can be time consuming and technically complex. With the great power of Python also comes great responsibility frustration. Hex sidesteps this by auto-magically installing the Snowpark API in any project connected to Snowflake, making it…