Hi! I'm trying to calculate the cumulative sum on the native SQL query and I've used MySQL Amazon Redshift database. I'm using OVER (ORDER BY) clause but it won't seem to work. Any help would be appreciated!
Hi @kun08
Depending on which version of MySQL you're using, then you'll have to use correlated query (sub-select):
https://stackoverflow.com/questions/2563918/create-a-cumulative-sum-column-in-mysql
Multiple statements would require setting a connection string parameter, but I don't think that's possible with how you're using federated query through Redshift.
https://github.com/metabase/metabase/issues/4050