[Wranglers] query_retry_cause in snowflake query_history table

[Ali, Saqib]

Often times Snowflake has to retry a query if the execution fails due to
warehouse capacity constraints. This slows overall querying process, and
you end up paying 2x or more for a single execution.

Luckily Snowflake surfaces the root cause if the query execution had to be
retried. This data is available in the query_history table in the field
called query_retry_cause.

It is a good idea to monitor this data point, and identify patterns which
lead to queries being retried on the WH.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250213/51dbf3a5/attachment.htm>