Body

Original discussion: https://lists.apache.org/thread/8rhmz3qh30hvkondct4sfmgk4vd07mn5

tl;dr; DbApiHook assumes that Airflow Connection URI representation is a valid SA URI, but it is not true and never was, it might work in simple cases, however it will fail in some complex one.

This task intend to track fixes into the hooks which based on DbApiHook.

Hooks which don't overwrite invalid DbApiHook.get_uri implementation

• MySqlHook from mysql provider. This hook provide support for two different drivers.
  • mysqlclient: https://pypi.org/project/mysqlclient/
  • mysql-connector-python: https://pypi.org/project/mysql-connector-python/
• OracleHook from oracle provider
• JdbcHook from jdbc provider
• TrinoHook from trino provider
• HiveServer2Hook from apache.hive provider
• ImpalaHook from apache.impala provider
• DatabricksSqlHook from databricks provider
• ExasolHook from exasol provider
• PrestoHook from presto provider
• VerticaHook from vertica provider
• TeradataHook from teradata provider

Hooks which uses Connection.get_uri for construct SQLAlchemy URI

• PostgresHook from postgres provider. Connection to Postgres failed due to special characters in a password #38187, Connection id "extra" error #34456
• MsSqlHook from microsoft.mssql provider
• SqliteHook from sqlite provider

Committer

• I acknowledge that I am a maintainer/committer of the Apache Airflow project.