Tag Archives: INDB

Faster field name edits in Alteryx

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 , | Leave a comment

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

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 address INDB Union Error With Alteryx and Redshift

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