Hi, Could I get some help with this trace ID error:

951f7f311c4a8976cf7dba5d7a387669

"An error has occurred while calculating the result" is all I'm getting. Happening for various (all?) visualizations?

Hi Tim, you are right, if I follow exclusively the TraceID you provided,

951f7f311c4a8976cf7dba5d7a387669

, I can see the same 'An error has occurred while calculating the result' message as you, and some 'DATA_ERROR' entries. However, looking deeper, at the same timestamp, I can see other logs where the primary error is a SQL execution failure:

"msg": "Execution of SQL statement has failed"

and

Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: SQL access control error: Insufficient privileges to operate on table 'sales'

This strongly indicates that the root cause is a permissions issue on the 'sales' table in your Snowflake environment. From the initial log review, the 'DATA_ERROR' seems to be a secondary effect of this underlying access problem. To help us pinpoint the precise issue, could you please clarify how exactly you are trying to create this visualization? Are you working directly within the UI, using an embedded visualization, or interacting via an API? Also, please double-check your Snowflake connection configuration to ensure the correct user role is being utilized. Providing a HAR file from your browser's developer tools during the error occurrence will be helpful.

Hi Mauricio, yes I figured it out by troubleshooting permissions on the Snowflake side. Thanks for your help!

Your welcome 🙂