2 ms·
The traumatising experience of SQL is that the scenario you describe being scale-invariant. The smallest question and the largest question both have the potenti
by roenxi 4y ago
The traumatising experience of SQL is that the scenario you describe being scale-invariant. The smallest question and the largest question both have the potential to be completely wrong for any inane reason. Often turns out that metrics the company has been using for months are totally bogus too in my experience, which is not a fun conversation to have.
So the life of an SQL analyst in their early days (it gets better as they learn to trust nothing) is either continuously pumping out garbage or constantly needing to go back and, very awkwardly, correct and redo work that people thought was finished (and those people were often happy with a bad result because it looked like something interesting was going on).
This article is highly misleading, approx. none of the time an analyst spends is working on writing 5 line queries. The analyst is the person who knows that the data table for the series A and B rounds has different semantics depending on the data round because someone screwed up the table design beyond recovery and therefore a plain COUNT(*) will give incorrect results. This tool would let people who don't understand that pump out garbage faster. That might be a win regardless, most analytics requests cannot possibly be value-add.
- fifilura 4y agoThis is very on point. As an Analyst your asset is to own the data and know all the odds and quirks. Very similar to how developers need to own their codebase. Yes you can ask chatGPT to write a complex function. But your job as a developer is to see how it fits in with the rest of the framework. The logic is the simple part. As many pointed out you also need to be brutally honest with the numbers and also the problems you may have caused or fixed. Trying to hide any problems will very quickly throw you downhill, into an extremely uncomfortable position. Although before it acquires feelings and a sense of job safety, I guess chatGPT can be better at that part.
- kqr 4y agoIt's so refreshing to read this discussion. I've had these thoughts and feelings a lot but this is the first time I see them reflected in other people!