Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Snowflake Provider
  3. API Docs
  4. FileFormat
Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi
pulumi/pulumi-snowflake

snowflake.FileFormat

Explore with Pulumi AI

snowflake logo
Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi
pulumi/pulumi-snowflake

    Import

    format is database name | schema name | file format name

    $ pulumi import snowflake:index/fileFormat:FileFormat example 'dbName|schemaName|fileFormatName'

    Create FileFormat Resource

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

    Constructor syntax

    new FileFormat(name: string, args: FileFormatArgs, opts?: CustomResourceOptions);
    @overload
def FileFormat(resource_name: str,
               args: FileFormatArgs,
               opts: Optional[ResourceOptions] = None)

@overload
def FileFormat(resource_name: str,
               opts: Optional[ResourceOptions] = None,
               database: Optional[str] = None,
               schema: Optional[str] = None,
               format_type: Optional[str] = None,
               empty_field_as_null: Optional[bool] = None,
               name: Optional[str] = None,
               comment: Optional[str] = None,
               date_format: Optional[str] = None,
               disable_auto_convert: Optional[bool] = None,
               disable_snowflake_data: Optional[bool] = None,
               allow_duplicate: Optional[bool] = None,
               enable_octal: Optional[bool] = None,
               encoding: Optional[str] = None,
               error_on_column_count_mismatch: Optional[bool] = None,
               escape: Optional[str] = None,
               escape_unenclosed_field: Optional[str] = None,
               field_delimiter: Optional[str] = None,
               field_optionally_enclosed_by: Optional[str] = None,
               file_extension: Optional[str] = None,
               binary_format: Optional[str] = None,
               compression: Optional[str] = None,
               null_ifs: Optional[Sequence[str]] = None,
               ignore_utf8_errors: Optional[bool] = None,
               parse_header: Optional[bool] = None,
               preserve_space: Optional[bool] = None,
               record_delimiter: Optional[str] = None,
               replace_invalid_characters: Optional[bool] = None,
               binary_as_text: Optional[bool] = None,
               skip_blank_lines: Optional[bool] = None,
               skip_byte_order_mark: Optional[bool] = None,
               skip_header: Optional[int] = None,
               strip_null_values: Optional[bool] = None,
               strip_outer_array: Optional[bool] = None,
               strip_outer_element: Optional[bool] = None,
               time_format: Optional[str] = None,
               timestamp_format: Optional[str] = None,
               trim_space: Optional[bool] = None)
    func NewFileFormat(ctx *Context, name string, args FileFormatArgs, opts ...ResourceOption) (*FileFormat, error)
    public FileFormat(string name, FileFormatArgs args, CustomResourceOptions? opts = null)
    public FileFormat(String name, FileFormatArgs args)
