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 !