### Apache Airflow Provider(s)

dbt-cloud

### Versions of Apache Airflow Providers

_No response_

### Apache Airflow version

2.3.3

### Operating System

Linux

### Deployment

Composer

### Deployment details

_No response_

### What happened

Trying to use the provider with dbt Cloud's new EMEA region (https://docs.getdbt.com/docs/deploy/regions) but not able to use the emea.dbt.com as a tenant, as it automatically adds `.getdbt.com` to the tenant



### What you think should happen instead

We should be able to change the entire URL - and it could still default to cloud.getdbt.com

### How to reproduce

_No response_

### Anything else

_No response_

### Are you willing to submit PR?

- [X] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"""An exception that indicates a job run failed to complete."""
class DbtCloudHook(HttpHook):
    """
    Interact with dbt Cloud using the V2 API.
    :param dbt_cloud_conn_id: The ID of the :ref:`dbt Cloud connection <howto/connection:dbt-cloud>`.
    """
    conn_name_attr = "dbt_cloud_conn_id"
    default_conn_name = "dbt_cloud_default"
    conn_type = "dbt_cloud"
    hook_name = "dbt Cloud"
    @staticmethod
    def get_ui_field_behaviour() -> dict[str, Any]:
        """Builds custom field behavior for the dbt Cloud connection form in the Airflow UI."""
        return {
            "hidden_fields": ["host", "port", "extra"],
            "relabeling": {"login": "Account ID", "password": "API Token", "schema": "Tenant"},
            "placeholders": {"schema": "Defaults to 'cloud'."},
        }
    def __init__(self, dbt_cloud_conn_id: str = default_conn_name, *args, **kwargs) -> None:
        super().__init__(auth_type=TokenAuth)
        self.dbt_cloud_conn_id = dbt_cloud_conn_id
        tenant = self.connection.schema if self.connection.schema else "cloud"
        self.base_url = f"https://{tenant}.getdbt.com/api/v2/accounts/"
    @cached_property
    def connection(self) -> Connection: