Can I view the raw, expanded SQL from my scheduled and ad-hoc queries in Panther?
QUESTION
When crafting SQL queries in Panther, I can use various macros, such as p_occurs_since. Can I view the fully-expanded SQL query text, as it's fed to Snowflake, without the macros?
ANSWER
Currently we don't have a means to view this information from within Panther. However, if your Panther Instance is using a connected Snowflake account, then you can view the Query History through the Snowflake Console. The entries in Snowflake will have fully-expanded SQL.