Category Archives: Snowflake

Weird query results on Snowflake

Posted on 2018-08-22 by Frederic

If, when you use Tableau or Alteryx to query a Snowflake Database, you are getting weird $ amounts, not matching what is the database, you are experiencing a known bug in the recent versions of the Snowflake ODBC driver: https://support.snowflake.net/s/article/Regression-in-ODBC-v2-16-4-v-2 … Continue reading →

Posted in Alteryx, Snowflake, Tableau | Tagged , | Comments Off on Weird query results on Snowflake

How to filter transactions by a calculated category using SQL Window Functions

Posted on 2018-01-03 by Frederic

Have you ever found yourself in a situation where you need to filter a set of transactions based on categories which need to be calculated from that same set? Let’s say you have a data set containing all the customer … Continue reading →

Posted in Alteryx, Marketing, Performance, Redshift, Snowflake, SQL | Tagged , , | 2 Comments

How to Load Data in Bulk to Snowflake with Alteryx

Posted on 2017-10-31 by Frederic

Why a post about Snowflake? What does Alteryx and Tableau have to do with Snowflake? Here is some context: as I was planning to launch my Data Lake consulting business, which is now launched, I was looking for a place … Continue reading →

Posted in Alteryx, Performance, Snowflake, SQL, Tableau | Tagged , , , , | 13 Comments