parse_header attribute cannot be set to true in snowflake_file_format resource

[AleksaC]

Provider Version

0.75.0

Terraform Version

1.4.6

Describe the bug

I keep getting the error

Error: ParseHeader and SkipHeader cannot be set simultaneously

even though I haven't set skip_header. I also tried setting it to 0 or even null but it still doesn't work.

Expected behavior

After glancing at the provider implementation I think that is the culprit is ResourceData.Get because it returns 0 even if the field is set to null or not set at all. Example usage:

terraform-provider-snowflake/pkg/resources/file_format.go

Line 355 in 01a774c

opts.CSVSkipHeader = sdk.Int(d.Get("skip_header").(int))

Code samples and commands

resource "snowflake_file_format" "csv" {
  name         = local.service_name
  database     = var.sf_db
  schema       = var.sf_schema
  format_type  = "CSV"
  compression  = "AUTO"
}

works

resource "snowflake_file_format" "csv" {
  name         = local.service_name
  database     = var.sf_db
  schema       = var.sf_schema
  format_type  = "CSV"
  compression  = "AUTO"
  parse_header = true
}

throws:

snowflake_file_format.csv: Creating...
╷
│ Error: ParseHeader and SkipHeader cannot be set simultaneously
│ 
│   with snowflake_file_format.csv,
│   on snowpipe.tf line 1, in resource "snowflake_file_format" "csv":
│    1: resource "snowflake_file_format" "csv" {
│ 
╵

[sfc-gh-asawicki]

Hey @AleksaC. Thanks for creating the issue.

You are right; it seems that this is a problem causing the issue you are experiencing. I will confirm that and apply the correction this week.