I have uploaded a csv to a new install of apache superset, and I am querying it. So far it has been fine, but I am trying to use window functions, such as:
SELECT *, ROW_NUMBER() OVER( ORDER BY some_timestamp_utc) AS RowNumberRank FROM StudentScore
select *, RANK() OVER(ORDER BY some_timestamp_utc) AS NoId from StudentScore
These are not running (throwing an error saying near "(": syntax error. What is happening here and how can I use these window functions within superset on my uploaded csv table? Thanks.