For dbt Cloud, dbt provides Extended Attributes, which let you define a profiles.yml snippet in your Environment settings.
Under the Deployment Settings for your Environment, add a host parameter to the Extended Attributes.
For example:
host: snowflake-locator.yukicomputing.com
dbt Core
For dbt Core, add a host parameter in your profiles.yml file.
For example: