snowflake warehouses break if not enterprise because of query_acceleration_max_scale_factor

[nick-amplify]

Terraform CLI and Provider Versions

Error: 001423 (22023): SQL compilation error: invalid property 'QUERY_ACCELERATION_MAX_SCALE_FACTOR'; feature 'Query Acceleration Service' not enabled
with module.snowflake_resources.snowflake_warehouse.tenant_warehouses["warehouse_name"]
on modules/snowflake-user-resources/main.tf line 267, in resource "snowflake_warehouse" "tenant_warehouses":
resource "snowflake_warehouse" "tenant_warehouses" {

Terraform Configuration

resource "snowflake_warehouse" "tenant_warehouses" {
  name                         = "NAME"
  comment                      = "for NAME"
  warehouse_size               = "SMALL" # will be updated when we want to create multiple warehouses
  auto_suspend                 = 60
  auto_resume                  = true
  statement_timeout_in_seconds = 21600

  enable_query_acceleration = false

}

### Expected Behavior

expecting it to provision the warehouse. 



### Actual Behavior

The bug that was fixed here: https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/1866, seems to have been re-introduced

### Steps to Reproduce

1. `terraform apply`


### How much impact is this issue causing?

High

### Logs

_No response_

### Additional Information

_No response_

[sfc-gh-asawicki]

Hey @nick-amplify. Thanks for reporting the issue.

Is this happening on both creation and update, or just on update?

[sfc-gh-asawicki]

Hey @nick-amplify, bumping the question from above.

[sfc-gh-asawicki]

Closing due to inactivity. Please open the new issue if the error persists in the newest provider version.

[loic-fontaine-msr]

Hey, I faced the same issue using 0.87.2, it worked simply after re-running terraform apply a second time.