Using the Explain Function
1. Using the Explain Function
Let's play a little game. I'm going to reveal a SQL statement, and you try to figure out what it does. Oh, and I'm only going to give you five seconds. Are you ready? Go! Time's up! How did you do? I'm guessing you didn't figure out much, let alone come up with any sort of description of the code in that time. To be honest, this SQL query is not exactly the most complex. But code can be hard to understand and it takes time to decipher it. And, to be fair, I don't think a human could figure out that SQL code in five seconds. Snowflake CoCo, on the other hand, is great at explaining code. All you have to do is highlight the code you are unfamiliar with and click the Explain button that appears. Snowflake CoCo is analyzing the code, and producing an explanation. As you can see, it was able to give a summary of what type of information this query will produce. It also gave a step-by-step explanation of how the query works. And, it did it in less than five seconds. The Explain button is such a little feature, but it has an amazing impact. Instead of spending hours struggling to understand some code, you can have an answer within seconds.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.