DEV Community

Discussion on: That’s not very Data Warehouse - an argument against elegant SQL code

Collapse
 
ericschillerdev profile image
Unfrozen Caveman Dev

I've worked doing SQL for back end operational systems AND data warehousing. SQL is literally the one constant in my 20 years of professional work.

Whoever said that about your code clearly missed the mark. Unless you were doing something horribly inefficient, making it readable and traceable is actual "elegance". Doubly so if you're doing analysis that might have to be demonstrated to someone else, or anything that gets reused down the road (dashboards, data integration, etc.) or has to be repeatable.

Good post and that person has the cowboy mentality that makes me think they have a fiefdom to protect via obscurity. Fail.