Yeah I have yet to really open the hood and learn more about query plans (which enable the computation ability you mention). I’ve been running into OOM errors a

Yeah I have yet to really open the hood and learn more about query plans (which enable the computation ability you mention). I’ve been running into OOM errors all week and luckily the system gives me advice on where to find the cause. I’d like to learn more about how to determine what parameters to set (like partitioned vs broadcast joins) because even after all this time using SQL it still feels like an alien technology to me especially when my SQL is syntactically correct but causing worker explosions left and right lol. There’s no better feeling than refactoring the code and seeing a job that used to time out run and you see how much data is being processed efficiently like that.