public FileFormat(String name, FileFormatArgs args, CustomResourceOptions options)

    type: snowflake:FileFormat
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args FileFormatArgs
    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 FileFormatArgs
    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 FileFormatArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args FileFormatArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args FileFormatArgs
    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 fileFormatResource = new Snowflake.FileFormat("fileFormatResource", new()
{
    Database = "string",
    Schema = "string",
    FormatType = "string",
    EmptyFieldAsNull = false,
    Name = "string",
    Comment = "string",
    DateFormat = "string",
    DisableAutoConvert = false,
    DisableSnowflakeData = false,
    AllowDuplicate = false,
    EnableOctal = false,
    Encoding = "string",
    ErrorOnColumnCountMismatch = false,
    Escape = "string",
    EscapeUnenclosedField = "string",
    FieldDelimiter = "string",
    FieldOptionallyEnclosedBy = "string",
    FileExtension = "string",
    BinaryFormat = "string",
    Compression = "string",
    NullIfs = new[]
    {
        "string",
    },
    IgnoreUtf8Errors = false,
    ParseHeader = false,
    PreserveSpace = false,
    RecordDelimiter = "string",
    ReplaceInvalidCharacters = false,
    BinaryAsText = false,
    SkipBlankLines = false,
    SkipByteOrderMark = false,
    SkipHeader = 0,
    StripNullValues = false,
    StripOuterArray = false,
    StripOuterElement = false,
    TimeFormat = "string",
    TimestampFormat = "string",
    TrimSpace = false,
});

    example, err := snowflake.NewFileFormat(ctx, "fileFormatResource", &snowflake.FileFormatArgs{
	Database:                   pulumi.String("string"),
	Schema:                     pulumi.String("string"),
	FormatType:                 pulumi.String("string"),
	EmptyFieldAsNull:           pulumi.Bool(false),
	Name:                       pulumi.String("string"),
	Comment:                    pulumi.String("string"),
	DateFormat:                 pulumi.String("string"),
	DisableAutoConvert:         pulumi.Bool(false),
	DisableSnowflakeData:       pulumi.Bool(false),
	AllowDuplicate:             pulumi.Bool(false),
	EnableOctal:                pulumi.Bool(false),
	Encoding:                   pulumi.String("string"),
	ErrorOnColumnCountMismatch: pulumi.Bool(false),
	Escape:                     pulumi.String("string"),
	EscapeUnenclosedField:      pulumi.String("string"),
	FieldDelimiter:             pulumi.String("string"),
	FieldOptionallyEnclosedBy:  pulumi.String("string"),
	FileExtension:              pulumi.String("string"),
	BinaryFormat:               pulumi.String("string"),
	Compression:                pulumi.String("string"),
	NullIfs: pulumi.StringArray{
		pulumi.String("string"),
	},
	IgnoreUtf8Errors:         pulumi.Bool(false),
	ParseHeader:              pulumi.Bool(false),
	PreserveSpace:            pulumi.Bool(false),
	RecordDelimiter:          pulumi.String("string"),
	ReplaceInvalidCharacters: pulumi.Bool(false),
	BinaryAsText:             pulumi.Bool(false),
	SkipBlankLines:           pulumi.Bool(false),
	SkipByteOrderMark:        pulumi.Bool(false),
	SkipHeader:               pulumi.Int(0),
	StripNullValues:          pulumi.Bool(false),
	StripOuterArray:          pulumi.Bool(false),
	StripOuterElement:        pulumi.Bool(false),
	TimeFormat:               pulumi.String("string"),
	TimestampFormat:          pulumi.String("string"),
	TrimSpace:                pulumi.Bool(false),
})

    var fileFormatResource = new FileFormat("fileFormatResource", FileFormatArgs.builder()
    .database("string")
    .schema("string")
    .formatType("string")
    .emptyFieldAsNull(false)
    .name("string")
    .comment("string")
    .dateFormat("string")
    .disableAutoConvert(false)
    .disableSnowflakeData(false)
    .allowDuplicate(false)
    .enableOctal(false)
    .encoding("string")
    .errorOnColumnCountMismatch(false)
    .escape("string")
    .escapeUnenclosedField("string")
    .fieldDelimiter("string")
    .fieldOptionallyEnclosedBy("string")
    .fileExtension("string")
    .binaryFormat("string")
    .compression("string")
    .nullIfs("string")
    .ignoreUtf8Errors(false)
    .parseHeader(false)
    .preserveSpace(false)
    .recordDelimiter("string")
    .replaceInvalidCharacters(false)
    .binaryAsText(false)
    .skipBlankLines(false)
    .skipByteOrderMark(false)
    .skipHeader(0)
    .stripNullValues(false)
    .stripOuterArray(false)
    .stripOuterElement(false)
    .timeFormat("string")
    .timestampFormat("string")
    .trimSpace(false)
    .build());

    file_format_resource = snowflake.FileFormat("fileFormatResource",
    database="string",
    schema="string",
    format_type="string",
    empty_field_as_null=False,
    name="string",
    comment="string",
    date_format="string",
    disable_auto_convert=False,
    disable_snowflake_data=False,
    allow_duplicate=False,
    enable_octal=False,
    encoding="string",
    error_on_column_count_mismatch=False,
    escape="string",
    escape_unenclosed_field="string",
    field_delimiter="string",
    field_optionally_enclosed_by="string",
    file_extension="string",
    binary_format="string",
    compression="string",
    null_ifs=["string"],
    ignore_utf8_errors=False,
    parse_header=False,
    preserve_space=False,
    record_delimiter="string",
    replace_invalid_characters=False,
    binary_as_text=False,
    skip_blank_lines=False,
    skip_byte_order_mark=False,
    skip_header=0,
    strip_null_values=False,
    strip_outer_array=False,
    strip_outer_element=False,
    time_format="string",
    timestamp_format="string",
    trim_space=False)

    const fileFormatResource = new snowflake.FileFormat("fileFormatResource", {
    database: "string",
    schema: "string",
    formatType: "string",
    emptyFieldAsNull: false,
    name: "string",
    comment: "string",
    dateFormat: "string",
    disableAutoConvert: false,
    disableSnowflakeData: false,
    allowDuplicate: false,
    enableOctal: false,
    encoding: "string",
    errorOnColumnCountMismatch: false,
    escape: "string",
    escapeUnenclosedField: "string",
    fieldDelimiter: "string",
    fieldOptionallyEnclosedBy: "string",
    fileExtension: "string",
    binaryFormat: "string",
    compression: "string",
    nullIfs: ["string"],
    ignoreUtf8Errors: false,
    parseHeader: false,
    preserveSpace: false,
    recordDelimiter: "string",
    replaceInvalidCharacters: false,
    binaryAsText: false,
    skipBlankLines: false,
    skipByteOrderMark: false,
    skipHeader: 0,
    stripNullValues: false,
    stripOuterArray: false,
    stripOuterElement: false,
    timeFormat: "string",
    timestampFormat: "string",
    trimSpace: false,
});

    type: snowflake:FileFormat
