Window functions missing from MySQL

henrikp
henrikp
in Dataflows

Hi, 

 

I'm trying to use SQL windowing functions with DOMO data flows, but they are not recognized. After checking for the version of MySQL, I saw that DOMO is still using an old version of MySQL: 5.6.28-76.1-56.

 

Window functions make time based analytics much easier and would be great to have for serious analytics. Now I need to either move the whole analytics pipeline to BigQuery or write complex joins. Are there plans to update MySQL to version 8.0.X ?

 

Thanks,

Henrik Petander

 

 

Best Answers

  • ST_-Superman-_
    ST_-Superman-_ 🔵
    Accepted Answer

    I agree that it would be nice to have this ability in MySQL data flows.  However, you can use window functions in redshift:1.png

     

     

     

  • cwolman
    cwolman 🟠
    Accepted Answer

    Domo hass implemented the window and rank functions in Magic ETL.  This is another option if you prefer not to use redshift.

Answers

  • henrikp
    henrikp

    Thank you, the option to choose the database is something I had overlooked.

    @ST_-Superman-_wrote:

    I agree that it would be nice to have this ability in MySQL data flows.  However, you can use window functions in redshift:1.png

     

     

     

     

  • henrikp
    henrikp

    Thank you, it's good to learn the alternative ways to solve the problem in DOMO.

Categories