I'm seeing a query being executed repeatedly on our warehouse and failing. What is Panther’s current upper bound on compilation?
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.
This issue occurs when the calculation query exceeds the limit of 3 minutes.