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, Tableau and Big Data
So, you might have some long running queries in your Snowflake account? Let’s say someone is running a recursive cartesian
Snowflake is architecturally different from almost every traditional database system and cloud data warehouse. Snowflake has completely separated compute from
You have installed SnowSQL on your shiney MacBook and for some reason when you go to CLI like a boss
Sometimes the need arises to unload data from Snowflake tables and objects into a stage (S3 Bucket, Azure Container or
Doing functions like looping and dynamic sql functions in Tableau is hard or impossible. Things like counting a number of
Have you ever wanted to CREATE a warehouse in Snowflake, but not immediately use it? This can be frustrating default
As described previously in https://bigdatadave.com/2020/02/15/108/ the ‘SHOW’ system object command works well in Snowflake, but sometimes you need to have
UPDATED 17Feb2020: Turns out there is a more efficient way to Select Show <Object> to JSON. My friend Alan from
Have you ever wondered how to get back a list of files with a prefix from a Snowflake Stage? I