Snowflake: How About ALL of Them? The GROUP BY ALL Revelation
When my daughter was 18 months old, we found ourselves in the timeless parental negotiation that happens in driveways across
Category: Best Practices
Snowflake: Dynamic IN() Clause & Session Variables
Have you ever needed to program a dynamic IN() clause in Snowflake and found the process daunting in SQL? It’s
Snowflake & Count: A New SQL Notebook Experience for the Analyst
This almost needs to go unstated, but I write several SQL statements every day in Snowflake. The native Snowflake worksheet
Snowflake: Hybrid Relational JSON Tables
Have you ever had a new field or field rename break your ETL pipelines to the Data Warehouse and ultimately
Snowflake: VS Code, SQL Tools and GitHub
VS Code is the preferred IDE for many folks developing code for data and analytics. Now there is an extension
Snowflake: Create Nested JSON from Tables and Views with SQL
Snowflake’s native handling of JSON in both READ and WRITE operations is by far and away my favourite feature. For
Snowflake: Long Running Queries Seek & Destroy
So, you might have some long running queries in your Snowflake account? Let’s say someone is running a recursive cartesian
Snowflake: 10 Things Every Snowflake Admin Should be Doing to Optimize Credits
Snowflake is architecturally different from almost every traditional database system and cloud data warehouse. Snowflake has completely separated compute from
Snowflake: Command Not Found: SnowSQL
You have installed SnowSQL on your shiney MacBook and for some reason when you go to CLI like a boss
Snowflake: Dynamic Unload Path (Copy Into Location)
Sometimes the need arises to unload data from Snowflake tables and objects into a stage (S3 Bucket, Azure Container or
Big Data Dave 