[Bug]: The resource 'snowflake_warehouse' doesn't allow resource_constraint as a variable

[scottl33]

Terraform CLI Version

1.11.0

Terraform Provider Version

0.99.0

Company Name

OLO

Terraform Configuration

resource "snowflake_warehouse" "snowpark_wh" {
  name = "SNOWPARK_WAREHOUSE"

  warehouse_size = "xsmall"
  warehouse_type = "SNOWPARK-OPTIMIZED"
}

Category

category:resource

Object type(s)

resource:warehouse

Expected Behavior

Create a snowpark optimized warehouse as an XS

Actual Behavior

When creating a snowpark-optimized warehouse as an XS
invalid property combination 'RESOURCE_CONSTRAINT'='MEMORY_16X' and 'WAREHOUSE_SIZE'='X-Small'
The variable, 'RESOURCE_CONSTRAINT' is not defined in the provider. This makes it so user's have to select at least a medium instance and do not have control over allocating a larger resource constraint for larger warehouses.

Steps to Reproduce

resource "snowflake_warehouse" "snowpark_wh" {
name = "SNOWPARK_WAREHOUSE"

warehouse_size = "xsmall"
warehouse_type = "SNOWPARK-OPTIMIZED"
}

How much impact is this issue causing?

Low

Logs

No response

Additional Information

The only workaround is to select at least a medium warehouse. I am currently testing what the behavior is with bigger warehouses.

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hello @scottl33 👋
This was recently added to the warehouse object, so it's not in the warehouse resource yet. I see you checked the checkbox about implementing this feature yourself. Please read our contributing guidelines, and in case of any issues (or questions about the implementation), use this thread for communication. Thanks :)