-
What Grafana version and what operating system are you using?
-
managed grafana via AWS (10.4)
-
What are you trying to achieve?
-
cost visualizations
-
How are you trying to achieve it?
-
using the athena plugin
-
What happened?
-
cant get it configured to read the regions and services
-
What did you expect to happen?
-
would expect the query to succeed
-
Can you copy/paste the configuration(s) that you are having problems with?
-
I can run these queries in athena, but they fail from grafana:
-
select distinct product_location from cur;
select distinct line_item_product_code from cur; -
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
-
yes I get 400s/500s in the console:
-
"error": "error executing query: RequestError: send request failed\ncaused by: Post \"https://athena.us-east-1.amazonaws.com/\": dial tcp 18.214.248.62:443: i/o timeout", "errorSource": "", "status": 500, "frames": [
-
Did you follow any online instructions? If so, what is the URL?
-
have been debugging this for days
What do you see when you click Query Inspector or when you see the query call in your browser console or network tab
same thing - it just hangs and eventually times out
those field_name in ($variable)
look suspect. I think you need single quote interpolation on those.
check this out Variable syntax | Grafana documentation
servers = ['test1', 'test2']
String to interpolate: '${servers:singlequote}'
Interpolation result: "'test1','test2'"
no that’s not it
well look at the error. it says line 8:20
the i/o timeout
is just a red herring