I am trying to unload a zero byte file through copy into statement
I tried below query
COPY INTO @test_stage/pref/file_20250217000000.trg
FROM
(
SELECT NULL
)
FILE_FORMAT=(TYPE='CSV' COMPRESSION=NONE RECORD_DELIMITER=NONE )
HEADER=FALSE
SINGLE=TRUE
OVERWRITE=TRUE
;
The output is a 3B file
I am getting something in the output file, but I am trying to get it empty. here is what I see in the output file
\\N
Any suggestions?