Hidden Beast Mode Functions

agolla2

Hello, I was wondering if anyone created a list of hidden beast mode functions like Partition By which is not shown in the function list, but it works when we actually use it.

david_cunningham

The best resource is the Beast Mode KB article.

https://domo-support.domo.com/s/article/360043429933?language=en_US

Another thing that I will sometimes do is to check the functions that work in ETL. Not all of them cross over to Beast Mode, but some do that are not listed in the Beast Mode function list in Analyzer. For example SUBSTRING_INDEX().

Lastly, beast modes are based on MySQL. There have been times when I've just tried something to see if it works, and it has.

https://www.w3schools.com/mysql/mysql_ref_functions.asp

In general, most of the functions that work are documented. The particular example you gave is actually a clause in a window function. https://www.geeksforgeeks.org/mysql-partition-by-clause/

david_cunningham

The best resource is the Beast Mode KB article.

https://domo-support.domo.com/s/article/360043429933?language=en_US

Another thing that I will sometimes do is to check the functions that work in ETL. Not all of them cross over to Beast Mode, but some do that are not listed in the Beast Mode function list in Analyzer. For example SUBSTRING_INDEX().

Lastly, beast modes are based on MySQL. There have been times when I've just tried something to see if it works, and it has.

https://www.w3schools.com/mysql/mysql_ref_functions.asp

In general, most of the functions that work are documented. The particular example you gave is actually a clause in a window function. https://www.geeksforgeeks.org/mysql-partition-by-clause/