bigdatadave

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

Have you ever needed to program a dynamic IN() clause in Snowflake and found the process daunting in SQL? It’s

I was attending a conference session last week, led by the great Kent Graziano, and a question came from the

This almost needs to go unstated, but I write several SQL statements every day in Snowflake. The native Snowflake worksheet

Have you ever had a new field or field rename break your ETL pipelines to the Data Warehouse and ultimately

Last week I published a blog article showcasing how to create a COVID-19 quadrant scatter plot by county and turn

With the COVID-19 crisis worsening in America right now, I was curious which areas of the country are being affected

VS Code is the preferred IDE for many folks developing code for data and analytics. Now there is an extension

I often get asked for better ways to visualize or interact with task dependencies and hierarchies beyond show tasks. I

Snowflake’s native handling of JSON in both READ and WRITE operations is by far and away my favourite feature. For