in-db Summarize StandardDeviation not working in Snowflake

Question

I am working with a Snowflake database, connecting in-db. I cannot get the STDEV function in Summarize In-DB to work, no matter which workflow I'm using, I get the error "SQL compilation error: Unknown function STDEV", see screenshot. The field I want the standard deviation for is an Integer, so this is not the problem.

I note though that the standard deviation function in Snowflake is called STDDEV. Does anyone have an idea how to fix this? Am I doing something wrong?

it happens on every workflow so no need to attach. Thank you!

Screenshot 2024-09-30 105800.png

apathetichell · Accepted Answer

Hey - which driver are you using?

so there are two pieces of semi-good news here.

1) this is definitely fixable if if you rewrite your in-db logic to be sql heavy vs tool heavy (ie Alteryx will correctly process the STDDEV function is you code it in SQL).

2) on my tests - Snowflake DSII driver 3.01/Alteryx 2021.4 the Summarize In-DB DOES correctly use the STDDEV function (ie - I don't see your error) -> at least for one column. I have not tested using groups yet.

confirmed - no issue with using group-bys in the summarize in-db tool when using the DSII driver.