[GitHub] [airflow] dstandish commented on issue #11710: JDBC connect string from connection uri parsed wrongly

[GitBox <gi...@apache.org>]

dstandish commented on issue #11710:
URL: https://github.com/apache/airflow/issues/11710#issuecomment-981884415


   Hi @humbledude 
   
   I think you may be confusing the two types of URIs here.
   
   The [airflow connection uri](https://airflow.apache.org/docs/apache-airflow/stable/howto/connection.html#connection-uri-format) is a mechanism of serializing airlfow's Connection object to a string.
   
   You can't just take a jdbc URI and expect it to parse as an airflow connection.  Airflow hooks parse airflow Connection objects in many different ways and you have to understand what the hook is looking for in order build the connection in the right way.
   
   First you should replace `jdbc:postgres` with `sqoop` in your connection URI.  this change alone will probably make it parse.
   
   But next you need to debug your URI to make sure it is interpreted by the hook in the right way.
   
   Looking at the sqoop hook, I see there is a `_prepare_command` method that would be useful for debugging the command.
   
   You can call this method and examine the output.  If necessary, change your uri.
   
   You can use `Connection.get_uri` to produce a URI given an airflow Connection object.
   
   Closing for now, let us know if you continue to have trouble.
   


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