Magic ETL

Magic ETL

How come MySQL does not support window function, specifically lag in dataflows?

Hi,

 

I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window function, specifically lag in dataflows? I have been googling and it seems that you are suppose to be able to use window functions with mysql: https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

but why is it not possible in Domo?

 

Thank you

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Comments

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In