Skip to content
Big Data Dave

Big Data Dave

Snowflake, Tableau and Big Data

  • Home
  • Blog Feed
  • Search
  • About Big Data Dave

Category: SnowSQL

July 28, 2020 Best Practices / Snowflake / SnowSQL

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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

February 15, 2020 Best Practices / Governance / Snowflake / SnowSQL

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

Continue reading

February 3, 2020 Best Practices / Snowflake / SnowSQL

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

Continue reading

Posts navigation

«Previous Posts 1 2
Blog at WordPress.com.