#7 - File Formats Snowflake Zero to Hero
Hey Data folks!
In this video, we’re diving deep into Snowflake File Formats—an essential skill for anyone working with data in Snowflake. Whether you’re loading or unloading data, understanding file formats is a game-changer for efficiency and accuracy.
We have covered here, Common parameters for CSV file format.
--- CSV file format with main parameters
CREATE OR REPLACE FILE FORMAT CSV_TYPE
TYPE = 'CSV'
FIELD_DELIMITER = ','
RECORD_DELIMITER = '\n'
SKIP_HEADER = 1
FIELD_OPTIONALLY_ENCLOSED_BY = '"'
TRIM_SPACE = FALSE
ERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
ESCAPE = 'NONE'
ESCAPE_UNENCLOSED_FIELD = '\134'
DATE_FORMAT = 'DD-MM-YYYY'
TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
ENCODING ='UTF8';
Feel free to comment about any doubts.
#snowflakecomputing #snowflake #snowsight #fileformat #snowflakearchitecture #datawarehouse #clouddata