JavierLopezT opened a new issue #10925: URL: https://github.com/apache/airflow/issues/10925
**Apache Airflow version**: 1.10.10 **Environment**: Docker-compose **What happened**: I used S3ToSwnoflakeTransfer and it gave me the following copy statement: ``` COPY INTO stg_users FROM @s3_airflow_ods/ files=airflow/sta_tables/import_users/users_20200911T112003de.csv file_format=REDSHIFT_UNLOAD_FILE_FORMAT; ``` Which throws several errors. First, it says this: `SQL compilation error: syntax error line 3 at position 13 unexpected '/'. syntax error line 3 at position 13 unexpected '/'. syntax error line 3 at position 24 unexpected '/'. syntax error line 3 at position 37 unexpected '/'. syntax error line 3 at position 61 unexpected '.'. syntax error line 4 at position 0 unexpected 'file_format'.` If it would have worked, then an error of file_format would have arisen, because I have got to specify both data warehouse and schema. **What you expected to happen**: The copy statement that works for me has been: ``` COPY INTO stg_users FROM @s3_airflow_ods/airflow/sta_tables/import_users/users_20200911T122850de.csv file_format=dwh.dw.REDSHIFT_UNLOAD_FILE_FORMAT; ``` I do not know if this is because of a recent Snowflake change or something like that. @feluelle Could you take a look at this please? Thanks ---------------------------------------------------------------- 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]
