feluelle commented on issue #10925:
URL: https://github.com/apache/airflow/issues/10925#issuecomment-697194315


   I think the syntax you are using is incorrect.
   
   From the [snowflake 
docs](https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#reloading-files)
 it should be:
   ```
   COPY INTO load1 FROM @%load1/data1/
       FILES=('test1.csv', 'test2.csv')
   ```
   
   So in your case it should be:
   ```
   COPY INTO ods.stg_users 
   FROM @s3_airflow_ods/
   files=('airflow/sta_tables/import_users/users_20200911T112003de.csv')
   file_format=REDSHIFT_UNLOAD_FILE_FORMAT;
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to