SQL functions limitation in SQL action tile

ValentinaSav

Hello, I have tried to create a SQL action tile in magic ETL for percentile calculation and have my code was not working. Looks like the DOMO was not able to recognize the formula:

PERCENTILE_CONT ( numeric_literal ) WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ] ) OVER ( [ <partition_by_clause> ] )

Does the SQL Action tile has some limitation currently and not all sql functions are available?

Thank you!

rco

Magic ETL's SQL tile does not support all SQL functions and statements*. A list of supported functions can be found here: https://domo-support.domo.com/s/article/360044289573?language=en_US

The PERCENTILE_CONT function is not a supported function. The WITHIN GROUP clause is not supported for any functions in Magic ETL, nor is the OVER clause.

We're actively working on adding functionality to Magic ETL and the SQL tile in particular. OVER clauses and their associated family of functions are a very high priority for us.

* For what it's worth, there isn't a SQL implementation in existence that does.

rco

Magic ETL's SQL tile does not support all SQL functions and statements*. A list of supported functions can be found here: https://domo-support.domo.com/s/article/360044289573?language=en_US

The PERCENTILE_CONT function is not a supported function. The WITHIN GROUP clause is not supported for any functions in Magic ETL, nor is the OVER clause.

We're actively working on adding functionality to Magic ETL and the SQL tile in particular. OVER clauses and their associated family of functions are a very high priority for us.

* For what it's worth, there isn't a SQL implementation in existence that does.

ValentinaSav

Thank you very much for quick response! Well will look forward to see some updates i this soon as it will be huge improvement and speeding up of our work :)