(代表雪花用户提交(
例如 - "NiceOne" LLC","Robert","GoodRX",,"Maxift","Brian","P,N and B","Jane">
我已经能够使用创建满足每个条件的文件格式,但不能满足所有三个条件的文件格式。
我使用了以下建议:
您的第一列格式不正确,缺少首字母",它应该是: ""NiceOne" LLC">
修复后,您应该能够加载数据 默认设置,
COPY INTO my_table FROM @my_stage/my_file.csv FILE_FORMAT = (TYPE =
CSV FIELD_OPTIONALLY_ENCLOSED_BY = '"');
。但上述格式返回: 返回-
">"NiceOne" LLC","Robert","GoodRX",","Maxift","Brian","P,N and B","Jane">
我不想在空字段周围加上引号。我正在寻找
">"NiceOne" LLC","Robert","GoodRX",,"Maxift","Brian","P,N and B","Jane">
有什么建议吗?
如果您使用以下方法,您将不会在 NULL 字段周围获得引号,但您会在 ''(空文本(上获得引号。 如果这不适合您,您可以随时连接字段并手动设置生成的行的格式。
COPY INTO @my_stage/my_file.CSV
FROM (
SELECT
'"NiceOne" LLC' A, 'Robert' B, 'GoodRX' C, NULL D,
'Maxift' E, 'Brian' F, 'P,N and B' G, 'Jane' H
)
FILE_FORMAT = (
TYPE = CSV
FIELD_OPTIONALLY_ENCLOSED_BY = '"'
NULL_IF = ()
COMPRESSION = NONE
)
OVERWRITE = TRUE
SINGLE = TRUE