properties:
    allowDuplicate: false
    binaryAsText: false
    binaryFormat: string
    comment: string
    compression: string
    database: string
    dateFormat: string
    disableAutoConvert: false
    disableSnowflakeData: false
    emptyFieldAsNull: false
    enableOctal: false
    encoding: string
    errorOnColumnCountMismatch: false
    escape: string
    escapeUnenclosedField: string
    fieldDelimiter: string
    fieldOptionallyEnclosedBy: string
    fileExtension: string
    formatType: string
    ignoreUtf8Errors: false
    name: string
    nullIfs:
        - string
    parseHeader: false
    preserveSpace: false
    recordDelimiter: string
    replaceInvalidCharacters: false
    schema: string
    skipBlankLines: false
    skipByteOrderMark: false
    skipHeader: 0
    stripNullValues: false
    stripOuterArray: false
    stripOuterElement: false
    timeFormat: string
    timestampFormat: string
    trimSpace: false

    FileFormat 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 FileFormat resource accepts the following input properties:

    Database string
    The database in which to create the file format.
    FormatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    Schema string
    The schema in which to create the file format.
    AllowDuplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    BinaryAsText bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    BinaryFormat string
    Defines the encoding format for binary input or output.
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the current compression algorithm for the data file.
    DateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    DisableAutoConvert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    DisableSnowflakeData bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    EmptyFieldAsNull bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    EnableOctal bool
    Boolean that enables parsing of octal numbers.
    Encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    ErrorOnColumnCountMismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    Escape string
    Single character string used as the escape character for field values.
    EscapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    FieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    FieldOptionallyEnclosedBy string
    Character used to enclose strings.
    FileExtension string
    Specifies the extension for files unloaded to a stage.
    IgnoreUtf8Errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    NullIfs List<string>
    String used to convert to and from SQL NULL.
    ParseHeader bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    PreserveSpace bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    RecordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    ReplaceInvalidCharacters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    SkipBlankLines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    SkipByteOrderMark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    SkipHeader int
    Number of lines at the start of the file to skip.
    StripNullValues bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    StripOuterArray bool
    Boolean that instructs the JSON parser to remove outer brackets.
    StripOuterElement bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    TimeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    TimestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    TrimSpace bool
    Boolean that specifies whether to remove white space from fields.
    Database string
    The database in which to create the file format.
    FormatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    Schema string
    The schema in which to create the file format.
    AllowDuplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    BinaryAsText bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    BinaryFormat string
    Defines the encoding format for binary input or output.
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the current compression algorithm for the data file.
    DateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    DisableAutoConvert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    DisableSnowflakeData bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    EmptyFieldAsNull bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    EnableOctal bool
    Boolean that enables parsing of octal numbers.
    Encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    ErrorOnColumnCountMismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    Escape string
    Single character string used as the escape character for field values.
    EscapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    FieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    FieldOptionallyEnclosedBy string
    Character used to enclose strings.
    FileExtension string
    Specifies the extension for files unloaded to a stage.
    IgnoreUtf8Errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    NullIfs []string
    String used to convert to and from SQL NULL.
    ParseHeader bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    PreserveSpace bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    RecordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    ReplaceInvalidCharacters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    SkipBlankLines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    SkipByteOrderMark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    SkipHeader int
    Number of lines at the start of the file to skip.
    StripNullValues bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    StripOuterArray bool
    Boolean that instructs the JSON parser to remove outer brackets.
    StripOuterElement bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    TimeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    TimestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    TrimSpace bool
    Boolean that specifies whether to remove white space from fields.
    database String
    The database in which to create the file format.
    formatType String
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    schema String
    The schema in which to create the file format.
    allowDuplicate Boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText Boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat String
    Defines the encoding format for binary input or output.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the current compression algorithm for the data file.
    dateFormat String
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert Boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData Boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull Boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal Boolean
    Boolean that enables parsing of octal numbers.
    encoding String
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch Boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape String
    Single character string used as the escape character for field values.
    escapeUnenclosedField String
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy String
    Character used to enclose strings.
    fileExtension String
    Specifies the extension for files unloaded to a stage.
    ignoreUtf8Errors Boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs List<String>
    String used to convert to and from SQL NULL.
    parseHeader Boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace Boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters Boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    skipBlankLines Boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark Boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader Integer
    Number of lines at the start of the file to skip.
    stripNullValues Boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray Boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement Boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat String
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat String
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace Boolean
    Boolean that specifies whether to remove white space from fields.
    database string
    The database in which to create the file format.
    formatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    schema string
    The schema in which to create the file format.
    allowDuplicate boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat string
    Defines the encoding format for binary input or output.
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the current compression algorithm for the data file.
    dateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal boolean
    Boolean that enables parsing of octal numbers.
    encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape string
    Single character string used as the escape character for field values.
    escapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy string
    Character used to enclose strings.
    fileExtension string
    Specifies the extension for files unloaded to a stage.
    ignoreUtf8Errors boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs string[]
    String used to convert to and from SQL NULL.
    parseHeader boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    skipBlankLines boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader number
    Number of lines at the start of the file to skip.
    stripNullValues boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace boolean
    Boolean that specifies whether to remove white space from fields.
    database str
    The database in which to create the file format.
    format_type str
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    schema str
    The schema in which to create the file format.
    allow_duplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binary_as_text bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binary_format str
    Defines the encoding format for binary input or output.
    comment str
    Specifies a comment for the file format.
    compression str
    Specifies the current compression algorithm for the data file.
    date_format str
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disable_auto_convert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disable_snowflake_data bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    empty_field_as_null bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enable_octal bool
    Boolean that enables parsing of octal numbers.
    encoding str
    String (constant) that specifies the character set of the source data when loading data into a table.
    error_on_column_count_mismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape str
    Single character string used as the escape character for field values.
    escape_unenclosed_field str
    Single character string used as the escape character for unenclosed field values only.
    field_delimiter str
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    field_optionally_enclosed_by str
    Character used to enclose strings.
    file_extension str
    Specifies the extension for files unloaded to a stage.
    ignore_utf8_errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name str
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    null_ifs Sequence[str]
    String used to convert to and from SQL NULL.
    parse_header bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserve_space bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    record_delimiter str
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replace_invalid_characters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    skip_blank_lines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    skip_byte_order_mark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skip_header int
    Number of lines at the start of the file to skip.
    strip_null_values bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    strip_outer_array bool
    Boolean that instructs the JSON parser to remove outer brackets.
    strip_outer_element bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    time_format str
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestamp_format str
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trim_space bool
    Boolean that specifies whether to remove white space from fields.
    database String
    The database in which to create the file format.
    formatType String
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    schema String
    The schema in which to create the file format.
    allowDuplicate Boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText Boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat String
    Defines the encoding format for binary input or output.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the current compression algorithm for the data file.
    dateFormat String
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert Boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData Boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull Boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal Boolean
    Boolean that enables parsing of octal numbers.
    encoding String
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch Boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape String
    Single character string used as the escape character for field values.
    escapeUnenclosedField String
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy String
    Character used to enclose strings.
    fileExtension String
    Specifies the extension for files unloaded to a stage.
    ignoreUtf8Errors Boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs List<String>
    String used to convert to and from SQL NULL.
    parseHeader Boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace Boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters Boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    skipBlankLines Boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark Boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader Number
    Number of lines at the start of the file to skip.
    stripNullValues Boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray Boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement Boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat String
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat String
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace Boolean
    Boolean that specifies whether to remove white space from fields.

    Outputs

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

    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.
    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.
    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.
    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.
    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.
    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.

    Look up Existing FileFormat Resource

    Get an existing FileFormat 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?: FileFormatState, opts?: CustomResourceOptions): FileFormat
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        allow_duplicate: Optional[bool] = None,
        binary_as_text: Optional[bool] = None,
        binary_format: Optional[str] = None,
        comment: Optional[str] = None,
        compression: Optional[str] = None,
        database: Optional[str] = None,
        date_format: Optional[str] = None,
        disable_auto_convert: Optional[bool] = None,
        disable_snowflake_data: Optional[bool] = None,
        empty_field_as_null: Optional[bool] = None,
        enable_octal: Optional[bool] = None,
        encoding: Optional[str] = None,
        error_on_column_count_mismatch: Optional[bool] = None,
        escape: Optional[str] = None,
        escape_unenclosed_field: Optional[str] = None,
        field_delimiter: Optional[str] = None,
        field_optionally_enclosed_by: Optional[str] = None,
        file_extension: Optional[str] = None,
        format_type: Optional[str] = None,
        fully_qualified_name: Optional[str] = None,
        ignore_utf8_errors: Optional[bool] = None,
        name: Optional[str] = None,
        null_ifs: Optional[Sequence[str]] = None,
        parse_header: Optional[bool] = None,
        preserve_space: Optional[bool] = None,
        record_delimiter: Optional[str] = None,
        replace_invalid_characters: Optional[bool] = None,
        schema: Optional[str] = None,
        skip_blank_lines: Optional[bool] = None,
        skip_byte_order_mark: Optional[bool] = None,
        skip_header: Optional[int] = None,
        strip_null_values: Optional[bool] = None,
        strip_outer_array: Optional[bool] = None,
        strip_outer_element: Optional[bool] = None,
        time_format: Optional[str] = None,
        timestamp_format: Optional[str] = None,
        trim_space: Optional[bool] = None) -> FileFormat
    func GetFileFormat(ctx *Context, name string, id IDInput, state *FileFormatState, opts ...ResourceOption) (*FileFormat, error)
    public static FileFormat Get(string name, Input<string> id, FileFormatState? state, CustomResourceOptions? opts = null)
    public static FileFormat get(String name, Output<String> id, FileFormatState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:FileFormat    get:      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:
    AllowDuplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    BinaryAsText bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    BinaryFormat string
    Defines the encoding format for binary input or output.
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the current compression algorithm for the data file.
    Database string
    The database in which to create the file format.
    DateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    DisableAutoConvert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    DisableSnowflakeData bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    EmptyFieldAsNull bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    EnableOctal bool
    Boolean that enables parsing of octal numbers.
    Encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    ErrorOnColumnCountMismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    Escape string
    Single character string used as the escape character for field values.
    EscapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    FieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    FieldOptionallyEnclosedBy string
    Character used to enclose strings.
    FileExtension string
    Specifies the extension for files unloaded to a stage.
    FormatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IgnoreUtf8Errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    NullIfs List<string>
    String used to convert to and from SQL NULL.
    ParseHeader bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    PreserveSpace bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    RecordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    ReplaceInvalidCharacters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    Schema string
    The schema in which to create the file format.
    SkipBlankLines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    SkipByteOrderMark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    SkipHeader int
    Number of lines at the start of the file to skip.
    StripNullValues bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    StripOuterArray bool
    Boolean that instructs the JSON parser to remove outer brackets.
    StripOuterElement bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    TimeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    TimestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    TrimSpace bool
    Boolean that specifies whether to remove white space from fields.
    AllowDuplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    BinaryAsText bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    BinaryFormat string
    Defines the encoding format for binary input or output.
    Comment string
    Specifies a comment for the file format.
    Compression string
    Specifies the current compression algorithm for the data file.
    Database string
    The database in which to create the file format.
    DateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    DisableAutoConvert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    DisableSnowflakeData bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    EmptyFieldAsNull bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    EnableOctal bool
    Boolean that enables parsing of octal numbers.
    Encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    ErrorOnColumnCountMismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    Escape string
    Single character string used as the escape character for field values.
    EscapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    FieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    FieldOptionallyEnclosedBy string
    Character used to enclose strings.
    FileExtension string
    Specifies the extension for files unloaded to a stage.
    FormatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IgnoreUtf8Errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    Name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    NullIfs []string
    String used to convert to and from SQL NULL.
    ParseHeader bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    PreserveSpace bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    RecordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    ReplaceInvalidCharacters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    Schema string
    The schema in which to create the file format.
    SkipBlankLines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    SkipByteOrderMark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    SkipHeader int
    Number of lines at the start of the file to skip.
    StripNullValues bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    StripOuterArray bool
    Boolean that instructs the JSON parser to remove outer brackets.
    StripOuterElement bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    TimeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    TimestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    TrimSpace bool
    Boolean that specifies whether to remove white space from fields.
    allowDuplicate Boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText Boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat String
    Defines the encoding format for binary input or output.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the current compression algorithm for the data file.
    database String
    The database in which to create the file format.
    dateFormat String
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert Boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData Boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull Boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal Boolean
    Boolean that enables parsing of octal numbers.
    encoding String
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch Boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape String
    Single character string used as the escape character for field values.
    escapeUnenclosedField String
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy String
    Character used to enclose strings.
    fileExtension String
    Specifies the extension for files unloaded to a stage.
    formatType String
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors Boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs List<String>
    String used to convert to and from SQL NULL.
    parseHeader Boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace Boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters Boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    schema String
    The schema in which to create the file format.
    skipBlankLines Boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark Boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader Integer
    Number of lines at the start of the file to skip.
    stripNullValues Boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray Boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement Boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat String
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat String
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace Boolean
    Boolean that specifies whether to remove white space from fields.
    allowDuplicate boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat string
    Defines the encoding format for binary input or output.
    comment string
    Specifies a comment for the file format.
    compression string
    Specifies the current compression algorithm for the data file.
    database string
    The database in which to create the file format.
    dateFormat string
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal boolean
    Boolean that enables parsing of octal numbers.
    encoding string
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape string
    Single character string used as the escape character for field values.
    escapeUnenclosedField string
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy string
    Character used to enclose strings.
    fileExtension string
    Specifies the extension for files unloaded to a stage.
    formatType string
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name string
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs string[]
    String used to convert to and from SQL NULL.
    parseHeader boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter string
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    schema string
    The schema in which to create the file format.
    skipBlankLines boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader number
    Number of lines at the start of the file to skip.
    stripNullValues boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat string
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat string
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace boolean
    Boolean that specifies whether to remove white space from fields.
    allow_duplicate bool
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binary_as_text bool
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binary_format str
    Defines the encoding format for binary input or output.
    comment str
    Specifies a comment for the file format.
    compression str
    Specifies the current compression algorithm for the data file.
    database str
    The database in which to create the file format.
    date_format str
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disable_auto_convert bool
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disable_snowflake_data bool
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    empty_field_as_null bool
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enable_octal bool
    Boolean that enables parsing of octal numbers.
    encoding str
    String (constant) that specifies the character set of the source data when loading data into a table.
    error_on_column_count_mismatch bool
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape str
    Single character string used as the escape character for field values.
    escape_unenclosed_field str
    Single character string used as the escape character for unenclosed field values only.
    field_delimiter str
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    field_optionally_enclosed_by str
    Character used to enclose strings.
    file_extension str
    Specifies the extension for files unloaded to a stage.
    format_type str
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    ignore_utf8_errors bool
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name str
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    null_ifs Sequence[str]
    String used to convert to and from SQL NULL.
    parse_header bool
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserve_space bool
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    record_delimiter str
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replace_invalid_characters bool
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    schema str
    The schema in which to create the file format.
    skip_blank_lines bool
    Boolean that specifies to skip any blank lines encountered in the data files.
    skip_byte_order_mark bool
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skip_header int
    Number of lines at the start of the file to skip.
    strip_null_values bool
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    strip_outer_array bool
    Boolean that instructs the JSON parser to remove outer brackets.
    strip_outer_element bool
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    time_format str
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestamp_format str
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trim_space bool
    Boolean that specifies whether to remove white space from fields.
    allowDuplicate Boolean
    Boolean that specifies to allow duplicate object field names (only the last one will be preserved).
    binaryAsText Boolean
    Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text.
    binaryFormat String
    Defines the encoding format for binary input or output.
    comment String
    Specifies a comment for the file format.
    compression String
    Specifies the current compression algorithm for the data file.
    database String
    The database in which to create the file format.
    dateFormat String
    Defines the format of date values in the data files (data loading) or table (data unloading).
    disableAutoConvert Boolean
    Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation.
    disableSnowflakeData Boolean
    Boolean that specifies whether the XML parser disables recognition of Snowflake semi-structured data tags.
    emptyFieldAsNull Boolean
    Specifies whether to insert SQL NULL for empty fields in an input file, which are represented by two successive delimiters.
    enableOctal Boolean
    Boolean that enables parsing of octal numbers.
    encoding String
    String (constant) that specifies the character set of the source data when loading data into a table.
    errorOnColumnCountMismatch Boolean
    Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input file does not match the number of columns in the corresponding table.
    escape String
    Single character string used as the escape character for field values.
    escapeUnenclosedField String
    Single character string used as the escape character for unenclosed field values only.
    fieldDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate fields in an input file (data loading) or unloaded file (data unloading).
    fieldOptionallyEnclosedBy String
    Character used to enclose strings.
    fileExtension String
    Specifies the extension for files unloaded to a stage.
    formatType String
    Specifies the format of the input files (for data loading) or output files (for data unloading).
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    ignoreUtf8Errors Boolean
    Boolean that specifies whether UTF-8 encoding errors produce error conditions.
    name String
    Specifies the identifier for the file format; must be unique for the database and schema in which the file format is created.
    nullIfs List<String>
    String used to convert to and from SQL NULL.
    parseHeader Boolean
    Boolean that specifies whether to use the first row headers in the data files to determine column names.
    preserveSpace Boolean
    Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content.
    recordDelimiter String
    Specifies one or more singlebyte or multibyte characters that separate records in an input file (data loading) or unloaded file (data unloading).
    replaceInvalidCharacters Boolean
    Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character (�).
    schema String
    The schema in which to create the file format.
    skipBlankLines Boolean
    Boolean that specifies to skip any blank lines encountered in the data files.
    skipByteOrderMark Boolean
    Boolean that specifies whether to skip the BOM (byte order mark), if present in a data file.
    skipHeader Number
    Number of lines at the start of the file to skip.
    stripNullValues Boolean
    Boolean that instructs the JSON parser to remove object fields or array elements containing null values.
    stripOuterArray Boolean
    Boolean that instructs the JSON parser to remove outer brackets.
    stripOuterElement Boolean
    Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents.
    timeFormat String
    Defines the format of time values in the data files (data loading) or table (data unloading).
    timestampFormat String
    Defines the format of timestamp values in the data files (data loading) or table (data unloading).
    trimSpace Boolean
    Boolean that specifies whether to remove white space from fields.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi
    pulumi/pulumi-snowflake