[Bug] snowflake_stage with file_format containing quoted values always shows as modified

[justenwalker]

Provider Version

0.55.1

Terraform Version

1.3.7

Describe the bug

The file_format parameter of a snowflake_stage will always be modified due to some escape character differences if the input value requires quoting.

Expected behavior

The plan should require no changes since the file_format value did not change.

Code samples and commands

Assuming you've defined a stage like this with a file_format containing quoted values:

 resource "snowflake_stage" "my_stage" {
  name                = "MY_STAGE"
  database            = "MY_DATABASE"
  schema              = "MY_SCHEMA"
  file_format         = "FORMAT_NAME = \"MY_DATABASE\".\"MY_SCHEMA\".\"MY_FILE_FORMAT\""
}

After the initially successful terraform apply, further terraform plans will always have modifications:

  # snowflake_stage.my_stage will be updated in-place
  ~ resource "snowflake_stage" "my_stage" {
      ~ file_format         = "FORMAT_NAME = \\\"MY_DATABASE\\\".\\\"MY_SCHEMA\\\".\\\"MY_FILE_FORMAT\\\"" -> "FORMAT_NAME = \"MY_DATABASE\".\"MY_SCHEMA\".\"MY_FILE_FORMAT\""
        id                  = "MY_DATABASE|MY_SCHEMA|MY_STAGE"
        name                = "MY_STAGE"
        # (6 unchanged attributes hidden)
    }

Additional context

It appears as though the input value is compared with a double-escaped value and so further plans want to remove the extra escaping.

[JohnMav]

Just noting that this issue persists even when using the latest fully_qualified_name in version 0.95.0

i.e.

resource "snowflake_stage" "my_stage" {
  name      = "MY_STAGE"
  file_format = "FORMAT_NAME = ${snowflake_file_format.my_format.fully_qualified_name}"
  database  = snowflake_database.my_database.name
  schema    = snowflake_schema.my_schema.name
}

Results in:

  # snowflake_stage.niko_order_notes will be updated in-place
  ~ resource "snowflake_stage" "my_stage" {
      ~ file_format          = "FORMAT_NAME = \\\"MY_DATABASE\\\".\\\"MY_SCHEMA\\\".\\\"MY_FILE_FORMAT\\\"" -> "FORMAT_NAME = \"MY_DATABASE\".\"MY_SCHEMA\".\"MY_FILE_FORMAT\""
        id                   = "MY_DATABASE|MY_SCHEMA|MY_STAGE"
        name                 = "MY_STAGE"
        # (10 unchanged attributes hidden)
    }

Any possible resolution for this?

[sfc-gh-asawicki]

Hey @JohnMav. We will address this issue with the stage redesign. For now, you can suppress this by using the ignore_changes lifecycle attribute.