Snowflake Parameters Getting Failed | Terraform | Error [Bug]:

[ravisingh27]

Terraform CLI Version

1.7.5

Terraform Provider Version

0.89.0

Terraform Configuration

We presently use terraform automation to apply snowflake parameters, and we do so for 13 parameters total. These parameters are passed in as Terraform variables (map). We tried adding the two arguments below to our code recently, however we were receiving the error below. A remedy for this would be beneficial.

TERRAFORM_VERSION "1.7.5"

Error:
╷
│ Error: Invalid object parameter: ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_IMAGE_REPOSITORY
│ 
│   with module.pre_snowflake_account_parameters["Account_Parameters-1"].snowflake_account_parameter.child_account_parameter,
│   on .terraform/modules/pre_snowflake_account_parameters/main.tf line 1, in resource "snowflake_account_parameter" "child_account_parameter":
│    1: resource "snowflake_account_parameter" "child_account_parameter" {
│ 
╵
╷
│ Error: Invalid object parameter: ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_SPCS_BLOCK_STORAGE
│ 
│   with module.pre_snowflake_account_parameters["Account_Parameters-2"].snowflake_account_parameter.child_account_parameter,
│   on .terraform/modules/pre_snowflake_account_parameters/main.tf line 1, in resource "snowflake_account_parameter" "child_account_parameter":
│    1: resource "snowflake_account_parameter" "child_account_parameter" {
│ 
╵
Cleaning up project directory and file based variables
00:00
ERROR: Job failed: command terminated with exit code 1

/** Variable Section **/
Account_Parameters-1 = {
key  = "ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_IMAGE_REPOSITORY",
    value = true,
    },
Account_Parameters-2 = {
    key  = "ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_SPCS_BLOCK_STORAGE",
    value = true,
    },
Account_Parameters-14 = {
      key  = "PERIODIC_DATA_REKEYING",
      value = true,
    },

Category

category:resource

Object type(s)

No response

Expected Behavior

ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_IMAGE_REPOSITORY = true
ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_SPCS_BLOCK_STORAGE = true

Actual Behavior

Error:
╷
│ Error: Invalid object parameter: ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_IMAGE_REPOSITORY
│
│ with module.pre_snowflake_account_parameters["Account_Parameters-1"].snowflake_account_parameter.child_account_parameter,
│ on .terraform/modules/pre_snowflake_account_parameters/main.tf line 1, in resource "snowflake_account_parameter" "child_account_parameter":
│ 1: resource "snowflake_account_parameter" "child_account_parameter" {
│
╵
╷
│ Error: Invalid object parameter: ENABLE_TRI_SECRET_AND_REKEY_OPT_OUT_FOR_SPCS_BLOCK_STORAGE
│
│ with module.pre_snowflake_account_parameters["Account_Parameters-2"].snowflake_account_parameter.child_account_parameter,
│ on .terraform/modules/pre_snowflake_account_parameters/main.tf line 1, in resource "snowflake_account_parameter" "child_account_parameter":
│ 1: resource "snowflake_account_parameter" "child_account_parameter" {
│
╵
Cleaning up project directory and file based variables
00:00
ERROR: Job failed: command terminated with exit code 1

Steps to Reproduce

sourcing the snowflake_account_parameters as a module.
mapping the key : value - as a terraform variable.
for_each = var.snowflake_account_parameters
key = each.value.key
value = each.value.value

terraform apply

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @ravisingh27. Thanks for reaching out to us.

These two parameters must have been added recently and we are currently not supporting them.

The change is relatively easy, though. I will squeeze it in with one of my other PRs and it should be available with the next release.

[sfc-gh-jcieslak]

Hey @ravisingh27 👋
Today, we released a new version v0.90.0 that contained a fix for your issue. Please, let us know if you're still experiencing this issue in the latest version (also mind there were small breaking changes documented here).

[ravisingh27]

Thanks, I'll check and close.

[sfc-gh-asawicki]

Hey @ravisingh27. Were you able to test the new version?

[ravisingh27]

Hey @sfc-gh-asawicki , Not yet but we'll be including this in next quarter.

[sfc-gh-asawicki]

I will close the issue then. Please create a new one if the added parameters won't work.