Andrey Anshin

Build correct SQLAlchemy URI in hooks based on `DbApiHook`

9

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

At least latest version [`looker-sdk`](https://pypi.org/project/looker-sdk/) raise this warnings, but I guess it might affect older ones ```console looker_sdk/error.py:102: DeprecationWarning: invalid escape sequence \. ``` Since Python 3.12 this kind of...

Resolve `AirflowProviderDeprecationWarning` in providers system tests

6

### Body Time to time we deprecate some attributes/arguments and even entire Operators, however maintainer might forget to change it as result system tests which use as DAG/Operators example might...

Add `mssql` test integration

1

### Body After removal Microsoft SQL Server as DB Backend (https://lists.apache.org/thread/pgcgmhf6560k8jbsmz8nlyoxosvltph2) we lost an ability to run unit tests over MS SQL database. All unit tests which rely on mssql...

[Experiment] Use `importlib` import mode for `pytest`

5

Just an experiment whether or not airflow tests could use `importlib` mode instead of `prepend` - [import mode](https://docs.pytest.org/en/latest/explanation/pythonpath.html#import-modes) - [Choosing a test layout / import rules](https://docs.pytest.org/en/latest/explanation/goodpractices.html#choosing-an-import-mode) --- **^ Add meaningful...

Use base aws classes in amazon provider Operators/Sensors/Triggers

10

### Body Right now some inconsistency exists between different Operators/Sensors/Triggers which are use `AwsBaseGeneric` hook. After #34784 and #34884 we could make all of them (except Transfer Operators) use same...

Follow zero internal warning in unit tests

1

### Body This is follow up task after https://github.com/apache/airflow/pull/38504, we have quite a few tests which raise one of the internal deprecation warning: - `airflow.exceptions.AirflowProviderDeprecationWarning` - `airflow.exceptions.RemovedInAirflow3Warning` - `airflow.utils.context.AirflowContextDeprecationWarning` All...