将Snowflake表数据卸载到Parquet格式的S3中

Question

我正在尝试将Snowflake tale数据卸载到镶木地板格式的S3桶中。但低于误差。

`SQL compilation error: COPY statement only supports simple SELECT from stage statements for import.`

以下是复制语句的语法

`create or replace stage STG_LOAD
url='s3://bucket/foler'
credentials=(aws_key_id='xxxx',aws_secret_key='xxxx')
file_format = (type = PARQUET);
copy into STG_LOAD from
(select OBJECT_CONSTRUCT(country_cd,source)
from table_1 
file_format = (type='parquet')
header='true';`

如果我遗漏了什么，请告诉我。

Answer 1

您必须使用@符号来识别命名阶段。标题选项也是true而不是'true'

copy into @STG_LOAD from
(select OBJECT_CONSTRUCT(country_cd,source)
from table_1 )
file_format = (type='parquet')
header=true;