How to Load csv into snowflake using snowsql CLI |SNOWFLAKE

Опубликовано: 27 Октябрь 2024
на канале: Touche Bin

156

command to upload file to staging area in snowflake

put file://C:\Users\Public\Data\loan_10k.csv @~;
list @~;
command to list files in the user stage : list @~;

--load the file form user stage to snowflake table

copy into MORTGAGE_DATA_M1 from @~ files=('loan_10k.csv.gz') file_format=(TYPE=CSV FIELD_DELIMITER=',' SKIP_HEADER = 1 COMPRESSION = GZIP NULL_IF='NULL');