I’m seeing a query being executed repeatedly on our warehouse and failing because it exceeds Panther's upper bound on compilation. How do I resolve this?

Last updated: September 3, 2024

Issue

I'm seeing a query being executed repeatedly on our warehouse and failing. What is Panther’s current upper bound on compilation?

Resolution

The upper bound on compilation is 3 minutes.

To resolve this issue:

  • Ensure you have a cluster key on p_event_time in that table.

  • Reduce the time window.

  • Remove many of the joins, unions, and flattening out of the scheduled query. Instead, preprocess that information using tasks to feed into a separate table (do this outside of Panther). Then, use Panther to run a simple query on the results table.

  • Fix your Snowflake query planner for this query.

If the above steps don't resolve your issue, please reach out to Panther Support.

Cause

This issue occurs when the calculation query exceeds the limit of 3 minutes.