SQL functions limitation in SQL action tile

ValentinaSav
ValentinaSav Member
in Magic ETL

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!

Best Answer

  • rco
    rco Domo Employee
    Answer ✓

    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.

    Randall Oveson <randall.oveson@domo.com>

Answers

  • rco
    rco Domo Employee
    Answer ✓

    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.

    Randall Oveson <randall.oveson@domo.com>

  • ValentinaSav
    ValentinaSav Member

    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 :)

Categories