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.