Category Archives: Snowflake

Alteryx INDB Traps and Limitations Series: Filtering Nulls

Posted on 11 April, 2019 by Frederic

I get to spend a lot of quality time with INDB tools, which represent 90% of my workflows. I love them, I can generate code almost at the speed of thoughts.Workflow INDB are also very powerful, especially when coupled with … Continue reading →

Posted in Alteryx, Redshift, Snowflake, SQL | Leave a comment

TC18 Tableau Conference Highlights

Posted on 4 November, 2018 by Frederic

I skipped the Tableau conference last year as it was taking place in Vegas, and that is usually not a good experience, even without crowd shooters. I was happy to partake again this year to TC18, which took place in … Continue reading →

Posted in Snowflake, Tableau | Tagged | Leave a comment

Faster field name edits in Alteryx

Posted on 15 October, 2018 by Frederic

From a distance, editing field names might not seem such a big issue, worth dedicating a blog post. Yet, I realize how much experience I gained over time, dealing with such minor issues, which end up affecting my productivity significantly … Continue reading →

Posted in Alteryx, Performance, Productivity, Redshift, Snowflake | Tagged , | 1 Comment

Weird query results on Snowflake

Posted on 22 August, 2018 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 , | Leave a comment

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

Posted on 3 January, 2018 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 , | Leave a comment