Read Time:1 Minute, 53 Second During this post we will discuss an interesting use case related to TASKS. Say we have two TASKS i.e. TASK_A and TASK_B exists in our database where TASK_B is depend on TASK_A. Two procedures, PROC_A and PROC_B are coupled with these TASKS respectively. On successful…

Read Time:5 Minute, 16 Second As we know Snowflake has introduced latest badge “Data Cloud Deployment Framework” which helps to understand knowledge in designing, deploying, and managing the Snowflake landscape. Data Architecture discussed in course was in great detail and instead of just going only video and earning Badge, we…

“About 80% of data is geographic”, or so goes an urban legend popular in the GIS community. It’s easy to believe that number just by looking at how many Snowflake customers use a spatial data type (Geography or Geometry) or store their geospatial coordinates in latitude and longitude fields. …

Uploading and using custom Python packages in Snowpark — How can you use a Python package that may not yet be published to Snowflake’s Anaconda channel? You have a few options to upload and use other packages manually. Snowflake can support importing custom Python packages. However, native libraries (in Python, this is often like a .so compiled file that…

Read Time:2 Minute, 34 Second During this post we will discuss an interesting scenario to integrate Snowflake and salesforce. As per the need we don’t want to get data to be ingested into Salesforce from Snowflake. Salesforce users want to have the access of Snowflake data without moving it. They…

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…