Dear All,
I upgraded my snowflake provider from 0.58.2 to 0.71.0. After running terraform apply, I get the following error
│ Error: Only one of Rename or Set can be set at once.
│
│ with snowflake_file_format.csv_file_format,
│ on tf_snowflake.tf line 88, in resource "snowflake_file_format" "csv_file_format":
│ 88: resource "snowflake_file_format" "csv_file_format" {
Here is code snippet,
resource "snowflake_file_format" "parquet_file_format" {
provider = snowflake.loader
name = "PARQUET_FORMAT"
database = snowflake_database.raw_db.name
schema = snowflake_schema.raw_stage.name
format_type = "PARQUET"
compression = "AUTO"
binary_as_text = false
}
resource "snowflake_file_format" "csv_file_format" {
provider = snowflake.loader
name = "CSV_FORMAT"
database = snowflake_database.raw_db.name
schema = snowflake_schema.raw_stage.name
format_type = "CSV"
field_delimiter = "#~^|"
skip_header = 1
null_if = ["NULL", "null"]
empty_field_as_null = true
record_delimiter = "\n"
field_optionally_enclosed_by = "\\042" # double quotes
trim_space = false
escape = "\\"
compression = "AUTO"
binary_format = "HEX"
escape_unenclosed_field = "\\"
encoding = "UTF8"
skip_byte_order_mark = true
replace_invalid_characters = false
error_on_column_count_mismatch = true
date_format = "AUTO"
time_format = "AUTO"
timestamp_format = "AUTO"
skip_blank_lines = false
}
Please advise