I’m fully aware my story yesterday — about the rather negative experience I had with Snowflake Scripting — was not a happy one. Neither is this. But I will keep it constructive and right to the point here. Because I certainly have one... Before specializing on cloud architectures and big…

I remember last February, when they announced the availability of Snowflake Scripting. Oracle had PL/SQL, Microsoft SQL Server had Transact-SQL, it was about time for Snowflake to come up with their own procedural SQL language. All in the general effort of bringing data processing closer to where the data is…

Querying hierarchical data is well documented for Snowflake. However, here is an extensive in-depth coverage of a very typical and frequent hierarchy, using self-joins on the same table. It is the parent-child hierarchy for fathers and sons, Facebook friends, employees and their managers etc. Each entity has one single identifier…

Python Worksheets are intended to make it easier to automatically generate stored procedures in Snowflake directly from pure Python code. When you run a Python worksheet, an on-the-fly temporary stored proc is created as a wrapper around your Python code and executed instead. When you Deploy the Python worksheet, you…

After my yesterday’s rand, about quitting the DSH program, I get a lot of feedback in support (a lot in private), and I thank you, guys. But I need to make it clear that I always loved the experience I had with Kate Windom at the Snowflake Certification SME! Why I had to quit Certification SME as well Two…

If you know about my previous rant (Why I Quit the Snowflake “Data Superhero” Program), you may say I’ll be subjective, and you could be right. But this is the best moment in fact to look back a bit, speak freely, share some info other people may be interested in…

I’ve been selected as the first Snowflake expert from Canada to join their DSH (“Data Superheroes”) program in Jan 2022, at the recommendation of one former employer. I’m top of the list here. They started the program in 2021, and every year they pick up some additional 25 people from…

Data Profilers for Tabular Data A data profiler became a must-have for any ad-hoc EDA (Exploratory Data Analysis). And Snowflake shows instant aggregate values and histograms for the data distribution of most numerical and categorical variables from a tabular result grid. For instance, run the query below in a worksheet, click on the AMOUNT column…

A while ago I wrote about an Entity-Relationship Diagram (ERD) generator for Snowflake, implemented as a separate proof-of-concept Python project using the Snowflake Connector. While Streamlit in Snowflake is now in Public Preview, let’s see how simple it is to build this project directly within your Snowflake account, as a…