Category Archives: SQL

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

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

How to Load Data in Bulk to Snowflake with Alteryx

Posted on 31 October, 2017 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 , , , , | Leave a comment

10 Tricks to adopt Redshift In-DB

Posted on 1 December, 2016 by Frederic

If you are still manipulating data in Excel, why should you care about In-DB and Redshift? Whether you are accessing your Redshift data through Alteryx or through Tableau, knowing how to prepare your data within Redshift, with In-DB tool in … Continue reading →

Posted in Alteryx, Performance, Redshift, SQL, Tableau | Tagged , , , | 1 Comment

How to address INDB Union Error With Alteryx and Redshift

Posted on 9 August, 2016 by Frederic

When playing with Alteryx on a Amazon Redshift database with INDB tools, have you ever come up with the impenetrable error: Error: Browse In-DB (36): Error SQLPrepare: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: UNION … Continue reading →

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