Error: could not retrieve session id err = 260008 (08004): failed to connect to db.

[samuelappinto]

Hi all,

I've used to connect to Snowflake just using the account in the provider configs. Below is my tf file:

terraform {
  required_providers {
    snowflake = {
      source  = "Snowflake-Labs/snowflake"
      version = "~> 0.61"
    }
  }
}

provider "snowflake" {
  account                = var.snowflake_account
  username               = var.snowflake_username
  password               = var.snowflake_password
  role                   = "TERRAFORM"
}

Now when I try to make a terraform plan I got the following error:

❯ terraform plan

Planning failed. Terraform encountered an error while generating this plan.

╷
│ Error: could not retrieve session id err = 260008 (08004): failed to connect to db. verify account name is correct. HTTP: 403, URL: https://bia75878.snowflakecomputing.com:443/session/v1/login-request?requestId=60a83433-0ac3-4a19-414b-2cc578e2645d&request_guid=50ae0d4f-6c9e-4110-4065-97400e6ffd0a&roleName=TERRAFORM
│ 
│   with provider["registry.terraform.io/snowflake-labs/snowflake"],
│   on versions.tf line 10, in provider "snowflake":
│   10: provider "snowflake" {

For the account var I'm just using my account name from current-account() output.

Can someone help me with this issue?

Thanks in advance