Juacall opened a new issue #20965:
URL: https://github.com/apache/airflow/issues/20965


   ### Apache Airflow Provider(s)
   
   trino
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Apache Airflow version
   
   2.2.3 (latest released)
   
   ### Operating System
   
   macOS Monterey
   
   ### Deployment
   
   Virtualenv installation
   
   ### Deployment details
   
   Basic deployment with the providers trino and mysql. Not using fernet key.
   
   ### What happened
   
   The Trino hook requires a username and password to use the hook. If i were 
to try to use a connection without it, it would error out asking for basic 
authentication or a trino user. If i add a username and password to a 
connection. The connection becomes encrypted and is added to secrets then i 
won't be able to discover it unless i go through the basehook.
   
   conn = BaseHook.get_connection(kwargs['my_conn_id'])
   
   ### What you expected to happen
   
   I'm allowed to use a the hook without a username and password and or I can 
add a connection i retrieved from a base hook to the trino hook.
   
   ### How to reproduce
   
   Run a trino server without any authentication. Use the Trino hook with the 
trino_default connection. 
   Will receive error Basic Authentication or X-Trino-User must be sent.
   
   Add basic authentication to Trino server and to airflow trino_default  
connection. Try use TrinoHook. 
   Will receive error. conn_id trino_default not defined.
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to