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?
This is now fixed by changing RUNDATE used in Redshift to using date(sysdate)
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Query working in Redshift but fails in Quicksight | 4 | 773 | August 24, 2023 | |
| How to add fully created sql query to the Quick Sight in order to use for visualization? | 7 | 2470 | August 9, 2023 | |
| Not able to add additional filtering method (case when) to dataset | 9 | 286 | October 9, 2023 | |
| Error - "Your function expression contains unsupported data" even when the date format is valid | 5 | 472 | June 28, 2024 | |
| Datos incorrectos | 10 | 274 | June 1, 2024 |