Unable to query regions and services via Athena data source

[billyb315]

• 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
  

  

[yosiasz]

What do you see when you click Query Inspector or when you see the query call in your browser console or network tab

[billyb315]

same thing - it just hangs and eventually times out

[yosiasz]

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'"

[billyb315]

no that’s not it

[yosiasz]

well look at the error. it says line 8:20

the i/o timeout is just a red herring