[ISSUE] Edge cases for cloud type detection

[nkvuong]

An issue was reported in ucx, which is to do with how our Python SDK detects the cloud type. https://github.com/databrickslabs/ucx/issues/1757

Capturing some further debugging context: This appears to be down to improper handling of the suffix-matching approach for determining which environment the client is connecting through within the SDK, rather than UCX itself. When no match is found the SDK defaults to AWS. In the two scenarios I ran into:

• Using native token auth in DBR15 results in the DATABRICKS_HOST environment variable being suffixed with :443 causing a failure
• Using my local repro a trailing slash on the host cli config appeared to cause a similar failure.

In both cases the issue may be worked around by correcting the value of the host config or removing the erroneous aws_attributes.availability property from the generated UCX cluster policy.

[HariGS-DB]

the PR seems to have fixed this https://github.com/databricks/databricks-sdk-py/pull/681