[Bug]: ENFORCE_NETWORK_RULES_FOR_INTERNAL_STAGES parameter setting does not work

[yuukiyamanaka]

Terraform CLI Version

1.9.4

Terraform Provider Version

1.0.1

Company Name

No response

Terraform Configuration

resource "snowflake_account_parameter" "enforce_network_rules_for_internal_stages" {
  key   = "ENFORCE_NETWORK_RULES_FOR_INTERNAL_STAGES"
  value = "true"

  lifecycle {
    prevent_destroy = true
  }
}

Category

category:resource

Object type(s)

resource:account_parameter

Expected Behavior

TF should run the below query

ALTER ACCOUNT SET ENFORCE_NETWORK_RULES_FOR_INTERNAL_STAGES = true

Actual Behavior

Raise the below error at terraform apply.

│ Error: 001003 (42000): SQL compilation error:
│ syntax error line 1 at position 204 unexpected '<EOF>'.

TF currently run the below Query

ALTER ACCOUNT SET ENFORCE_NETWORK_RULES_FOR_INTERNAL_STAGES

true parameter is missing.

Steps to Reproduce

1. Add resource block

resource "snowflake_account_parameter" "enforce_network_rules_for_internal_stages" {
  key   = "ENFORCE_NETWORK_RULES_FOR_INTERNAL_STAGES"
  value = "true"

  lifecycle {
    prevent_destroy = true
  }
}

2. terraform apply

How much impact is this issue causing?

Low

Logs

No response

Additional Information

This error raises because ENABLE_UNHANDLED_EXCEPTIONS_REPORTING is treated as keyword type parameter in SDK.
I create PR as reference for fix

#3343

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @yuukiyamanaka 👋

Thanks for reporting this and raising the PR. I added a small comment in the review.

[yuukiyamanaka]

I'm sorry for my late response.
Thank you for merging!

[sfc-gh-jmichalak]

Thanks for the response. FYI, we close the issues after the fixes are released (this one has not been released yet), and the fix is confirmed by the customer :) I'll reopen this for now, and close again after the release.

[yuukiyamanaka]

I'm sorry for the trouble and thank you very much.

[sfc-gh-jmichalak]

Hi @yuukiyamanaka 👋

We've released v1.0.3 with the fix (release, migration guide). Please upgrade to this version.