Privatelink host in provider's block

[PLsergent]

Provider Version

0.66.1

Terraform Version

1.3.9

Describe the bug

Unable to authenticate using privatelink host "....privatelink.snowflakecomputing.com"

Expected behavior

Authenticate properly

Code

provider "snowflake" {
  account  = "${var.SNOWFLAKE_ORG}-${var.SNOWFLAKE_ACCOUNT}" # the Snowflake account identifier
  username = var.SNOWFLAKE_USERNAME                          # the Snowflake user name
  # Password defined with env variable SNOWFLAKE_PASSWORD
  role = "ACCOUNTADMIN"
  host = "app-${var.SNOWFLAKE_ORG}-${var.SNOWFLAKE_ACCOUNT}.privatelink.snowflakecomputing.com" # here
}

Additional context

I set up the Azure private link following the documentation: https://docs.snowflake.com/en/user-guide/privatelink-azure, everything is working properly since I'm able to access the UI with the privatelink host from a VM that is within the virtual network.

The problem is that I'd like to create a "network policy" on Snowflake using Terraform to restrict access to only the private IPs coming from the virtual network. But if I do then I can't use Terraform anymore since it is using the "public" host. Also, I'm using a pipeline running on VMSS instances hence the IPs are constantly changing so I can't whitelist my CI.
So I tried to use the privatelink host in the provider's block so the network policy won't block Terraform. But it's not working with the following error message. Is it even possible to use the privatelink host with the provider?
Thanks :)

Error message:

Error: could not retrieve session id err = 261004 (08004): failed to auth for unknown reason. HTTP: 405

[sfc-gh-swinkler]

@PLsergent I am wondering where Terraform is running, and if it is part of the virtual network that you have configured. I personally have not used the Azure privatelink before, but we do use a private Snowflake that I can only connect to when I am on the VPN, wondering if that is all similar. it looks like you have done the right thing by setting host. Perhaps the best next thing to do would be to schedule a call with you to investigate further. If you could please reach out to your Snowflake account representative and have them send a message to me that would be great.

[sfc-gh-asawicki]

Hey @PLsergent. Was this issue resolved?