Short - SQL optimization

A really great use of the account agent is to help you optimize your SQL or even help you convert between different dialects. To show you how this works, I've got here a bit of a, a model which is of customer data running on BigQuery. And I just wanna add in the agent, point it to the cell, and ask it to help. Hey, Count AI. I've got this model of customer data here written for BigQuery. I'd love you to help me optimize it to make it more efficient and also tell me if there's any changes that we need to make for this to run the same on Redshift. Great. So let's go ahead and have a look at the query. And you can see that it's given me a few bits of areas I could optimize it right with a redundant where clause and a starry correlated subquery to make it better for BigQuery. And also, it's telling me what we'd need to change if I was gonna use it on Redshift.