[Bug]: fails to createSNS topic on china due to bad aws partition

[cnshadzh]

Is there an existing issue for this?

• I have searched the existing issues

Affected Resource(s)

sns.aws.upbound.io/v1beta1 - Topic

Resource MRs required to reproduce the bug

No response

Steps to Reproduce

apiVersion: sns.aws.upbound.io/v1beta1 kind: Topic metadata: name: xxxxx-dms-events-topic spec: providerConfigRef: name: xxxxx-provider forProvider: region: cn-northwest-1

What happened?

Cannot create topic when set the region as cn-northwest-1, it seems the partition is hard coded as "arn:aws:xxxx" but actually what we want is "arn:aws-cn:xxx"

observe failed: failed to observe the resource: [{0 reading SNS Topic (arn:aws:sns:cn-northwest-1:12345678:xxxxxx-topic): operation error SNS: GetTopicAttributes, https response error StatusCode: 400, RequestID: 3fc47d1c-8f60-545f-b300-229ccd780f65, InvalidParameter: Invalid parameter: TopicArn Reason: A cn-northwest-1 ARN must begin with arn:aws-cn, not arn:aws:sns:cn-northwest-1:12345678:xxxxxxx-topic

Relevant Error Output Snippet

No response

Crossplane Version

1.14.5

Provider Version

1.14.0

Kubernetes Version

1.28

Kubernetes Distribution

EKS

Additional Info

No response