Improve error messages for Snowflake operators to include query and context

### Description

Error messages raised by Snowflake operators can be generic and may not always provide enough context (such as the SQL query or operator details), making debugging more difficult for users.

### Use case/motivation

Error messages should include additional context such as:
- the SQL query being executed (or a truncated version)
- operator/task context
- clearer indication of failure type (connection vs execution)

This would improve debugging and developer experience when working with Snowflake in Airflow.

### Related issues

No

### Are you willing to submit a 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)