### 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)

RUN_ID = 5555
BASE_URL = "https://cloud.getdbt.com/api/v2/accounts/"
SINGLE_TENANT_URL = "https://single.tenant.getdbt.com/api/v2/accounts/"
class TestDbtCloudJobRunStatus:
    valid_job_run_statuses = [
        1,  
        2,  
        3,  
        10,  
        20,  
        30,  
        [1, 2, 3],  
        {10, 20, 30},  
    ]
    invalid_job_run_statuses = [
        123,  
        [123, 23, 65],  
        [1, 2, 65],  
        "1",  
        "12",
        ["1", "2", "65"],
    ]
    def _get_ids(status_set: Any):
        return [f"checking_status_{argval}" for argval in status_set]
    @pytest.mark.parametrize(
        argnames="statuses",
        argvalues=valid_job_run_statuses,
        ids=_get_ids(valid_job_run_statuses),
    )
    def test_valid_job_run_status(self, statuses):