Re: Window functions missing from MySQL



My data source is a flat file from FTP and i am using the SQL data flow in Domo for data transformations. I have a need to use rank function and am wondering if i can use rank() over window partition by method. I can use the MySQL method mentioned at below link, but the window method is throwing errors.

Does the redshift method work only when your data soruce is redshift databse? Thanks much in advance!

Best Answer