有没有办法从Snowflake下载超过100MB的数据到Excel或CSV中?通过UI,我可以通过点击“下载或查看结果按钮”下载高达100MB的数据。
CREATE TEMPORARY STAGE my_temp_stage;
COPY INTO @my_temp_stage/output_filex
FROM (select * FROM databaseNameHere.SchemaNameHere.tableNameHere)
FILE_FORMAT = (
TYPE='CSV'
COMPRESSION=GZIP
FIELD_DELIMITER=','
ESCAPE=NONE
ESCAPE_UNENCLOSED_FIELD=NONE
date_format='AUTO'
time_format='AUTO'
timestamp_format='AUTO'
binary_format='UTF-8'
field_optionally_enclosed_by='"'
null_if=''
EMPTY_FIELD_AS_NULL = FALSE
)
overwrite=TRUE
single=FALSE
max_file_size=5368709120
header=TRUE;
ls @my_temp_stage;
GET @my_temp_stage file:///tmp/ ;
这个示例: