Thursday, April 21, 2022
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.