Cherry Peeked

This tutorial has four parts in total: Part One Part Two Part Three Part Four We will continue from where we left off in the part two of this tutorial. Before diving into creating Snowflake objects, let’s see what the final result looks like once again: Snowflake Task calls Stored Procedure every few hours Stored Procedure fetches data from Backlog API Stored Procedure records the fetched data into Snowflake table In this tutorial we will create Python Stored Procedure. Instead of dumping all the code at once, I will incrementally build up our solution. Creating Python Stored Procedure Ultimately our stored procedure will be fetching data from backlog and recording it onto given table. If table does not exist, it should create the table. First let’s build the part of our stored procedure that checks if table exists or not. code_sample_4.sql CREATE OR REPLACE PROCEDURE backup_backlog_data ( table_name VARCHAR ) RETURNS STRING NOT NULL LANGUAGE PYTHON RUNTIME_VE...