aaron-ang opened a new issue #16906: URL: https://github.com/apache/airflow/issues/16906
--> **Apache Airflow version**: 1.10.10 **Kubernetes version (if you are using kubernetes)** (use `kubectl version`): **Environment**: - **Cloud provider or hardware configuration**: - **OS** (e.g. from /etc/os-release): Ubuntu 18.04.2 LTS (Bionic Beaver) - **Kernel** (e.g. `uname -a`): 5.4.0-1041-aws - **Install tools**: - **Others**: **What happened**: After a SQL CTE, the next select statement is not captured by the Airflow job, causing the SQL to produce an error as the structure is altered <!-- (please include exact error messages if you can) --> **What you expected to happen**: Expected the job to capture the whole SQL query in the yaml file entirely <!-- What do you think went wrong? --> **How to reproduce it**: Use a Qualify statement(using Snowflake ANSI SQL) right before the end of the CTE in a yaml file <!--- As minimally and precisely as possible. Keep in mind we do not have access to your cluster or dags. If you are using kubernetes, please attempt to recreate the issue using minikube or kind. ## Install minikube/kind - Minikube https://minikube.sigs.k8s.io/docs/start/ - Kind https://kind.sigs.k8s.io/docs/user/quick-start/ If this is a UI bug, please provide a screenshot of the bug or a link to a youtube video of the bug in action You can include images using the .md style of   To record a screencast, mac users can use QuickTime and then create an unlisted youtube video with the resulting .mov file. ---> **Anything else we need to know**: Issue occurs and is causing failure in every run   <!-- Any relevant logs to include? Put them here in side a detail tag: <details><summary>x.log</summary> lots of stuff </details> --> -- 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]
