You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "HyunWooZZ (via GitHub)" <gi...@apache.org> on 2026/01/19 05:00:51 UTC
[I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
HyunWooZZ opened a new issue, #60765:
URL: https://github.com/apache/airflow/issues/60765
### Apache Airflow Provider(s)
snowflake
### Versions of Apache Airflow Providers
6.8.2
### Apache Airflow version
2.11.0
### Operating System
NAME="Amazon Linux" VERSION="2023"
### Deployment
Amazon (AWS) MWAA
### Deployment details
_No response_
### What happened
When using SnowflakeSqlApiHook HTTP 422 (query failure) responses from the Snowflake SQL API are immediately raised via response.raise_for_status().
Because of this, the response body is never read, and the hook loses the JSON/text payload
returned by Snowflake.
As a result, downstream components (e.g. TriggerEvent logs) only receive a generic ClientResponseError message such as:
```
422, message='Unprocessable Entity', url='https://<account>.snowflakecomputing.com/...'
```
### What you think should happen instead
We need to pass this payload to _process_response method.
There is already enhanced message payload handler.
### How to reproduce
1. Submit a Snowflake SQL query that results in a statement-level error, for example:
```
SELECT 1 / 0;
```
2. Poll the query status using SnowflakeSqlApiHook.
3. The Snowflake SQL API returns an HTTP 422 (Unprocessable Entity) response.
4. The hook raises an HTTP error via response.raise_for_status(), and the response payload is discarded.
### Anything else
I will handle this issue with below issue.
https://github.com/apache/airflow/pull/60689
### Are you willing to submit PR?
- [x] 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: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk closed issue #60765: Snowflake: Preserve 422 response payload instead of raising HTTP error.
URL: https://github.com/apache/airflow/issues/60765
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "dilshadshaik3031 (via GitHub)" <gi...@apache.org>.
dilshadshaik3031 commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3778523302
Thanks for reporting this.
I’m interested in taking a look at this issue and trying to prepare a fix.
Please let me know if that works.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "dilshadshaik3031 (via GitHub)" <gi...@apache.org>.
dilshadshaik3031 commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3780132645
Thank you for your response and for all the work you’ve already done — I really appreciate it, and no worries at all 🙂
Yes, I’d be happy to help with the other issue. Please share the details and I’ll work through it with you.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "jroachgolf84 (via GitHub)" <gi...@apache.org>.
jroachgolf84 commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3768248381
@HyunWooZZ, please feel free to open a PR for this issue!
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "HyunWooZZ (via GitHub)" <gi...@apache.org>.
HyunWooZZ commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3780106932
@dilshadshaik3031 Thank you for replying!
However I already did a lot, I'm really sorry for that.
But i have another issue also, Would you resolve that with me?
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "boring-cyborg[bot] (via GitHub)" <gi...@apache.org>.
boring-cyborg[bot] commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3766413428
Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "HyunWooZZ (via GitHub)" <gi...@apache.org>.
HyunWooZZ commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3780482933
@dilshadshaik3031
Could you see my issue?
It relate with statement timeout snowflake!
https://github.com/apache/airflow/issues/60894
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Snowflake: Preserve 422 response payload instead of raising HTTP error. [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #60765:
URL: https://github.com/apache/airflow/issues/60765#issuecomment-3902160801
Apparently closed already in new release - we can reopen if not.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org