Snowflake – Analysis Query Performance

A client of mine for whom, I am doing consulting Snowflake Comprehensive Database Performance Health Check, recently asked me if I know any way to Analysis Query Performance. Of course, I do and let me show you how you can also do it.

Snowflake - Analysis Query Performance AnalysisQueryPerformance-800x333

When you log in to the Snowflake Computing platform, you should click on the History tab on the top of the portal.

Snowflake - Analysis Query Performance snowq1

Once you click on it, it will list all the queries. Over here, click on the Query ID of your preferred query.

Snowflake - Analysis Query Performance snowq2

Once you click on it, it will open the details page for you. Over here, click on the Query Profile and you will be able to see additional details.

Snowflake - Analysis Query Performance snowq3

Over here, click on Query Profile.

Snowflake - Analysis Query Performance snowq4

Over here, you will get all the details about your query which you can also use to compare the performance. If you have not read two of my previous blog posts, I suggest you read them as well.

Well, I hope you enjoyed this quick post on how to Analysis Query Performance for Snowflake.

Reach out to me on Twitter and we can talk more about it.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

,
Previous Post
SQL SERVER – Table Partitioning for Slow Performance
Next Post
SQL SERVER – List of Trace Events

Related Posts

Leave a Reply

Menu