CSV snowflake_file_format errors and doesn't set system default when omitting optional values

[aclarkot]

Provider Version

v0.58.0

Terraform Version

v1.3.4

Describe the bug

When you omit any of the optional values for a CSV file format terraform errors, for example:

│ Error: error updating file format record delimiter on MY_DATABASE|RAW|CSV_FORMAT err = 001008 (22023): SQL compilation error:
│ invalid value [''] for parameter 'RECORD_DELIMITER'

You end up having to explicitly define every optional value even when you are using the system defaults.

If you create the file format directly in Snowflake you don't need to define all the optional values, they are defaulted.

This seems to happen when any of the optional values are omitted: binary_format, encoding, escape, escape_unenclosed_field, field_optionally_enclosed_by, field_delimiter, skip_header, compression,

Expected behavior

There should be no error and the system default for the omitted value should be used E.g. record_delimiter = "\n".

resource "snowflake_file_format" "CSV" {
  name                         = CSV_FORMAT
  database                     = MY_DATABASE
  schema                       = RAW
  format_type                  = CSV

  binary_format                = "HEX"
  encoding                     = "UTF8"
  escape                       = "NONE"
  escape_unenclosed_field      = "\\"
  field_optionally_enclosed_by = "\""
  field_delimiter              = ","
  skip_header                  = 1
  compression                  = "AUTO"
}

Please add code examples and commands that were run to cause the problem.

Additional context

Add any other context about the problem here.