Skip to content
Big Data Dave

Big Data Dave

Snowflake, Tableau and Big Data

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

Category: SnowSQL

September 5, 2020 Best Practices / Governance / Snowflake / SnowSQL / Stored Procedure

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

Continue reading

August 29, 2020 Best Practices / Governance / Snowflake / SnowSQL

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

Continue reading

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.
  • Follow Following
    • Big Data Dave
    • Join 44 other followers
    • Already have a WordPress.com account? Log in now.
    • Big Data Dave
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar