Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

snowflake_file_format defaults are not the same as running CREATE FILE FORMAT #1760

Open
philippe-7shifts opened this issue Apr 27, 2023 · 0 comments
Labels
bug Used to mark issues with provider's incorrect behavior category:resource resource:file_format Issue connected to the snowflake_file_format resource

Comments

@philippe-7shifts
Copy link

philippe-7shifts commented Apr 27, 2023

Provider Version

0.61.0

Terraform Version

1.4.2

Describe the bug

When creating a file_format resource using Terraform, the following properties are different than when using CREATE FILE FORMAT

  • NULL_IF
  • ERROR_ON_COLUMN_COUNT_MISMATCH
  • EMPTY_FIELD_AS_NULL
  • SKIP_BYTE_ORDER_MARK

Expected behavior

Optional values that weren't set should be the same as if using CREATE FILE FORMAT

Code samples and commands

resource "snowflake_file_format" "csv" {  
  database = "<database name>"
  schema = "PUBLIC"
  name = "<name>"  
  format_type = "CSV"
  escape = "\\"
  field_optionally_enclosed_by = "\""
}
@philippe-7shifts philippe-7shifts added the bug Used to mark issues with provider's incorrect behavior label Apr 27, 2023
@sfc-gh-jcieslak sfc-gh-jcieslak added category:resource resource:file_format Issue connected to the snowflake_file_format resource labels May 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Used to mark issues with provider's incorrect behavior category:resource resource:file_format Issue connected to the snowflake_file_format resource
Projects
None yet
Development

No branches or pull requests

2 participants