An Architect runs the following query:
What information does this query return?
query_hash is derived from canonicalized SQL text and can be used to group and analyze repeated query patterns. The query aggregates execution time by that hash for WH_L over the last 3 days, calculates c by converting milliseconds to hours (1000 × 60 × 60) and multiplying by 8, then returns the 10 groups with the largest calculated value. A Large standard warehouse consumes 8 credits per hour, making c a relative credit estimate based on cumulative execution time.
query_hash
WH_L
c
1000 × 60 × 60
Community Discussion