Snowflake: Preserve 422 response payload instead of raising HTTP error.

[HyunWooZZ]

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

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

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.

[jroachgolf84]

@HyunWooZZ, please feel free to open a PR for this issue!

[dilshadshaik3031]

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.

[HyunWooZZ]

@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?

[dilshadshaik3031]

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.

[HyunWooZZ]

@dilshadshaik3031

Could you see my issue?
It relate with statement timeout snowflake!
#60894