Error: Invalid object parameter | Ref Snowflake Support Ticket 00675051

[ravisingh27]

Terraform CLI and Provider Versions

0.72.0 and latest

Terraform Configuration

resource "snowflake_account_parameter" "account_parameter1" {
  key   = "TRANSACTION_ABORT_ON_ERROR"
  value = "true"
}

resource "snowflake_account_parameter" "account_parameter2" {
  key   = "QUOTED_IDENTIFIERS_IGNORE_CASE"
  value = "true"
}

Expected Behavior

We are attempting to automate the account parameters using Terraform and are adhering to the official parameters document from Snowflake.
We are experiencing an error message which is attached as a screenshot for parameters listed below.

1. "Invalid object parameter: TRANSACTION_ABORT_ON_ERROR" and
2. "SQL compilation error: invalid value ['true'] for parameter 'QUOTED_IDENTIFIERS_IGNORE_CASE'"

Do revert for any information. Ref Snowflake Support Ticket 00675051
Any assistance or guidance on this would be greatly appreciated, thank you.

Actual Behavior

Error: Invalid object parameter: TRANSACTION_ABORT_ON_ERROR
Error: 001008 (22023): SQL compilation error:

Note- Screenshot Attached

Steps to Reproduce

1. terraform apply

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

No response

[sfc-gh-jcieslak]

@ravisingh27 Hey 👋, the fix was merged and will be a part of the next release

[sfc-gh-dszmolka]

release 0.86.0 hit the shelves yesterday ; could you please test it and see if it fixes the issue for you ?

If it does, please mark this issue as close. Of course if there are further concerns, do let us know here. Thank you !

[dlouseiro]

@sfc-gh-dszmolka I'm experiencing this issue on version 0.92, for the following parameters:

• CORTEX_ENABLED_CROSS_REGION
• SAML_IDENTITY_PROVIDER
• UI_NOTIFICATIONS

[sfc-gh-asawicki]

Hey @dlouseiro. Thanks for reaching out to us.

Please submit a separate issue for these.

[dlouseiro]

Hey @dlouseiro. Thanks for reaching out to us.

Please submit a separate issue for these.

Will do!

[dlouseiro]

Hey @dlouseiro. Thanks for reaching out to us.
Please submit a separate issue for these.

Will do!

Done here @sfc-gh-asawicki

[sfc-gh-jmichalak]

As this was already fixed, and this thread seems inactive, I'm closing the issue. If you still have similar problems, please create a new issue. The referenced issue will be fixed while reworking the account_parameter resource.