Timeout on terraform apply

[jcenzano-fong]

I'm new to Terraform in general and am trying to follow a tutorial for using this provider. I deviated from the instructions because I am using the 0.24 version so updated the version for the provider in main.tf:

terraform {
  required_providers {
    snowflake = {
      source  = "chanzuckerberg/snowflake"
      version = "0.24.0"
    }
  }
}

provider "snowflake" {
  role     = "SYSADMIN"
}

resource "snowflake_database" "db" {
  name = "TF_DEMO"
}

resource "snowflake_warehouse" "warehouse" {
  name           = "TF_DEMO"
  warehouse_size = "xsmall"

  auto_suspend = 60
}

The instructions seem straightforward and match what I'm doing at the command line until the apply step. Then I get this:

% terraform apply

An execution plan has been generated and is shown below.
Resource actions are indicated with the following symbols:
  + create

Terraform will perform the following actions:

  # snowflake_database.db will be created
  + resource "snowflake_database" "db" {
      + data_retention_time_in_days = (known after apply)
      + id                          = (known after apply)
      + name                        = "TF_DEMO"
    }

  # snowflake_warehouse.warehouse will be created
  + resource "snowflake_warehouse" "warehouse" {
      + auto_resume                  = (known after apply)
      + auto_suspend                 = 60
      + id                           = (known after apply)
      + max_cluster_count            = (known after apply)
      + min_cluster_count            = (known after apply)
      + name                         = "TF_DEMO"
      + resource_monitor             = (known after apply)
      + scaling_policy               = (known after apply)
      + statement_timeout_in_seconds = 0
      + warehouse_size               = "xsmall"
    }

Plan: 2 to add, 0 to change, 0 to destroy.

Do you want to perform these actions?
  Terraform will perform the actions described above.
  Only 'yes' will be accepted to approve.

  Enter a value: yes

snowflake_database.db: Creating...
snowflake_warehouse.warehouse: Creating...
snowflake_warehouse.warehouse: Still creating... [10s elapsed]
snowflake_database.db: Still creating... [10s elapsed]
snowflake_database.db: Still creating... [20s elapsed]
snowflake_warehouse.warehouse: Still creating... [20s elapsed]
snowflake_database.db: Still creating... [30s elapsed]
snowflake_warehouse.warehouse: Still creating... [30s elapsed]
snowflake_warehouse.warehouse: Still creating... [40s elapsed]
snowflake_database.db: Still creating... [40s elapsed]
snowflake_warehouse.warehouse: Still creating... [50s elapsed]
snowflake_database.db: Still creating... [50s elapsed]
snowflake_warehouse.warehouse: Still creating... [1m0s elapsed]

Error: error creating database: timeout after 1m0s. HTTP Status: 502. Hanging?

  on main.tf line 14, in resource "snowflake_database" "db":
  14: resource "snowflake_database" "db" {



Error: error creating warehouse: timeout after 1m0s. HTTP Status: 502. Hanging?

  on main.tf line 18, in resource "snowflake_warehouse" "warehouse":
  18: resource "snowflake_warehouse" "warehouse" {

I've run this by people at my company that use Terraform regularly, and they didn't have any particular ideas.
I'm assuming it is something on the snowflake side. I've confirmed the key matched what I put into the config. I tried switching to a new user using a password but still no luck. I was able to login to the Snowflake UI with the username and password fine. Are there particular Snowflake settings that could be affecting this? Any suggestions would be helpful.

[jcenzano-fong]

Turns out setting the SNOWFLAKE_REGION was the problem. When I unset that environment variable then the apply would work.