Stored Procedure – Big Data Dave

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

March 21, 2020 Best Practices / Snowflake / SnowSQL / Stored Procedure

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

March 7, 2020 Calculated Field / Snowflake / SnowSQL / Stored Procedure / Tableau / Tableau Conference

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

February 25, 2020 Best Practices / Snowflake / SnowSQL / Stored Procedure

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

February 17, 2020 Best Practices / Snowflake / SnowSQL / Stored Procedure

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