Skip to main content

File Format

Controls the CREATE FILE FORMAT IF NOT EXISTS DDL statement that BimlFlex executes before Snowflake COPY INTO commands. The default creates a gzip-compressed, pipe-delimited CSV format (NOHEADER_PIPE_CSV_FORMAT) used by the generated landing file output. Override this setting when your landing files use a different format such as Parquet or JSON, or when you need to adjust delimiters, compression, or null-handling to match the files produced by your source extraction process.

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');.