Unable to add dataset by SQL code

I have a query with me that runs in Hubble and Datanet, but doesn’t work when I try to input it directly in Quicksight. Can anyone please go through my code and let me know what I’m doing wrong please?

Code : https://paste.amazon.com/show/shettyst/1652863220

This is now fixed by changing RUNDATE used in Redshift to using date(sysdate)

1 Like