azure - 复制到雪花保存文件作为八位字节流，

Question

在这里有疑问。目标是使用 COPY INTO 命令将数据从 Snowflake 发送到 Azure Storageblob。 复制到 @AZURE_ML_STAGE FROM ( SELECT * FROM "DB"."SCHEMA"."DATA"WHERE _FIVETRAN_DELETED = FALSE ) FILE_FORMAT=(TYPE=csv)

尽管提到FILE_FORMAT=(TYPE=csv)，我们的 Azure 存储 blob 中的数据仍保存为八位字节流，并且该文件没有 .csv 扩展名。我们可能做错了什么？任何线索都会有帮助。提前致谢。

Answer 1

来自文档:TYPE = CSV

If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path. For example:

copy into @stage/data.csv ...

Default: null, meaning the file extension is determined by the format type, e.g. .csv[compression], where compression is the extension added by the compression method, if COMPRESSION is set.

还有:

COPY INTO @AZURE_ML_STAGE/output.csv
FROM ( SELECT * FROM "DB"."SCHEMA"."DATA" 
       WHERE _FIVETRAN_DELETED = FALSE ) 
FILE_FORMAT=(TYPE=csv)
COMPRESSION = NONE
SINGLE = TRUE;