A combination of a dataset with empty string vs null issue and poorly written case-when-else query just made me spend 4 hours debugging an ETL. Not sure if proud of my brilliance, or aware I’m a monkey that randomly wrote a Shakespearean SQL query.

Roberto Mateu @roberto