Grafana simple query does not work

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 ;

Use inspector and check what is in the response. You have AMG, so you can ask for support from AWS.