[Bug]: Unable to import file format

[kharigardner]

Terraform CLI Version

1.9.0

Terraform Provider Version

0.92.0

Terraform Configuration

resource "snowflake_file_format" "parquet" {
    for_each =  toset(local.environments)

    name        = "S3_PARQUET"
    database    = "${each.key}_DATA_ADMINISTRATION"
    schema      = "INTEGRATIONS"
    format_type = "PARQUET"
}

Category

category:import

Object type(s)

No response

Expected Behavior

Import succeeds

Actual Behavior

Steps to Reproduce

terraform import 'snowflake_file_format.parquet["SBX"]' SBX_DATA_ADMINISTRATION.INTEGRATIONS.S3_PARQUET

How much impact is this issue causing?

Low

Logs

No response

Additional Information

No response

Would you like to implement a fix?

• [X] Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @kharigardner. I think that the resource ID is incorrect. Please follow https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/file_format#import, the pipe (|) is the correct separator for importing file formats.