You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "yzliao-zip (via GitHub)" <gi...@apache.org> on 2023/04/01 01:01:30 UTC
[GitHub] [airflow] yzliao-zip opened a new issue, #30408: SnowflakeCheckOperator does not use the database parameter
yzliao-zip opened a new issue, #30408:
URL: https://github.com/apache/airflow/issues/30408
### Apache Airflow Provider(s)
snowflake
### Versions of Apache Airflow Providers
apache-airflow-providers-snowflake==4.0.4
### Apache Airflow version
2.3.4
### Operating System
Linux
### Deployment
Other 3rd-party Helm chart
### Deployment details
_No response_
### What happened
When running this operator
```python
SnowflakeCheckOperator(
task_id="task_name",
snowflake_conn_id=SNOWFLAKE_CONN_ID,
database="database_a",
sql="SELECT COUNT(*) > 0 FROM my_schema.users",
dag=dag,
)
```
Get the error that
```
snowflake.connector.errors.ProgrammingError: 090105 (22000): 01ab5318-0001-0771-0001-3f2201bdf396: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.
```
### What you think should happen instead
The operator should use the database passed as the operator argument and do not throw the error.
### How to reproduce
Use the operator example above and run a query. The connection id should not have default database.
### Anything else
_No response_
### 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
[GitHub] [airflow] potiuk commented on issue #30408: SnowflakeCheckOperator does not use the database parameter
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #30408:
URL: https://github.com/apache/airflow/issues/30408#issuecomment-1492873911
Feel free to take a stab on it.
--
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] SnowflakeCheckOperator does not use the database parameter [airflow]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #30408:
URL: https://github.com/apache/airflow/issues/30408#issuecomment-2039093913
This issue has been automatically marked as stale because it has been open for 365 days without any activity. There has been several Airflow releases since last activity on this issue. Kindly asking to recheck the report against latest Airflow version and let us know if the issue is reproducible. The issue will be closed in next 30 days if no further activity occurs from the issue author.
--
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] SnowflakeCheckOperator does not use the database parameter [airflow]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #30408: SnowflakeCheckOperator does not use the database parameter
URL: https://github.com/apache/airflow/issues/30408
--
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
[GitHub] [airflow] yzliao-zip commented on issue #30408: SnowflakeCheckOperator does not use the database parameter
Posted by "yzliao-zip (via GitHub)" <gi...@apache.org>.
yzliao-zip commented on issue #30408:
URL: https://github.com/apache/airflow/issues/30408#issuecomment-1498266188
I feel it is not the role issue for me. I tried to downgrade to 3.x and everything works fine. My suspicion is the `get_hook` function.
--
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] SnowflakeCheckOperator does not use the database parameter [airflow]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #30408:
URL: https://github.com/apache/airflow/issues/30408#issuecomment-2097588873
This issue has been closed because it has not received response from the issue author.
--
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
[GitHub] [airflow] ronald-fenner commented on issue #30408: SnowflakeCheckOperator does not use the database parameter
Posted by "ronald-fenner (via GitHub)" <gi...@apache.org>.
ronald-fenner commented on issue #30408:
URL: https://github.com/apache/airflow/issues/30408#issuecomment-1498253105
I ran into this issue as well, however, with the SnowflakeOperator. We tracked it down to a role issue. The message was a red herring in that it wasn't that it was not seeking the db just the role didn't have access to it.
It became a bit more apparent when I switched to using fully qualified names and got an access error to the db.
--
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