[Feature] If `location` is unspecified, use location present in `keyfile`/`keyfile_json`

[Prometheus3375]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

If location in BigQuery profile is not specified, it is defaulted to US. However, in my keyfile there is a field location which is set to EU. I would like dbt to use that field if profile's location is unspecified.

Describe alternatives you've considered

The alternative is to extract location from keyfile and set it explicitly, which may not be convenient when switching profiles and keyfiles.

Who will this benefit?

The use case is when using several different profiles for BigQuery. Because my keyfile is in EU, I need to specify location in every profile. Now, if I change to a keyfile in US I need to update all profiles again.

This feature allows to use location from the keyfile itself avoiding profile updates.

Are you interested in contributing this feature?

Nope.