Performance considerations and monitoring
Because the Snowflake services layer takes care of query tuning and optimization, writing efficient queries and following best practices should be the developer’s only concern. To do this, Snowflake provides a visual query profile to break down query execution into constituent substeps and help identify potential issues. A sample query profile can be seen in the following screenshot:
Figure 12.10 – Snowflake query profile
A good way to familiarize yourself with the query profile screen is by reviewing the kinds of query issues that it is designed to identify. The numbers in the query profile correspond to the topics listed in the following section.
Common query problems
Most day-to-day query issues can be identified by paying attention to the information displayed in the query profile and following the query best practices described here:
