Issue

When trying to run a query on Data Explorer in my Panther Console, the following error occurs: result size exceeded configured limit of 100MB

Resolution

To resolve this issue:

• Check for potential query optimizations such as adding a LIMIT e.g p_occurs_since(‘1 day’)

• Access the Snowsight (Snowflake UI) directly via BI User, which Panther Support can assist in creating.

  • NOTE: For Snowflake Connected customers, please contact your internal Snowflake Admin to gain access to Snowsight.

Cause

This issue occurs when the query result size is larger than the configured limit. The pipeline used to render search results has a limit on how much data is can process, which will cause this error when the search results exceed this limit.