Monitor and optimize performance — SnowPro® Core Certification

Official references for this objective

• Snowflake — GET_QUERY_OPERATOR_STATS | Snowflake Documentation

  you can use this function to identify joins that have more output rows than input rows, which can be a sign of an “exploding” join

• Snowflake — Monitor query activity with Query History | Snowflake Documentation

  Pruning — information on the effects of table pruning: Partitions scanned — number of partitions scanned so far. Partitions total — total number of partitions

• Snowflake — QUERY_HISTORY view | Snowflake Documentation

  percentage_scanned_from_cache FLOAT Percentage of data scanned from the local disk cache. The value ranges from 0.0 to 1.0. Multiply by 100 to get a true

• Snowflake — Using the Query Acceleration Service (QAS) | Snowflake Documentation

  If the query is eligible for query acceleration, the function returns the estimated query execution time for different query acceleration scale factors

• Snowflake — AGGREGATE_QUERY_HISTORY view | Snowflake Documentation

  QUEUED_OVERLOAD_TIME OBJECT Time (in milliseconds) spent in the warehouse queue, due to the warehouse being overloaded by the current query workload.

• Snowflake — SYSTEM$CLUSTERING_INFORMATION | Snowflake Documentation

  The higher the number, the more micro-partitions can be pruned from queries executed on the table, which has a corresponding impact on performance.

• Snowflake — Exploring execution times | Snowflake Documentation

  select Monitoring » Query History . Use the Duration column to understand how long it took a query to execute. You can sort the column

• Snowflake — Multi-cluster warehouses | Snowflake Documentation

  You can also see the cluster used to execute each statement that the warehouse processed. To choose which details to view, select the items such

• Snowflake — Optimizing query performance | Snowflake Documentation

  Optimization Storage cost Compute cost Search optimization service ✔ ✔ Query acceleration service ✔ Materialized view ✔ ✔ Clustering the table ✔

• Snowflake — Optimizing the warehouse cache | Snowflake Documentation

  provides the percentage of data scanned from cache, aggregated across all queries and broken out by warehouse