I have a flat file data source.
I'd LOVE to use row_number() OVER ( PARTITION BY id ORDER BY id ASC ) against my flat file data source.
But when I do, I get this:
Finished with error: Error executing view: Function row_number is not executable
I saw another post stating that analytic functions are delegated to the source, but what if the source is a flat file? Is it on the roadmap to be able to perform analytic functions (like row_number() over ()) against flat file sources?