GomathiMa opened a new issue, #33963:
URL: https://github.com/apache/airflow/issues/33963

   ### Apache Airflow version
   
   Other Airflow 2 version (please specify below)
   
   ### What happened
   
   Airflow Version:2.5.1
   
   While using MWAA, CopyFromExternalStageToSnowflakeOperator: Failed with 
error "Invalid regular expression pattern in airflow"
   
   Error
   snowflake.connector.errors.ProgrammingError: 091003 (22000):
   
   Note: I am trying to use {{ ds_nodash }} variable in pattern. This variable 
value is not getting replaced in the pattern while generating copy into 
statement. However variable getting printed correctly in echo and works well 
with Snowflake operator - COPY TO as sql.
   
   ### What you think should happen instead
   
   _No response_
   
   ### How to reproduce
   
   Use CopyFromExternalStageToSnowflakeOperator and have pattern value contains 
the variable {{ ds_nodash }}
   
   ### Operating System
   
   Windows
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Deployment
   
   Official Apache Airflow Helm Chart
   
   ### Deployment details
   
   _No response_
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
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.

To unsubscribe, e-mail: [email protected]

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

Reply via email to