snowflake_current_account not able to fetch the account url correctly in account spanning multiple regions

[mhmcdonald]

Provider Version
0.68.2

Terraform Version
1.2.5

Describe the bug
If you're in an account that spans multiple regions, the data source snowflake_current_account is not able to fetch the account's url correctly. The reason for this is related to this AccountURL() function.

When you're in an account in an organization that spans multiple region groups, and you call current_region(), the value returned is prefixed with PUBLIC.. It's documented here. However, in the current implementation of the data source is not expecting the PUBLIC. string prefix.

Expected behavior
Regardless of the account you're in, using the snowflake_current_account data source should return a valid URL for the account, and should not raise this error.

Code samples and commands

Please add code examples and commands that were run to cause the problem.

data "snowflake_current_account" "this" {
}

resource "resource_name" "thing" {
     url  = data.snowflake_current_account.this.url
}

Add any other context about the problem here.