published on Friday, Jul 31, 2026 by Pulumi
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
previewFeaturesEnabledfield 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. - Disable
Auto stringConvert - (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
Utf8Errors 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 stringCharacters - (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 stringOrder Mark - (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 stringElement - (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 stringConvert - (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
Utf8Errors 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 stringCharacters - (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 stringOrder Mark - (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 stringElement - (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_ stringconvert - (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_ stringerrors - (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_ stringcharacters - (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_ stringorder_ mark - (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_ stringelement - (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 StringConvert - (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
Utf8Errors 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 StringCharacters - (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 StringOrder Mark - (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 StringElement - (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 stringConvert - (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
Utf8Errors 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 stringCharacters - (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 stringOrder Mark - (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 stringElement - (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_ strconvert - (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_ strerrors - (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_ strcharacters - (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_ strorder_ mark - (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_ strelement - (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 StringConvert - (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
Utf8Errors 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 StringCharacters - (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 StringOrder Mark - (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 StringElement - (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:
- Describe
Outputs List<FileFormat Xml Describe Output> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - Fully
Qualified stringName - 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<FileFormat Xml Show Output> - Outputs the result of
SHOW FILE FORMATSfor 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 []FileFormat Xml Describe Output - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - Fully
Qualified stringName - 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 []FileFormat Xml Show Output - Outputs the result of
SHOW FILE FORMATSfor 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 FORMATfor this file format. - fully_
qualified_ stringname - 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 FORMATSfor 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<FileFormat Xml Describe Output> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - fully
Qualified StringName - 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<FileFormat Xml Show Output> - Outputs the result of
SHOW FILE FORMATSfor 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 FileFormat Xml Describe Output[] - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - fully
Qualified stringName - 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 FileFormat Xml Show Output[] - Outputs the result of
SHOW FILE FORMATSfor 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[FileFormat Xml Describe Output] - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - fully_
qualified_ strname - 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[FileFormat Xml Show Output] - Outputs the result of
SHOW FILE FORMATSfor 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.
- describe
Outputs List<Property Map> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - fully
Qualified StringName - 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<Property Map> - Outputs the result of
SHOW FILE FORMATSfor 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) -> FileFormatXmlfunc 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.
- 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<FileFormat Xml Describe Output> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - Disable
Auto stringConvert - (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 stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Ignore
Utf8Errors 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 stringCharacters - (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<FileFormat Xml Show Output> - Outputs the result of
SHOW FILE FORMATSfor this file format. - Skip
Byte stringOrder Mark - (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 stringElement - (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 []FileFormat Xml Describe Output Args - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - Disable
Auto stringConvert - (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 stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Ignore
Utf8Errors 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 stringCharacters - (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 []FileFormat Xml Show Output Args - Outputs the result of
SHOW FILE FORMATSfor this file format. - Skip
Byte stringOrder Mark - (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 stringElement - (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 FORMATfor this file format. - disable_
auto_ stringconvert - (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_ stringname - Fully qualified name of the resource. For more information, see object name resolution.
- ignore_
utf8_ stringerrors - (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_ stringcharacters - (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 FORMATSfor this file format. - skip_
byte_ stringorder_ mark - (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_ stringelement - (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<FileFormat Xml Describe Output> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - disable
Auto StringConvert - (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 StringName - Fully qualified name of the resource. For more information, see object name resolution.
- ignore
Utf8Errors 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 StringCharacters - (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<FileFormat Xml Show Output> - Outputs the result of
SHOW FILE FORMATSfor this file format. - skip
Byte StringOrder Mark - (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 StringElement - (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 FileFormat Xml Describe Output[] - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - disable
Auto stringConvert - (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 stringName - Fully qualified name of the resource. For more information, see object name resolution.
- ignore
Utf8Errors 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 stringCharacters - (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 FileFormat Xml Show Output[] - Outputs the result of
SHOW FILE FORMATSfor this file format. - skip
Byte stringOrder Mark - (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 stringElement - (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[FileFormat Xml Describe Output Args] - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - disable_
auto_ strconvert - (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_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- ignore_
utf8_ strerrors - (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_ strcharacters - (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[FileFormat Xml Show Output Args] - Outputs the result of
SHOW FILE FORMATSfor this file format. - skip_
byte_ strorder_ mark - (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_ strelement - (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:
|,.,". - describe
Outputs List<Property Map> - Outputs the result of
DESCRIBE FILE FORMATfor this file format. - disable
Auto StringConvert - (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 StringName - Fully qualified name of the resource. For more information, see object name resolution.
- ignore
Utf8Errors 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 StringCharacters - (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<Property Map> - Outputs the result of
SHOW FILE FORMATSfor this file format. - skip
Byte StringOrder Mark - (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 StringElement - (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
- Compression string
- Disable
Auto boolConvert - Id string
- Ignore
Utf8Errors bool - Preserve
Space bool - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Outer boolElement - Type string
- Compression string
- Disable
Auto boolConvert - Id string
- Ignore
Utf8Errors bool - Preserve
Space bool - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Outer boolElement - Type string
- compression string
- disable_
auto_ boolconvert - id string
- ignore_
utf8_ boolerrors - preserve_
space bool - replace_
invalid_ boolcharacters - skip_
byte_ boolorder_ mark - strip_
outer_ boolelement - type string
- compression String
- disable
Auto BooleanConvert - id String
- ignore
Utf8Errors Boolean - preserve
Space Boolean - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Outer BooleanElement - type String
- compression string
- disable
Auto booleanConvert - id string
- ignore
Utf8Errors boolean - preserve
Space boolean - replace
Invalid booleanCharacters - skip
Byte booleanOrder Mark - strip
Outer booleanElement - type string
- compression str
- disable_
auto_ boolconvert - id str
- ignore_
utf8_ boolerrors - preserve_
space bool - replace_
invalid_ boolcharacters - skip_
byte_ boolorder_ mark - strip_
outer_ boolelement - type str
- compression String
- disable
Auto BooleanConvert - id String
- ignore
Utf8Errors Boolean - preserve
Space Boolean - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Outer BooleanElement - type String
FileFormatXmlShowOutput, FileFormatXmlShowOutputArgs
- Comment string
- Created
On string - Database
Name string - Format
Options string - Name string
- Owner string
- Owner
Role stringType - Schema
Name string - Type string
- Comment string
- Created
On string - Database
Name string - Format
Options string - Name string
- Owner string
- Owner
Role stringType - Schema
Name string - Type string
- comment string
- created_
on string - database_
name string - format_
options string - name string
- owner string
- owner_
role_ stringtype - schema_
name string - type string
- comment String
- created
On String - database
Name String - format
Options String - name String
- owner String
- owner
Role StringType - schema
Name String - type String
- comment string
- created
On string - database
Name string - format
Options string - name string
- owner string
- owner
Role stringType - schema
Name string - type string
- comment str
- created_
on str - database_
name str - format_
options str - name str
- owner str
- owner_
role_ strtype - schema_
name str - type str
- comment String
- created
On String - database
Name String - format
Options String - name String
- owner String
- owner
Role StringType - schema
Name 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
snowflakeTerraform Provider.
published on Friday, Jul 31, 2026 by Pulumi