We're connecting to Sisense via Live-model on Snowflake DWH
when you use function sum("TEXT_FIELD") on snowflake it will create an auto-cast to numeric even though the type listed as varchar. if the varchar contain text value the sum will fail.
Until now when we tried to create a function of sum("TEXT_FIELD") in Sisense widget, it would work as the sql query behind will work.
after we upgraded to the latest patch the widget will prevent this use and will fail existing production widgets who uses this.
Our production has multiple of failed widgets because of it we need your help ASAP!
Waiting for your reply,
Ori
