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
Author: bigdatadave
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
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
Tableau & Snowflake: Flattening the Curve at Human Scale
If the mission is to “Help people see and understand data” and to “help every organization to be data-driven” then
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
Tableau & Snowflake SnowTel: Snowflake Query Telemetry in a Tableau Workbook
Snowflake ships all Query Telemetry from an account over Data Sharing back to account and system administrators of Snowflake. I
Tableau & Snowflake: SQL UDFs and Workdays Example
Doing functions like looping and dynamic sql functions in Tableau is hard or impossible. Things like counting a number of
Big Data Dave 