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
Category: SnowSQL
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: 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
Snowflake: Create Without Use Warehouse
Have you ever wanted to CREATE a warehouse in Snowflake, but not immediately use it? This can be frustrating default
UPDATED Snowflake: Select Show to JSON
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
Snowflake: Select Show to JSON
UPDATED 17Feb2020: Turns out there is a more efficient way to Select Show <Object> to JSON. My friend Alan from
Snowflake: List files from Stage with Prefix or Starts With
Have you ever wondered how to get back a list of files with a prefix from a Snowflake Stage? I
