问如何使用s3 stage集成将数据插入snowflake

EN

USE DATABASE Database_name;
USE SCHEMA scema_name;
truncate table table_name_tmp;
COPY INTO table_name_tmp FROM
(
SELECT $1:emp_id::INTEGER,$1:col2::DATE,$1:col3::string
  FROM @Stagename.schema_name.{0}/{1}
)
on_error = 'continue'
file_format = (type = parquet, null_if = ('NULL'), trim_space = true);


MERGE INTO table_name dst USING table_name_tmp srs
    ON (dst.emp_id=srs.emp_id)
    WHEN MATCHED THEN
        UPDATE SET
        dst.emp_id=srs.emp_id,dst.col2=srs.col2,dst.col3=srs.col3
        
         WHEN NOT MATCHED THEN INSERT (emp_id,col2,col3 )
         values
         (srs.emp_id,srs.col2,srs.col3
);
truncate table table_name_tmp;