Skip to content
Big Data Dave

Big Data Dave

Snowflake, Tableau and Big Data

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

Category: Best Practices

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 9, 2020 Best Practices / Error / Snowflake / Tableau

Tableau & Snowflake: Missing Warehouse when Opening Tableau Workbook

The most frustrating issue when working with Tableau and Snowflake together is opening a Tableau workbook or sending a Tableau

Continue reading

February 8, 2020 Best Practices / Calculated Field / Past / Tableau

Tableau: Convert Milliseconds or Seconds to HH:MM:SS (Military Time)

Converting milliseconds or seconds to additive military time with >24 hours in the hours bucket involves division, modulo division and

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.