Set file name for unloaded file from Snowflake

Question

I am unloading snowflake data into external AWS S3 stg using the below command,

copy into '@ext_stg/path/file_name' 
from schema.table
file_format = (type=csv  field_delimiter= '~' compression='gzip' null_if=('','NULL', 'null',' ') field_optionally_enclosed_by= '"' )
OVERWRITE = TRUE
;

I want the unloaded filename to be file_name.csv.gz.

But what I am actually getting from the above code is, file_name_0_3_0.csv.gz

How do i set the desired filename as file_name.csv.gz

score 0 · Accepted Answer · edited Mar 25 '20 at 11:00

0

setting SINGLE=TRUE MAX_FILE_SIZE=5000000000 gave me the desired output. Thank you @waldente

edited Mar 25 '20 at 11:00

Dharman

30,962
25
85
135

answered Mar 25 '20 at 10:33

Harikrishnan Balachandran

570
9
24

score -1 · Answer 2 · answered Mar 23 '20 at 18:22

-1

Looks like you are trying to specify the csv extension twice. Try removing it from the S3 path, because the file extension is already specified in file_format.

copy into '@ext_stg/path/file_name~~.csv~~'

from schema.table

file_format = (type=csv field_delimiter= '~' compression='gzip' null_if=('','NULL', 'null',' ') field_optionally_enclosed_by= '"' )

OVERWRITE = TRUE ;

answered Mar 23 '20 at 18:22

algorithmor

39
4

Thanks. I am still getting _0_3_0 getting appended to filename. How to fix that? – Harikrishnan Balachandran Mar 23 '20 at 18:38
2

Try `SINGLE=TRUE MAX_FILE_SIZE=5000000000` before the semicolon – waldente Mar 23 '20 at 19:45

Set file name for unloaded file from Snowflake

2 Answers2