From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Query profile

Query profile - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Query profile

“

There's nothing more frustrating to you and your users when your queries start to take a long time to execute. But what happens in Snowflake when you need to improve the performance of your queries? Well, in this section, we'll discuss what options you have available to improve query performance. And it's not always straightforward to work out why queries might be running slowly, so the most common approach is to try to pinpoint the worst performing part of your query. Once you've identified this area, you can hopefully work to optimize that component to improve performance. And this process all starts in Snowflake with the query profile. And this really provides a graphical representation of the query execution plan and how Snowflake's actually processing the query behind the scenes. Essentially, it's a series of steps in Snowflake that goes off to retrieve the data and process it to satisfy a query. Now, within the information schema that we've mentioned earlier in this course…

Contents