feat: support host option to pass down to driver

[Dirrk]

Allows the provider to accept a host value that is passed down to the snowflakego driver. In addition, if Host is set it unsets the region value due to the way the driver attempts to hack the region back into the host incorrectly for privatelink.

Test Plan

• acceptance tests

References

• We built this module into our terraform container and have tested this to validate that it is working with our snowflake setup which only allows privatelink connections.
• Securing snowflake to only privatelink connections requires blocking public ips via the network security policy and using a custom privatelink domain ie: account.region.privatelink.snowflakecomputing.com
• This should solve feat: Add AWS privatelink connectivity support #926 as I worked directly with scott on this
• Should essentially solve Deprecate region #447 while being backward compatible

[alldoami]

Should we not close #926 if this fixes it? Is this a replacement PR for it?

[Dirrk]

@alldoami yes, I will reach out Scott to close it.

[alldoami]

/ok-to-test sha=de1d03b

[github-actions]

Integration tests success for de1d03b

[alldoami]

Could you run make docs?

[alldoami]

/ok-to-test sha=2b1d9eb

[github-actions]

Integration tests success for 2b1d9eb

[aidanmelen]

forgot to update the provider docs 😉

• Provider docs haven't been updated with the new host arg #959