[Bug]: snowflake_table_constraint wrong default value

[martinw-intersport]

Terraform CLI Version

1.10.5

Terraform Provider Version

1.0.2

Company Name

No response

Terraform Configuration

# Add foreign key constraints
resource "snowflake_table_constraint" "constraint" {
  name     = "FKEY"
  type     = "FOREIGN KEY"
  enforced = false
  table_id = snowflake_table.b.fully_qualified_name
  columns  = ["ID"]
  foreign_key_properties {
    references {
      table_id = snowflake_table.a.fully_qualified_name
      columns  = ["ID"]
    }
  }
}

Category

category:resource

Object type(s)

No response

Expected Behavior

According to https://docs.snowflake.com/en/sql-reference/sql/create-table-constraint#constraint-properties, the default value are NOT DEFERRABLE and DISABLE, so deferrable = false and enable= false

Actual Behavior

current terraform plan

+ resource "snowflake_table_constraint" "constraint" {
       + columns    = [
           + "ID",
         ]
       + deferrable = true  <-----wrong
       + enable     = true  <-----wrong
       + enforced   = false
       + id         = (known after apply)
       + initially  = "DEFERRED"
       + name       = "FKEY"
       + rely       = true
       + table_id   = (known after apply)
       + type       = "FOREIGN KEY"
       + validate   = false
       + foreign_key_properties {
           + match     = "FULL"
           + on_delete = "NO ACTION"
           + on_update = "NO ACTION"
           + references {
               + columns  = [
                   + "ID",
                 ]
               + table_id = "..."
             }
         }
     }

Steps to Reproduce

1. Copy Terraform Configuration
2. Run terraform plan
3. Check enable and deferrable value

How much impact is this issue causing?

Low

Logs

No response

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @martinw-intersport. Thanks for reaching out to us.

The default values for older versions of the provided were baked in the provider. We went away from it (check https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/v1-preparations/CHANGES_BEFORE_V1.md#default-values). Sadly, the generated resource docs do not show the tf default, I will make sure we are adding the defaults (if present) in the newest provider versions docs.

As for the defaults in this resource - we will rework it after GA and fallback correctly to Snowflake defaults.