Data Warehouse Transformation Code Smells

Keep on the lookout for these trouble signs in SQL transforms

Photo by Jakub Kapusnak on Unsplash

There is a strange paradigm in Data Engineering when it comes to transformation code. While we increasingly hold extract and load (“EL”) programming to production software standards, transform code continues to be treated as a second-class citizen. Ironically, transform code often contains…