Airflow Summit 2025 is coming October 07-09. Register now to secure your spot!

apache-airflow-providers-microsoft-mssql

Changelog

4.3.2

Release Date: 2025-08-02

Misc

  • Add Python 3.13 support for Airflow. (#46891)

  • Cleanup type ignores in 4 microsoft providers where possible (#53312)

  • Remove type ignore across codebase after mypy upgrade (#53243)

  • Remove upper-binding for "python-requires" (#52980)

  • Temporarily switch to use >=,< pattern instead of '~=' (#52967)

4.3.1

Release Date: 2025-07-06

Misc

  • Move 'BaseHook' implementation to task SDK (#51873)

  • Drop support for Python 3.9 (#52072)

  • cleanup stale dependency of methodtools (#52310)

  • Bump pymssql version to 2.3.5 (#52307)

Doc-only

  • Add warning in changelog: use OdbcHook for ODBC drivers instead of MsSqlHook (#52646)

4.3.0

Release Date: 2025-05-18

Note

This release of provider is only available for Airflow 2.10+ as explained in the Apache Airflow providers support policy <https://github.com/apache/airflow/blob/main/PROVIDERS.rst#minimum-supported-version-of-airflow-for-community-managed-providers>_.

Misc

  • Bump min Airflow version in providers to 2.10 (#49843)

4.2.2

Release Date: 2025-04-09

Misc

  • Exclude 2.3.3 of pymssql (#48604)

4.2.1

Release Date: 2025-03-13

Bug Fixes

  • Fix MSSQL provider dependency on common-sql (#47188)

Misc

  • Upgrade flit to 3.11.0 (#46938)

4.2.0

Release Date: 2025-02-26

Note

This version has no code changes. It’s released due to yank of previous version due to packaging issues.

4.1.0

Release Date: 2025-02-21

Features

  • feat: Add OpenLineage support for MsSqlHook and MSSQLToGCSOperator (#45637)

  • Introduce notion of dialects in DbApiHook (#41327)

Bug Fixes

  • Fixed generated SQL MSSQL dialect when all columns are also primary keys (#46380)

  • Fix escaping of special characters or reserved words as column names in dialects of common sql provider (#45640)

Misc

  • Added ADR document describing why the notion of dialects is introduced (#45456)

4.0.0

Release Date: 2024-12-26

Note

This release of provider is only available for Airflow 2.9+ as explained in the Apache Airflow providers support policy.

Breaking changes

Warning

If you are using an ODBC driver, please use airflow.providers.odbc.hooks.OdbcHook instead of MsSqlHook as it is specifically designed to handle ODBC-specific parameters like ‘driver’ and ‘encrypt’.

Warning

All deprecated classes, parameters and features have been removed from the MySQL provider package. The following breaking changes were introduced:

  • Operators

    • Remove airflow.providers.microsoft.mssql.operators.mssql.MsSqlOperator. Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator.

  • Remove Provider Deprecations in Microsoft-MSSQL (#44762)

Features

  • Support connection extra parameters in MsSqlHook (#44310)

Misc

  • Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)

  • Update DAG example links in multiple providers documents (#44034)

3.9.2

Release Date: 2024-11-18

Misc

  • Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)

3.9.1

Release Date: 2024-09-24

Misc

  • Generalize caching of connection in DbApiHook to improve performance (#40751)

3.9.0

Release Date: 2024-08-22

Note

This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy.

Bug Fixes

  • Fix missing methodtools as dependency to MsSqlHook (#41392)

Misc

  • Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)

3.8.0

Release Date: 2024-08-06

Features

  • Added support for replace option when using insert_rows with MsSqlHook (#40836)

Misc

  • Clean up remaining getattr connection DbApiHook (#40665)

3.7.2

Release Date: 2024-06-27

Misc

  • implement per-provider tests with lowest-direct dependency resolution (#39946)

  • better define conn parameter type for MsSqlHook (#39831)

3.7.1

Release Date: 2024-05-30

Bug Fixes

  • use 'cached_property' to reuse 'get_connections' value in 'mssql' provider (#39575)

Misc

  • remove extra return (#39582)

  • Faster 'airflow_version' imports (#39552)

  • Simplify 'airflow_version' imports (#39497)

3.7.0

Release Date: 2024-05-06

Note

This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)

3.6.1

Release Date: 2024-02-15

Misc

  • feat: Switch all class, functions, methods deprecations to decorators (#36876)

3.6.0

Release Date: 2023-12-12

Note

This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)

  • Remove workaround for pymssql failing compilation with new Cython (#35924)

3.5.0

Release Date: 2023-10-17

Note

This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump min airflow version of providers (#34728)

3.4.2

Release Date: 2023-08-01

Misc

  • Add deprecation info to the providers modules and classes docstring (#32536)

3.4.1

Release Date: 2023-06-23

Note

This release dropped support for Python 3.7

Bug Fixes

  • Check if sqlalchemy_scheme extra contains forbidden characters (#31984)

3.4.0

Release Date: 2023-05-22

Note

This release of provider is only available for Airflow 2.4+ as explained in the Apache Airflow providers support policy.

Misc

  • Bump minimum Airflow version in providers (#30917)

3.3.2

Release Date: 2023-01-05

Misc

  • Re-enable 'pymsql' on ARM as it now builds cleanly (#28530)

3.3.1

Release Date: 2022-11-29

Bug Fixes

  • Bump common.sql provider to 1.3.1 (#27888)

3.3.0

Release Date: 2022-11-18

Note

This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy.

Misc

  • Move min airflow version to 2.3.0 for all providers (#27196)

  • Remove unnecessary newlines around single arg in signature (#27525)

Features

  • Add SQLExecuteQueryOperator (#25717)

3.2.1

Release Date: 2022-10-01

Misc

  • Add common-sql lower bound for common-sql (#25789)

3.2.0

Release Date: 2022-08-14

Features

  • Unify DbApiHook.run() method with the methods which override it (#23971)

Bug Fixes

  • Fix MsSqlHook.get_uri: pymssql driver to scheme (25092) (#25185)

3.1.0

Release Date: 2022-07-16

Features

  • Move all SQL classes to common-sql provider (#24836)

3.0.0

Release Date: 2022-06-13

Breaking changes

Note

This release of provider is only available for Airflow 2.2+ as explained in the Apache Airflow providers support policy.

2.1.3

Release Date: 2022-03-26

Bug Fixes

  • Fix mistakenly added install_requires for all providers (#22382)

2.1.2

Release Date: 2022-03-19

Misc

  • Add Trove classifiers in PyPI (Framework :: Apache Airflow :: Provider)

2.1.1

Release Date: 2022-03-10

Misc

  • Support for Python 3.10

2.1.0

Release Date: 2022-02-13

Features

  • Add more SQL template fields renderers (#21237)

  • Add conditional 'template_fields_renderers' check for new SQL lexers (#21403)

Misc

  • Add how-to Guide for MSSQL operators (#19470)

2.0.1

Release Date: 2021-09-03

Misc

  • Optimise connection importing for Airflow 2.2.0

2.0.0

Release Date: 2021-06-23

Breaking changes

  • Auto-apply apply_default decorator (#15667)

Warning

Due to apply_default decorator removal, this version of the provider requires Airflow 2.1.0+. If your Airflow version is < 2.1.0, and you want to install this provider version, first upgrade Airflow to at least version 2.1.0. Otherwise your Airflow package version will be upgraded automatically and you will have to manually run airflow upgrade db to complete the migration.

1.1.0

Release Date: 2021-05-06

Features

  • Remove odbc dependency in microsoft.mssql provider (#15594)

1.0.1

Release Date: 2021-02-08

Updated documentation and readme files.

1.0.0

Release Date: 2020-12-14

Initial version of the provider.

Was this entry helpful?