"Here's 3 CTEs. Finish the model by joining them and grouping by X, Y, Z".
I'm also sadly not working with anyone more experienced then me so it's a good discussion partner for discussing tradeoffs or alternative ways of doing things. For instance, I created a model which did a self join to get create a new column with the previous years value. I asked it if I could do it differently and it suggested the LAG function - however, it doesn't deal with leap years so it wasn't viable in my case.
It's pretty good at error messages and finding faults in code, so it's usually a good place to start if I'm confused.
It's also been pretty good for discussing architectural decisions and tradeoffs. It's given me great answers to how to create and manage environments, deal with config files and more.
Honestly, it's been amazing for learning DBT and has greatly helped me write code. Probably increased my productivity by 30-50%. But I think I'm in the sweet spot of GPT. I know enough SQL and data engineering to see through the bullshit, but getting the bit more than basics surfaced and getting some direction has been great.
Otherwise, it's pretty good for writing emails and such, but it isn't as good in norwegian as english and I'm pretty comfortable with my writing style so I use it less for that.
Sadly, it's not great at Dagster (my orchestrator) as there's not a lot of code out there and a lot has changed since the knowledge cutoff in 2021. I'm hoping some LLMs will be able to help with this in the future. Let me know if anyone has any tips here.