Ilike snowflake
Going through this analysis should help with identifying a good starting point. Although every development team should strive to periodically refactor their code, many find it challenging to determine where to start. Many customers are interested in improving their query performance.
![ilike snowflake ilike snowflake](https://i.ytimg.com/vi/doV3xgk0Sj8/hqdefault.jpg)
Query profiling is perhaps one of the more popular topics I field questions about. Ready to get started? Here we go! Query History Profiling Typically, the SYSADMIN role has the necessary warehouse MONITOR privileges across your entire account however, other lower-level roles may also have the necessary privileges. Keep in mind that you’ll need warehouse MONITOR privileges to perform the tasks described in this post. I will also show you a handy page in the UI that provides a graphical view of each query. To do this, I will show you examples using the QUERY_HISTORY family of functions. In this final post, I will deep-dive into understanding query profiling. In my second post, I showed you how to get a handle on your storage usage.
![ilike snowflake ilike snowflake](https://m1.quebecormedia.com/emp/cl_prod/canadian_living-_-d6662565-53c4-4f3c-b003-d268ab921ce5-_-snow_winterlove.jpg)
In my first post, I discussed getting a handle on your utilization of compute resources by using various Information Schema views and functions to profile your virtual warehouse usage.
![ilike snowflake ilike snowflake](https://i.ytimg.com/vi/TbGPZOk2s9c/hqdefault.jpg)
This article about query profiling is the third in a three-part series to help you utilize the functionality and data in Snowflake’s Information Schema to better understand and effectively Snowflake.Īs a Customer Success Engineer, my daily job entails helping our customers get the most value from our service.