We are restricted to selecting only "standard regions".

mitsu-nishi commented 3 weeks ago

What happened: We are unable to execute Athena queries using the "me-central-1" region within the "Amazon Athena" data source. We attempted to manually input "me-central-1" into the "Default Region" field in the data source settings, but this did not resolve the issue.

What you expected to happen: When utilizing the "Amazon Athena" data source, we anticipate the ability to select non-standard regions, such as "me-central-1", from the "Region" dropdown menu within the Grafana interface. This would enable us to execute Athena queries within the UAE region.

How to reproduce it (as minimally and precisely as possible):

Configure a data source using "Amazon Athena".
Click the "Region" dropdown menu and review the available regions.
"me-central-1" is absent from the list, preventing us from executing Athena queries within the UAE region.

issue_20240610

Environment:

Grafana version: 10.2.3
Plugin version: 2.11.1
User OS & Browser: Windows & Google Chrome (125.0.6422.142)

sarahzinger commented 3 weeks ago

Hello @mitsu-nishi!

Thank you for reporting this issue to us. I see 3 bugs here:

one I think we should allow users to type in any region as a string if we're missing a region. We do this in other datasources and I think it works well. AWS is frequently updating new regions and we will always be a bit out of date.
We should add me-central-1 to our list of standard regions for athena (see here)
We should also add this region to our list of standard regions in the grafana-aws-sdk (whcih is used in our configuration settings) and ultimately pull the list for the query editor from this list so that we have once source of truth https://github.com/grafana/grafana-aws-sdk-react/blob/54fc2b4424d9a94961a2ccb6c4af9c38a0899541/src/regions.ts#L4

Will talk with the team about when we can prioritize working on this. Thanks again!

mitsu-nishi commented 3 weeks ago

Hello @sarahzinger Thank you for your reply.

I would also like to request support for the following regions, as they are experiencing similar issues.

・ap-south-2 ・ap-southeast-3 ・ap-southeast-4 ・ca-west-1 ・eu-central-2 ・eu-south-2 ・il-central-1 ・me-central-1

I have referenced the following documentation: https://docs.aws.amazon.com/general/latest/gr/athena.html

This would be helpful for future use cases. Thank you for your consideration.

grafana / athena-datasource

We are restricted to selecting only "standard regions". #330