When you run Snowflake stored procedures, debugging is not the easiest thing. This is my example stored procedure, dynamically dropping tables: create or replace procedure groupby.public.droptables(message VARCHAR) RETURNS VARCHAR NOT NULL LANGUAGE SQL AS $$ DECLARE v_sql_query VARCHAR; c_table CURSOR FOR SELECT TABLE_NAME FROM
TL/DR; take a look at my Python CI/CD tool for Snowflake: SFexecute. Put the SQL you want to execute in a folder, run the script and all…
https://github.com/datadutch/SFexecute
We have a requirement where we want to see the top customers with the largest orders. This could lead to a query like this:
One of the public preview features that was recently launched: Snowflake Copilot. Introduced in April 2024, so Snowflake is a bit late to…
This is really nice. Build blocks of code that can be used in stored procedures or tasks but also in the console.
How to set this up, it is super easy:
In one of my Notion notebooks, I am maintaining a link of free training resources, for those rainy Sunday afternoons. Why not open it up…
When a query, executed by other users, results in an error, you will see <redacted> instead of the actual SQL Statement. The error is…
Stumbled upon this via LinkedIn, describes as:
My case for CI/CD in Snowflake is very specific: every 30 days I register for a new Snowflake 30 day trial, to run several experiments…
using Snowflake …………