1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. FileFormatXml
Viewing docs for Snowflake v2.19.0
published on Friday, Jul 31, 2026 by Pulumi
snowflake logo
Viewing docs for Snowflake v2.19.0
published on Friday, Jul 31, 2026 by Pulumi

    Caution: Preview Feature This feature is considered a preview feature in the provider, regardless of the state of the resource in Snowflake. We do not guarantee its stability. It will be reworked and marked as a stable feature in future releases. Breaking changes are expected, even without bumping the major version. To use this feature, add the relevant feature name to previewFeaturesEnabled field in the provider configuration. Please always refer to the Getting Help section in our Github repo to best determine how to get help for your questions.

    Note A file format cannot be dropped successfully if it has dependent external tables. Before dropping the resource, first drop the dependent external tables manually.

    Resource used to manage XML file formats. For more information, check file format documentation.

    Example Usage

    Note Instead of using fully_qualified_name, you can reference objects managed outside Terraform by constructing a correct ID, consult identifiers guide.

    import * as pulumi from "@pulumi/pulumi";
    import * as snowflake from "@pulumi/snowflake";
    
    //# Minimal
    const basic = new snowflake.FileFormatXml("basic", {
        database: "database_name",
        schema: "schema_name",
        name: "file_format_name",
    });
    //# Complete (with every optional set)
    const complete = new snowflake.FileFormatXml("complete", {
        database: "database_name",
        schema: "schema_name",
        name: "file_format_name",
        compression: "GZIP",
        preserveSpace: "true",
        stripOuterElement: "true",
        disableAutoConvert: "false",
        replaceInvalidCharacters: "false",
        skipByteOrderMark: "true",
        comment: "My XML file format",
    });
    
    import pulumi
    import pulumi_snowflake as snowflake
    
    ## Minimal
    basic = snowflake.FileFormatXml("basic",
        database="database_name",
        schema="schema_name",
        name="file_format_name")
    ## Complete (with every optional set)
    complete = snowflake.FileFormatXml("complete",
        database="database_name",
        schema="schema_name",
        name="file_format_name",
        compression="GZIP",
        preserve_space="true",
        strip_outer_element="true",
        disable_auto_convert="false",
        replace_invalid_characters="false",
        skip_byte_order_mark="true",
        comment="My XML file format")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-snowflake/sdk/v2/go/snowflake"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		// # Minimal
    		_, err := snowflake.NewFileFormatXml(ctx, "basic", &snowflake.FileFormatXmlArgs{
    			Database: pulumi.String("database_name"),
    			Schema:   pulumi.String("schema_name"),
    			Name:     pulumi.String("file_format_name"),
    		})
    		if err != nil {
    			return err
    		}
    		// # Complete (with every optional set)
    		_, err = snowflake.NewFileFormatXml(ctx, "complete", &snowflake.FileFormatXmlArgs{
    			Database:                 pulumi.String("database_name"),
    			Schema:                   pulumi.String("schema_name"),
    			Name:                     pulumi.String("file_format_name"),
    			Compression:              pulumi.String("GZIP"),
    			PreserveSpace:            pulumi.String("true"),
    			StripOuterElement:        pulumi.String("true"),
    			DisableAutoConvert:       pulumi.String("false"),
    			ReplaceInvalidCharacters: pulumi.String("false"),
    			SkipByteOrderMark:        pulumi.String("true"),
    			Comment:                  pulumi.String("My XML file format"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Snowflake = Pulumi.Snowflake;
    
    return await Deployment.RunAsync(() => 
    {
        //# Minimal
        var basic = new Snowflake.FileFormatXml("basic", new()
        {
            Database = "database_name",
            Schema = "schema_name",
            Name = "file_format_name",
        });
    
        //# Complete (with every optional set)
        var complete = new Snowflake.FileFormatXml("complete", new()
        {
            Database = "database_name",
            Schema = "schema_name",
            Name = "file_format_name",
            Compression = "GZIP",
            PreserveSpace = "true",
            StripOuterElement = "true",
            DisableAutoConvert = "false",
            ReplaceInvalidCharacters = "false",
            SkipByteOrderMark = "true",
            Comment = "My XML file format",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.snowflake.FileFormatXml;
    import com.pulumi.snowflake.FileFormatXmlArgs;
    import java.util.ArrayList;
    import java.util.Arrays;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            //# Minimal
            var basic = new FileFormatXml("basic", FileFormatXmlArgs.builder()
                .database("database_name")
                .schema("schema_name")
                .name("file_format_name")
                .build());
    
            //# Complete (with every optional set)
            var complete = new FileFormatXml("complete", FileFormatXmlArgs.builder()
                .database("database_name")
                .schema("schema_name")
                .name("file_format_name")
                .compression("GZIP")
                .preserveSpace("true")
                .stripOuterElement("true")
                .disableAutoConvert("false")
                .replaceInvalidCharacters("false")
                .skipByteOrderMark("true")
                .comment("My XML file format")
                .build());
    
        }
    }
    
    resources:
      ## Minimal
      basic:
        type: snowflake:FileFormatXml
        properties:
          database: database_name
          schema: schema_name
          name: file_format_name
      ## Complete (with every optional set)
      complete:
        type: snowflake:FileFormatXml
        properties:
          database: database_name
          schema: schema_name
          name: file_format_name
          compression: GZIP
          preserveSpace: 'true'
          stripOuterElement: 'true'
          disableAutoConvert: 'false'
          replaceInvalidCharacters: 'false'
          skipByteOrderMark: 'true'
          comment: My XML file format
    
    pulumi {
      required_providers {
        snowflake = {
          source = "pulumi/snowflake"
        }
      }
    }
    
    ## Minimal
    resource "snowflake_fileformatxml" "basic" {
      database = "database_name"
      schema   = "schema_name"
      name     = "file_format_name"
    }
    ## Complete (with every optional set)
    resource "snowflake_fileformatxml" "complete" {
      database                   = "database_name"
      schema                     = "schema_name"
      name                       = "file_format_name"
      compression                = "GZIP"
      preserve_space             = "true"
      strip_outer_element        = "true"
      disable_auto_convert       = "false"
      replace_invalid_characters = "false"
      skip_byte_order_mark       = "true"
      comment                    = "My XML file format"
    }
    

    Note If a field has a default value, it is shown next to the type in the schema.

    Create FileFormatXml Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new FileFormatXml(name: string, args: FileFormatXmlArgs, opts?: CustomResourceOptions);
    @overload
    def FileFormatXml(resource_name: str,
                      args: FileFormatXmlArgs,
                      opts: Optional[ResourceOptions] = None)
    
    @overload
    def FileFormatXml(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      database: Optional[str] = None,
                      schema: Optional[str] = None,
                      comment: Optional[str] = None,
                      compression: Optional[str] = None,
                      disable_auto_convert: Optional[str] = None,
                      ignore_utf8_errors: Optional[str] = None,
                      name: Optional[str] = None,
                      preserve_space: Optional[str] = None,
                      replace_invalid_characters: Optional[str] = None,
                      skip_byte_order_mark: Optional[str] = None,
                      strip_outer_element: Optional[str] = None)
    func NewFileFormatXml(ctx *Context, name string, args FileFormatXmlArgs, opts ...ResourceOption) (*FileFormatXml, error)
    public FileFormatXml(string name, FileFormatXmlArgs args, CustomResourceOptions? opts = null)
    public FileFormatXml(String name, FileFormatXmlArgs args)
    public FileFormatXml(String name, FileFormatXmlArgs args, CustomResourceOptions options)
    
    type: snowflake:FileFormatXml
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    
    resource "snowflake_file_format_xml" "name" {
        # resource properties
    }

    Parameters

    name string
    The unique name of the resource.
    args FileFormatXmlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args FileFormatXmlArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args FileFormatXmlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args FileFormatXmlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args FileFormatXmlArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var fileFormatXmlResource = new Snowflake.FileFormatXml("fileFormatXmlResource", new()
    {
        Database = "string",
        Schema = "string",
        Comment = "string",
        Compression = "string",
        DisableAutoConvert = "string",
        IgnoreUtf8Errors = "string",
        Name = "string",
        PreserveSpace = "string",
        ReplaceInvalidCharacters = "string",
        SkipByteOrderMark = "string",
        StripOuterElement = "string",
    });
    
    example, err := snowflake.NewFileFormatXml(ctx, "fileFormatXmlResource", &snowflake.FileFormatXmlArgs{
    	Database:                 pulumi.String("string"),
    	Schema:                   pulumi.String("string"),
    	Comment:                  pulumi.String("string"),
    	Compression:              pulumi.String("string"),
    	DisableAutoConvert:       pulumi.String("string"),
    	IgnoreUtf8Errors:         pulumi.String("string"),
    	Name:                     pulumi.String("string"),
    	PreserveSpace:            pulumi.String("string"),
    	ReplaceInvalidCharacters: pulumi.String("string"),
    	SkipByteOrderMark:        pulumi.String("string"),
    	StripOuterElement:        pulumi.String("string"),
    })
    
    resource "snowflake_file_format_xml" "fileFormatXmlResource" {
      lifecycle {
        create_before_destroy = true
      }
      database                   = "string"
      schema                     = "string"
      comment                    = "string"
      compression                = "string"
      disable_auto_convert       = "string"
      ignore_utf8_errors         = "string"
      name                       = "string"
      preserve_space             = "string"
      replace_invalid_characters = "string"
      skip_byte_order_mark       = "string"
      strip_outer_element        = "string"
    }
    
    var fileFormatXmlResource = new FileFormatXml("fileFormatXmlResource", FileFormatXmlArgs.builder()
        .database("string")
        .schema("string")
        .comment("string")
        .compression("string")
        .disableAutoConvert("string")
        .ignoreUtf8Errors("string")
        .name("string")
        .preserveSpace("string")
        .replaceInvalidCharacters("string")
        .skipByteOrderMark("string")
        .stripOuterElement("string")
        .build());
    
    file_format_xml_resource = snowflake.FileFormatXml("fileFormatXmlResource",
        database="string",
        schema="string",
        comment="string",
        compression="string",
        disable_auto_convert="string",
        ignore_utf8_errors="string",
        name="string",
        preserve_space="string",
        replace_invalid_characters="string",
        skip_byte_order_mark="string",
        strip_outer_element="string")
    
    const fileFormatXmlResource = new snowflake.FileFormatXml("fileFormatXmlResource", {
        database: "string",
        schema: "string",
        comment: "string",
        compression: "string",
        disableAutoConvert: "string",
        ignoreUtf8Errors: "string",
        name: "string",
        preserveSpace: "string",
        replaceInvalidCharacters: "string",
        skipByteOrderMark: "string",
        stripOuterElement: "string",
    });
    
    type: snowflake:FileFormatXml
    properties:
        comment: string
        compression: string
        database: string
        disableAutoConvert: string
        ignoreUtf8Errors: string
        name: string
        preserveSpace: string
        replaceInvalidCharacters: string
        schema: string
        skipByteOrderMark: string
        stripOuterElement: string
    

    FileFormatXml Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The FileFormatXml resource accepts the following input properties:

    Database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    DisableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IgnoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PreserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ReplaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    SkipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    StripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    DisableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IgnoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PreserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ReplaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    SkipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    StripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    disable_auto_convert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ignore_utf8_errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserve_space string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replace_invalid_characters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    skip_byte_order_mark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    strip_outer_element string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    database String
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    disableAutoConvert String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ignoreUtf8Errors String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    skipByteOrderMark String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    disableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ignoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    skipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    database str
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema str
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment str
    Specifies a comment for the file format.
    compression str
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    disable_auto_convert str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ignore_utf8_errors str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name str
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserve_space str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replace_invalid_characters str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    skip_byte_order_mark str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    strip_outer_element str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    database String
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    disableAutoConvert String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ignoreUtf8Errors String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    skipByteOrderMark String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the FileFormatXml resource produces the following output properties:

    DescribeOutputs List<FileFormatXmlDescribeOutput>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    ShowOutputs List<FileFormatXmlShowOutput>
    Outputs the result of SHOW FILE FORMATS for this file format.
    Type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    DescribeOutputs []FileFormatXmlDescribeOutput
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Id string
    The provider-assigned unique ID for this managed resource.
    ShowOutputs []FileFormatXmlShowOutput
    Outputs the result of SHOW FILE FORMATS for this file format.
    Type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    describe_outputs list(object)
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    id string
    The provider-assigned unique ID for this managed resource.
    show_outputs list(object)
    Outputs the result of SHOW FILE FORMATS for this file format.
    type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    describeOutputs List<FileFormatXmlDescribeOutput>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    showOutputs List<FileFormatXmlShowOutput>
    Outputs the result of SHOW FILE FORMATS for this file format.
    type String
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    describeOutputs FileFormatXmlDescribeOutput[]
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    id string
    The provider-assigned unique ID for this managed resource.
    showOutputs FileFormatXmlShowOutput[]
    Outputs the result of SHOW FILE FORMATS for this file format.
    type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    describe_outputs Sequence[FileFormatXmlDescribeOutput]
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    id str
    The provider-assigned unique ID for this managed resource.
    show_outputs Sequence[FileFormatXmlShowOutput]
    Outputs the result of SHOW FILE FORMATS for this file format.
    type str
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    id String
    The provider-assigned unique ID for this managed resource.
    showOutputs List<Property Map>
    Outputs the result of SHOW FILE FORMATS for this file format.
    type String
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.

    Look up Existing FileFormatXml Resource

    Get an existing FileFormatXml resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: FileFormatXmlState, opts?: CustomResourceOptions): FileFormatXml
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            comment: Optional[str] = None,
            compression: Optional[str] = None,
            database: Optional[str] = None,
            describe_outputs: Optional[Sequence[FileFormatXmlDescribeOutputArgs]] = None,
            disable_auto_convert: Optional[str] = None,
            fully_qualified_name: Optional[str] = None,
            ignore_utf8_errors: Optional[str] = None,
            name: Optional[str] = None,
            preserve_space: Optional[str] = None,
            replace_invalid_characters: Optional[str] = None,
            schema: Optional[str] = None,
            show_outputs: Optional[Sequence[FileFormatXmlShowOutputArgs]] = None,
            skip_byte_order_mark: Optional[str] = None,
            strip_outer_element: Optional[str] = None,
            type: Optional[str] = None) -> FileFormatXml
    func GetFileFormatXml(ctx *Context, name string, id IDInput, state *FileFormatXmlState, opts ...ResourceOption) (*FileFormatXml, error)
    public static FileFormatXml Get(string name, Input<string> id, FileFormatXmlState? state, CustomResourceOptions? opts = null)
    public static FileFormatXml get(String name, Output<String> id, FileFormatXmlState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:FileFormatXml    get:      id: ${id}
    import {
      to = snowflake_file_format_xml.example
      id = "${id}"
    }
    
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    Database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs List<FileFormatXmlDescribeOutput>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    DisableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IgnoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PreserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ReplaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowOutputs List<FileFormatXmlShowOutput>
    Outputs the result of SHOW FILE FORMATS for this file format.
    SkipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    StripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    Database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs []FileFormatXmlDescribeOutputArgs
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    DisableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IgnoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PreserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    ReplaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowOutputs []FileFormatXmlShowOutputArgs
    Outputs the result of SHOW FILE FORMATS for this file format.
    SkipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    StripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs list(object)
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    disable_auto_convert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    ignore_utf8_errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserve_space string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replace_invalid_characters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_outputs list(object)
    Outputs the result of SHOW FILE FORMATS for this file format.
    skip_byte_order_mark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    strip_outer_element string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    database String
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<FileFormatXmlDescribeOutput>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    disableAutoConvert String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    schema String
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs List<FileFormatXmlShowOutput>
    Outputs the result of SHOW FILE FORMATS for this file format.
    skipByteOrderMark String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    type String
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    database string
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs FileFormatXmlDescribeOutput[]
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    disableAutoConvert string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    schema string
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs FileFormatXmlShowOutput[]
    Outputs the result of SHOW FILE FORMATS for this file format.
    skipByteOrderMark string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement string
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    type string
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    comment str
    Specifies a comment for the file format.
    compression str
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    database str
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs Sequence[FileFormatXmlDescribeOutputArgs]
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    disable_auto_convert str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    ignore_utf8_errors str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name str
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserve_space str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replace_invalid_characters str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    schema str
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_outputs Sequence[FileFormatXmlShowOutputArgs]
    Outputs the result of SHOW FILE FORMATS for this file format.
    skip_byte_order_mark str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    strip_outer_element str
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    type str
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the compression format. Valid values: AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE.
    database String
    The database in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE FILE FORMAT for this file format.
    disableAutoConvert String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    preserveSpace String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    replaceInvalidCharacters String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    schema String
    The schema in which to create the file format. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs List<Property Map>
    Outputs the result of SHOW FILE FORMATS for this file format.
    skipByteOrderMark String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    stripOuterElement String
    (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    type String
    Specifies the type of the file format. This field is used to detect when the file format type was changed outside of Terraform and to recreate the resource when that happens.

    Supporting Types

    FileFormatXmlDescribeOutput, FileFormatXmlDescribeOutputArgs

    FileFormatXmlShowOutput, FileFormatXmlShowOutputArgs

    Comment string
    CreatedOn string
    DatabaseName string
    FormatOptions string
    Name string
    Owner string
    OwnerRoleType string
    SchemaName string
    Type string
    Comment string
    CreatedOn string
    DatabaseName string
    FormatOptions string
    Name string
    Owner string
    OwnerRoleType string
    SchemaName string
    Type string
    comment string
    created_on string
    database_name string
    format_options string
    name string
    owner string
    owner_role_type string
    schema_name string
    type string
    comment String
    createdOn String
    databaseName String
    formatOptions String
    name String
    owner String
    ownerRoleType String
    schemaName String
    type String
    comment string
    createdOn string
    databaseName string
    formatOptions string
    name string
    owner string
    ownerRoleType string
    schemaName string
    type string
    comment String
    createdOn String
    databaseName String
    formatOptions String
    name String
    owner String
    ownerRoleType String
    schemaName String
    type String

    Import

    $ pulumi import snowflake:index/fileFormatXml:FileFormatXml example '"<database_name>"."<schema_name>"."<file_format_name>"'
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Viewing docs for Snowflake v2.19.0
    published on Friday, Jul 31, 2026 by Pulumi

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial