最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

unloading zero byte file to snowflake external stage - Stack Overflow

programmeradmin1浏览0评论

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?

发布评论

评论列表(0)

  1. 暂无评论