Why can't I save a Snowflake Script as a scheduled query in Panther?

Last updated: November 20, 2025

QUESTION

image (81).png

Why can't I save a scheduled query containing Snowflake Script in Panther? The script runs perfectly in Data Explore but fails when I try to save it as a scheduled query.

ANSWER

Consider using Panther's templated searches which could provide the flexibility you need. Scheduled queries in Panther only allow a single SQL statement and require consistent output structure. When you create a scheduled query, Panther executes your SQL inside a SELECT * FROM ( <YOUR SQL>) LIMIT 0 wrapper to determine the "shape" of the output during setup.