Astrato's Data Query Profile Insights detects and identifies query inefficiencies - no coding required. This feature works with Snowflake's new table function - GET_QUERY_OPERATOR_STATS - that returns statistics about individual operators within a query.
Figure 1: Right-click on any chart, scroll down to select Data Query Insights
Viewing your Data Query Insights
Right-click on any chart.
Scroll down to select Data Query Insights.
The Query Profile Insights details display beneath the formatted SQL query.
The results display a red circle when a common query inefficiency - Cartesian, Union, Memory, or Pruning - appears.
Click Copy result to send the results to your Snowflake administrator. The results include the number of rows scanned and the estimated credits the query uses.
Figure 2: View and copy the results of the data Query Profile.
Example of a query result