to add:

folderstructure, plus add a folder parameter to execute only that folder

An alternative option is to use the session_id, follow this link for more info:

https://community.snowflake.com/s/article/Getting-the-execution-details-of-procedure

Optimizing Snowflake (4): monitoring and debugging stored procedures using query tagging

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

Snowflake — CI/CD tooling

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…

pubished the github repo

https://github.com/datadutch/SFexecute

Snowflake — LISTAGG (&Copilot)

We have a requirement where we want to see the top customers with the largest orders. This could lead to a query like this:

Snowflake Copilot

One of the public preview features that was recently launched: Snowflake Copilot. Introduced in April 2024, so Snowflake is a bit late to…

Snowflake scripting

This is really nice. Build blocks of code that can be used in stored procedures or tasks but also in the console.

Snowflake: 30 day trial

How to set this up, it is super easy:

Free training resources

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…

Snowflake — <redacted> queries

When a query, executed by other users, results in an error, you will see <redacted> instead of the actual SQL Statement. The error is…

Explore new tools: Evidence.dev

Stumbled upon this via LinkedIn, describes as: