set92 opened a new issue, #57151:
URL: https://github.com/apache/airflow/issues/57151
### Apache Airflow version
Other Airflow 2/3 version (please specify below)
### If "Other Airflow 2/3 version" selected, which one?
2.10.3
### What happened?
I'm running
```
SnowflakeSqlApiOperator(
task_id="run_sql",
snowflake_conn_id=snflk_conn_id,
sql=sql_statement,
database=sql_params["database"],
schema=sql_params["schema_db"],
deferrable=False,
statement_count=stmt_count,
warehouse=kwargs.get("warehouse"),
).execute(context=kwargs)
```
but Snowflake returns `Unable to run the command. You must specify the
warehouse to use by either setting the warehouse field in the body of the
request or by setting the DEFAULT_NAMESPACE property for the current user.`.
So, I suppose the Warehouse is not being considered. I suppose it is related to
#39622, but technically it was fixed.
I'm not sure if the rest of parameters, like schema and database are being
respected. Is there some parameter to check on those, and see what it is really
sending throught the API?
### What you think should happen instead?
_No response_
### How to reproduce
In my case I have the SnowflakeSqlApiOperator inside a pythonOperator, to
take advantage of running multiple queries, since the SnowflakeHook doesn't
have that logic. But I suppose in general is call a query from
SnowflakeSqlApiOperator and that the user doesn't have any default warehouse.
### Operating System
MWAA
### Versions of Apache Airflow Providers
<h2></h2>
Package Name | Version | Description
-- | -- | --
apache-airflow-providers-amazon | 9.0.0 | Amazon integration (including
Amazon Web Services (AWS)).
apache-airflow-providers-celery | 3.8.3 | Celery
apache-airflow-providers-common-compat | 1.7.3 | Common Compatibility
Provider - providing compatibility code for previous Airflow versions
apache-airflow-providers-common-io | 1.4.2 | ``Common IO Provider``
apache-airflow-providers-common-sql | 1.28.0 | Common SQL Provider
apache-airflow-providers-fab | 1.5.0 | Flask App Builder
apache-airflow-providers-ftp | 3.11.1 | File Transfer Protocol (FTP)
apache-airflow-providers-http | 4.13.2 | Hypertext Transfer Protocol (HTTP)
apache-airflow-providers-imap | 3.7.0 | Internet Message Access Protocol
(IMAP)
apache-airflow-providers-microsoft-mssql | 3.9.1 | Microsoft SQL Server
(MSSQL)
apache-airflow-providers-pagerduty | 5.0.2 | Pagerduty
apache-airflow-providers-postgres | 5.13.1 | PostgreSQL
apache-airflow-providers-slack | 9.2.0 | Slack services integration
including: - Slack API - Slack Incoming Webhook
apache-airflow-providers-smtp | 1.8.0 | Simple Mail Transfer Protocol (SMTP)
apache-airflow-providers-snowflake | 6.5.3 | Snowflake
apache-airflow-providers-sqlite | 3.9.0 | SQLite
Package Name Version Description
[apache-airflow-providers-amazon](https://airflow.apache.org/docs/apache-airflow-providers-amazon/9.0.0)
9.0.0 Amazon integration (including [Amazon Web Services
(AWS)](https://aws.amazon.com/)).
[apache-airflow-providers-celery](https://airflow.apache.org/docs/apache-airflow-providers-celery/3.8.3)
3.8.3 [Celery](https://docs.celeryq.dev/en/stable/)
[apache-airflow-providers-common-compat](https://airflow.apache.org/docs/apache-airflow-providers-common-compat/1.7.3)
1.7.3 Common Compatibility Provider - providing compatibility code for
previous Airflow versions
[apache-airflow-providers-common-io](https://airflow.apache.org/docs/apache-airflow-providers-common-io/1.4.2)
1.4.2 ``Common IO Provider``
[apache-airflow-providers-common-sql](https://airflow.apache.org/docs/apache-airflow-providers-common-sql/1.28.0)
1.28.0 [Common SQL Provider](https://en.wikipedia.org/wiki/SQL)
[apache-airflow-providers-fab](https://airflow.apache.org/docs/apache-airflow-providers-fab/1.5.0)
1.5.0 [Flask App Builder](https://flask-appbuilder.readthedocs.io/)
[apache-airflow-providers-ftp](https://airflow.apache.org/docs/apache-airflow-providers-ftp/3.11.1)
3.11.1 [File Transfer Protocol (FTP)](https://tools.ietf.org/html/rfc114)
[apache-airflow-providers-http](https://airflow.apache.org/docs/apache-airflow-providers-http/4.13.2)
4.13.2 [Hypertext Transfer Protocol
(HTTP)](https://www.w3.org/Protocols/)
[apache-airflow-providers-imap](https://airflow.apache.org/docs/apache-airflow-providers-imap/3.7.0)
3.7.0 [Internet Message Access Protocol
(IMAP)](https://tools.ietf.org/html/rfc3501)
[apache-airflow-providers-microsoft-mssql](https://airflow.apache.org/docs/apache-airflow-providers-microsoft-mssql/3.9.1)
3.9.1 [Microsoft SQL Server (MSSQL)](https://www.microsoft.com/sql-server/)
[apache-airflow-providers-pagerduty](https://airflow.apache.org/docs/apache-airflow-providers-pagerduty/5.0.2)
5.0.2 [Pagerduty](https://www.pagerduty.com/)
[apache-airflow-providers-postgres](https://airflow.apache.org/docs/apache-airflow-providers-postgres/5.13.1)
5.13.1 [PostgreSQL](https://www.postgresql.org/)
[apache-airflow-providers-slack](https://airflow.apache.org/docs/apache-airflow-providers-slack/9.2.0)
9.2.0 [Slack](https://slack.com/) services integration including: -
[Slack API](https://api.slack.com/) - [Slack Incoming
Webhook](https://api.slack.com/messaging/webhooks)
[apache-airflow-providers-smtp](https://airflow.apache.org/docs/apache-airflow-providers-smtp/1.8.0)
1.8.0 [Simple Mail Transfer Protocol
(SMTP)](https://tools.ietf.org/html/rfc5321)
[apache-airflow-providers-snowflake](https://airflow.apache.org/docs/apache-airflow-providers-snowflake/6.5.3)
6.5.3 [Snowflake](https://www.snowflake.com/)
[apache-airflow-providers-sqlite](https://airflow.apache.org/docs/apache-airflow-providers-sqlite/3.9.0)
3.9.0 [SQLite](https://www.sqlite.org/)
### Deployment
Amazon (AWS) MWAA
### 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]
