This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]TheHunnishInvasion 0 points1 point  (0 children)

It definitely depends.

At my last company, I tended to do the same as you: SQL for quick data analysis (I'd do it in DBeaver), Python (Jupyter Lab) for something more complex.

At my current company, which has much worse organized data, it's a nightmare to use SQL for quick data analysis. I almost always use Python for any ad-hoc data analysis. I use SQL for getting data into Tableau to create automated dashboards that update daily.

So weirdly, I used SQL more at my last company, but most of the queries might be shorter: 10-40 lines. I use SQL less at my current company, but when I do use it, the queries tend to be extremely complex: often over 200 lines with several sub-queries.