File Format
The Snowflake file format to use.
The value is executed as a SQL statement immediately before the generated CREATE OR REPLACE STAGE statement for each load. The default creates a gzip-compressed, pipe-delimited CSV file format named NOHEADER_PIPE_CSV_FORMAT, matching the landing files produced by the generated source-to-file output. The generated stage always references the format by that name (FILE_FORMAT = noheader_pipe_csv_format), so an override should define a format with the same name and the adjusted properties.
When to Change This Setting
Change the format properties when the landing files differ from the default gzip pipe-delimited CSV layout, for example different delimiters, compression, or null handling.
Related Settings
| Setting | Interaction |
|---|---|
| Remove Stage | Drops the stage the file format is used with after the load |
Notes
- This setting is part of the Snowflake settings category.
- The default value for this setting is
CREATE FILE FORMAT IF NOT EXISTS "PUBLIC".NOHEADER_PIPE_CSV_FORMAT COMPRESSION = 'GZIP' ESCAPE_UNENCLOSED_FIELD = NONE FIELD_DELIMITER = '|' RECORD_DELIMITER = '\n' SKIP_HEADER = 0 TRIM_SPACE = FALSE NULL_IF = ('\\N');.