It detects all of my stuff, i have given it full glue, s3, and athena permissions. the query works in athena. I am using aws managed Grafana.
I was asked to study this for my company but at this point I might have to use quicksight as this is still not working after 2 weeks for a simple query.
Some help would be nice as for whatever reason my company really wants to use this service.
I also tried the query without ;