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
Author: bigdatadave
Tableau & Snowflake: COVID-19 by County Quadrants & Maps fixing Utah Counties
Last week I published a blog article showcasing how to create a COVID-19 quadrant scatter plot by county and turn
Tableau & Snowflake: COVID-19 by County Quadrants & Maps
With the COVID-19 crisis worsening in America right now, I was curious which areas of the country are being affected
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: Visualizing Tasks Hierarchy, Tree, Dependencies in Snowsight
I often get asked for better ways to visualize or interact with task dependencies and hierarchies beyond show tasks. I
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
Tableau & Snowflake: Pass-Through SQL with Session Variables and Parameters
With pass-through SQL in Tableau and Snowflake you can set session variables in Snowflake to deliver on a variety of
Snowflake: Hands-on with the Snowflake Data Marketplace, Wunderman and COVID-19
The Snowflake Data Marketplace is quickly becoming one of my favourite things about working at Snowflake. With the marketplace I
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
