MySQL Rank over Partition/Window Functions

trafalger
trafalger Chicagoland, IL 🟠

Hello! I know there was a post in September 2018 talking about how Domo's MySQL version doesn't support Window functions thus you can't do Rank over partitions in MySQL dataflows - anyone if this is planning to change? It's cumbersome to have to kick out datasets to Magic just so I can rank them using partitions. 

 

Thanks! 

Comments

  • I would use a Redshift SQL data flow which will allow you to write Rank & Window functions using Redshift syntax. You can view their documentation examples here