This topic lists information about what functions you can use in Spotfire, for example for writing custom expressions and adding calculated columns, when you work with in-database data tables from Snowflake.
Conversion
COALESCE, NULLIF, To_Char, Try_To_Boolean, Try_To_Date, Try_To_Double, Try_To_Number, Try_To_Time, Try_To_Timestamp
Date and Time functions
Add_Months, Convert_Timezone, CURDATE, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURTIME, Date_From_Parts, Date_Part, Date_Trunc, DateAdd, DateDiff, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, Last_Day, MINUTE, MONTH, MonthName, Next_Day, Previous_Day, QUARTER, SECOND, Time_From_Parts, Time_Slice, Timestamp_From_Parts, WEEK, YEAR
Math functions
ABS, ACOS, Acosh, ASIN, Asinh, ATAN, ATAN2, Atanh, Cbrt, CEILING, COS, Cosh, COT, DEGREES, EXP, Factorial, FLOOR, Haversine, Ln, LOG, MOD, PI, POWER, RADIANS, RAND, ROUND, SIGN, SIN, Sinh, SQRT, Square, TAN, Tanh, TRUNCATE
Note: In Spotfire, the input for the function Factorial must be an integer expression in the range 0-27. This differs from the range in Snowflake.
Operators
+, -, *, /
Statistical functions
Avg, Count, Listagg, Max, Median, Min, Stddev, Stddev_Pop, Stddev_Samp, Sum, UniqueCount, Var_Pop, Var_Samp, Variance, Variance_Pop, Variance_Samp
Text functions
ASCII, BIT_LENGTH, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, CharIndex, CONCAT, Contains, EditDistance, EndsWith, ILike, InitCap, INSERT, LCASE, LEFT, LENGTH, LikeAny, LOCATE, LOWER, LTRIM, OCTET_LENGTH, POSITION, RegExp_Count, RegExp_Instr, RegExp_Replace, RegExp_Substr, REPEAT, REPLACE, RIGHT, RLike, RTRIM, SPACE, StartsWith, Substr, SUBSTRING, Trim, UCASE, UPPER