Provider trying to enable unavailable feature: Invalid Property QUERY_ACCELERATION_MAX_SCALE_FACTOR

[DVAlexHiggs]

Provider Version

0.58.2 (I had this issue in 0.58.0 as well)

Terraform Version

1.4.0

Describe the bug

When creating a warehouse using Standard edition Snowflake, it tries to enable QUERY_ACCELERATION_MAX_SCALE_FACTOR which is unavailable in the Standard edition. It does this even with and without enable_query_acceleration = false in the resource definition.

Expected behavior

The warehouse should be created without trying to enable Query acceleration

Code samples and commands

With the following resource definitions:

resource "snowflake_warehouse" "sandbox_warehouse_x_small" {
  name           = "SANDBOX_XS"
  comment        = "Warehouse for use in the developer SANDBOX Database"
  warehouse_size = "x-small"
  enable_query_acceleration = false
}

OR

resource "snowflake_warehouse" "sandbox_warehouse_x_small" {
  name           = "SANDBOX_XS"
  comment        = "Warehouse for use in the developer SANDBOX Database"
  warehouse_size = "x-small"
}

terraform apply produces the following error:

│ Error: error creating warehouse err = 001423 (22023): SQL compilation error:
│ invalid property 'QUERY_ACCELERATION_MAX_SCALE_FACTOR'; feature 'Query Acceleration Service' not enabled
│ 
│   with snowflake_warehouse.sandbox_warehouse_x_small,
│   on warehouses.tf line 1, in resource "snowflake_warehouse" "sandbox_warehouse_x_small":
│    1: resource "snowflake_warehouse" "sandbox_warehouse_x_small" {
│ 

Additional context

• There is an existing (merged) PR for this that seems to have identified the same issue and 'fixed' it. Someone on that thread does point out it is still a bug though

[sicarul]

I'm also having this exact issue indirectly using the Pulumi provider that wraps this library: https://github.com/pulumi/pulumi-snowflake

[philippeboyd]

Yes this is indeed a bummer... however, a workaround that I found working for me is adding the following 2 parameters in the warehouse resource and I'm then able to create a Warehouse even on a Standard Account

enable_query_acceleration = false
query_acceleration_max_scale_factor = 0

[sicarul]

@philippeboyd this workaround worked for me, thanks

[deivid-fatsecret]

I'm using version 0.63 and got the error message even using the work around.
Below is my script.

resource "snowflake_warehouse" "terraform" {
  name           = "TERRAFORM"
  comment        = "The warehouse used for applying Terraform"
  warehouse_size = "small"

  auto_resume         = true
  auto_suspend        = 1
  initially_suspended = true

  enable_query_acceleration = false
  query_acceleration_max_scale_factor = 0
}

Error: error altering warehouse err = 001423 (22023): SQL compilation error:
│ invalid property 'QUERY_ACCELERATION_MAX_SCALE_FACTOR'; feature 'Query Acceleration Service' not enabled
│
│ with snowflake_warehouse.terraform,
│ on warehouses.tf line 61, in resource "snowflake_warehouse" "terraform":
│ 61: resource "snowflake_warehouse" "terraform" {

[PaulJulienRipoll]

[0.65.0] Any updates on this? I can relate the exact same thing as @deivid-fatsecret said.

[bperkovic]

Same here with version 0.65, downgraded provider version to 0.63 that worked in past but now that one also doesnt work.

[vanducng]

current at 0.66.1 also still persists.

[bgabrhelik-com]

Furthermore the workaround above doesn't work for me in 0.66.1. I had to downgrade to 0.64.0

resource "snowflake_warehouse" "task_usage" {
  name = "TASK_PROCESSING"
  warehouse_size = var.processing_wh_size
  auto_resume = true
  auto_suspend = 300
  initially_suspended = true
  enable_query_acceleration = false
  query_acceleration_max_scale_factor = 0
  provider = snowflake.sys-admin
}

[clairemermet]

I confirm that the workaround doesn't work for version 0.66.1. Downgrade to 0.64.0 works.

[corrylc]

I am hitting this issue as well, and cannot create warehouses as a result. Any chance we can fix this breaking issue soon @sfc-gh-swinkler @sfc-gh-ngaberel?

[corrylc]

A workaround for the current provider version is to create the warehouse manually, then import it into Terraform.

[kulkarnisuraj92]

Stuck in a deadlock where getting this issue in 0.66.2 and older versions are resulting in #1868 not able to make complete deployment. Can we fix this issue soon? @sfc-gh-swinkler @sfc-gh-ngaberel