providers/microsoft/mssql/docs/changelog.rst
.. Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
.. http://www.apache.org/licenses/LICENSE-2.0
.. Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
.. NOTE TO CONTRIBUTORS: Please, only add notes to the Changelog just below the "Changelog" header when there are some breaking changes and you want to add an explanation to the users on how they are supposed to deal with them. The changelog is updated and maintained semi-automatically by release manager.
apache-airflow-providers-microsoft-mssql
4.5.0 .....
Features
* ``feat: Add Hook Level Lineage to SQL hooks (#61535)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Add 'lifecycle' field to provider.yaml schema and all providers per AIP-95 (#62190)``
4.4.1
.....
Misc
~~~~
* ``New year means updated Copyright notices (#60344)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Updated conf import for std,es,os,ms providers (#60030)``
4.4.0
.....
.. note::
This release of provider is only available for Airflow 2.11+ 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 minimum Airflow version in providers to Airflow 2.11.0 (#58612)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Updates to release process of providers (#58316)``
4.3.3
.....
Misc
~~~~
* ``Convert all airflow distributions to be compliant with ASF requirements (#58138)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Delete all unnecessary LICENSE Files (#58191)``
* ``Enable PT006 rule to microsoft Provider test(azure,mssql,psrp) (#57936)``
* ``Prepare release for Oct 2025 wave of providers (#57029)``
* ``Remove placeholder Release Date in changelog and index files (#56056)``
* ``Prepare release for Sep 2025 2nd wave of providers (#55688)``
* ``Prepare release for Sep 2025 1st wave of providers (#55203)``
* ``Fix Airflow 2 reference in README/index of providers (#55240)``
* ``Make term Dag consistent in providers docs (#55101)``
* ``Switch pre-commit to prek (#54258)``
4.3.2
.....
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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
4.3.1
.....
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).. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
4.3.0 .....
.. 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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Update description of provider.yaml dependencies (#50231)``
* ``Avoid committing history for providers (#49907)``
* ``Mark mssql and samba tests as db-tests (#49213)``
* ``Prepare docs for Apr 2nd wave of providers (#49051)``
* ``Remove unnecessary entries in get_provider_info and update the schema (#48849)``
* ``Remove fab from preinstalled providers (#48457)``
* ``Improve documentation building iteration (#48760)``
4.2.2
.....
Misc
Exclude 2.3.3 of pymssql (#48604).. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
Simplify tooling by switching completely to uv (#48223)Upgrade ruff to latest version (#48553)Prepare docs for Mar 2nd wave of providers (#48383)Upgrade providers flit build requirements to 3.12.0 (#48362)Move airflow sources to airflow-core package (#47798)Remove links to x/twitter.com (#47801)fix url typo (#47766)4.2.1 .....
Bug Fixes
* ``Fix MSSQL provider dependency on common-sql (#47188)``
Misc
~~~~
* ``Upgrade flit to 3.11.0 (#46938)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Move tests_common package to devel-common project (#47281)``
* ``Improve documentation for updating provider dependencies (#47203)``
* ``Add legacy namespace packages to airflow.providers (#47064)``
* ``Remove extra whitespace in provider readme template (#46975)``
4.2.0
.....
.. note::
This version has no code changes. It's released due to yank of previous version due to packaging issues.
4.1.0
.....
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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Avoid imports from "providers" (#46801)``
* ``Move provider_tests to unit folder in provider tests (#46800)``
* ``Removed the unused provider's distribution (#46608)``
* ``Move Microsoft MSSQL / PSRP and WinRM providers to new provider structure (#46338)``
4.0.0
.....
.. note::
This release of provider is only available for Airflow 2.9+ 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>`_.
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
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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Use Python 3.9 as target version for Ruff & Black rules (#44298)``
* ``Update path of example dags in docs (#45069)``
3.9.2
.....
Misc
~~~~
* ``Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Start porting DAG definition code to the Task SDK (#43076)``
* ``Split providers out of the main "airflow/" tree into a UV workspace project (#42505)``
3.9.1
.....
Misc
~~~~
* ``Generalize caching of connection in DbApiHook to improve performance (#40751)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
3.9.0
.....
.. note::
This release of provider is only available for Airflow 2.8+ 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>`_.
Bug Fixes
Fix missing methodtools as dependency to MsSqlHook (#41392)Misc
* ``Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Add comment on methodtools in mssql provider.yaml (#41402)``
3.8.0
.....
Features
Added support for replace option when using insert_rows with MsSqlHook (#40836)Misc
* ``Clean up remaining getattr connection DbApiHook (#40665)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
3.7.2
.....
Misc
implement per-provider tests with lowest-direct dependency resolution (#39946)better define conn parameter type for MsSqlHook (#39831)3.7.1 .....
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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Reapply templates for all providers (#39554)``
3.7.0
.....
.. note::
This release of provider is only available for Airflow 2.7+ 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 minimum Airflow version in providers to Airflow 2.7.0 (#39240)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Add comment about versions updated by release manager (#37488)``
* ``Prepare docs 1st wave (RC1) April 2024 (#38863)``
* ``Bump ruff to 0.3.3 (#38240)``
* ``Prepare docs 1st wave (RC1) March 2024 (#37876)``
3.6.1
.....
Misc
~~~~
* ``feat: Switch all class, functions, methods deprecations to decorators (#36876)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``D401 Support in Providers (simple) (#37258)``
* ``Add docs for RC2 wave of providers for 2nd round of Jan 2024 (#37019)``
* ``Prepare docs 2nd wave of Providers January 2024 (#36945)``
* ``Prepare docs 1st wave of Providers January 2024 (#36640)``
* ``Speed up autocompletion of Breeze by simplifying provider state (#36499)``
* ``Add documentation for 3rd wave of providers in Deember (#36464)``
* ``Re-apply updated version numbers to 2nd wave of providers in December (#36380)``
3.6.0
.....
.. note::
This release of provider is only available for Airflow 2.6+ 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 minimum Airflow version in providers to Airflow 2.6.0 (#36017)``
* ``Remove workaround for pymssql failing compilation with new Cython (#35924)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Fix and reapply templates for provider documentation (#35686)``
* ``Prepare docs 3rd wave of Providers October 2023 - FIX (#35233)``
* ``Update information about links into the provider.yaml files (#35837)``
* ``Prepare docs 2nd wave of Providers November 2023 (#35836)``
* ``Use reproducible builds for providers (#35693)``
* ``Prepare docs 1st wave of Providers November 2023 (#35537)``
* ``Prepare docs 3rd wave of Providers October 2023 (#35187)``
* ``Pre-upgrade 'ruff==0.0.292' changes in providers (#35053)``
3.5.0
.....
.. note::
This release of provider is only available for Airflow 2.5+ 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 of providers (#34728)``
3.4.2
.....
Misc
~~~~
* ``Add deprecation info to the providers modules and classes docstring (#32536)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Prepare docs for July 2023 wave of Providers (RC2) (#32381)``
* ``Remove spurious headers for provider changelogs (#32373)``
* ``Prepare docs for July 2023 wave of Providers (#32298)``
* ``D205 Support - Providers: GRPC to Oracle (inclusive) (#32357)``
* ``Improve provider documentation and README structure (#32125)``
3.4.1
.....
.. note::
This release dropped support for Python 3.7
Bug Fixes
Check if sqlalchemy_scheme extra contains forbidden characters (#31984).. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
Add D400 pydocstyle check - Microsoft provider only (#31425)Add note about dropping Python 3.7 for providers (#32015)3.4.0 .....
.. note::
This release of provider is only available for Airflow 2.4+ 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 minimum Airflow version in providers (#30917)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Add full automation for min Airflow version for providers (#30994)``
* ``Add mechanism to suspend providers (#30422)``
* ``Use 'AirflowProviderDeprecationWarning' in providers (#30975)``
* ``Use '__version__' in providers not 'version' (#31393)``
* ``Fixing circular import error in providers caused by airflow version check (#31379)``
* ``Prepare docs for May 2023 wave of Providers (#31252)``
3.3.2
.....
Misc
Re-enable 'pymsql' on ARM as it now builds cleanly (#28530).. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
3.3.1 .....
Bug Fixes
* ``Bump common.sql provider to 1.3.1 (#27888)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Prepare for follow-up release for November providers (#27774)``
3.3.0
.....
.. note::
This release of provider is only available for Airflow 2.3+ 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
~~~~
* ``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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Enable string normalization in python formatting - providers (#27205)``
3.2.1
.....
Misc
~~~~
* ``Add common-sql lower bound for common-sql (#25789)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Apply PEP-563 (Postponed Evaluation of Annotations) to non-core airflow (#26289)``
3.2.0
.....
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 .....
Features
* ``Move all SQL classes to common-sql provider (#24836)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Move provider dependencies to inside provider folders (#24672)``
* ``Remove 'hook-class-names' from provider.yaml (#24702)``
3.0.0
.....
Breaking changes
.. note::
This release of provider is only available for Airflow 2.2+ 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>_.
.. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
Migrate Microsoft example DAGs to new design #22452 - mssql (#24139)Add explanatory note for contributors about updating Changelog (#24229)Prepare docs for May 2022 provider's release (#24231)Update package description to remove double min-airflow specification (#24292)2.1.3 .....
Bug Fixes
* ``Fix mistakenly added install_requires for all providers (#22382)``
2.1.2
.....
Misc
~~~~~
* ``Add Trove classifiers in PyPI (Framework :: Apache Airflow :: Provider)``
2.1.1
.....
Misc
~~~~
* ``Support for Python 3.10``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
2.1.0
.....
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)``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Fix K8S changelog to be PyPI-compatible (#20614)``
* ``Fix template_fields type to have MyPy friendly Sequence type (#20571)``
* ``Fixing MyPy issues inside providers/microsoft (#20409)``
* ``Remove ':type' lines now sphinx-autoapi supports typehints (#20951)``
* ``Update documentation for provider December 2021 release (#20523)``
* ``Even more typing in operators (template_fields/ext) (#20608)``
* ``Update documentation for November 2021 provider's release (#19882)``
* ``Add documentation for January 2021 providers release (#21257)``
2.0.1
.....
Misc
~~~~
* ``Optimise connection importing for Airflow 2.2.0``
.. Below changes are excluded from the changelog. Move them to
appropriate section above if needed. Do not delete the lines(!):
* ``Update description about the new ''connection-types'' provider meta-data (#17767)``
* ``Import Hooks lazily individually in providers manager (#17682)``
* ``Prepares docs for Rc2 release of July providers (#17116)``
* ``Prepare documentation for July release of providers. (#17015)``
* ``Removes pylint from our toolchain (#16682)``
2.0.0
.....
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.
.. Below changes are excluded from the changelog. Move them to appropriate section above if needed. Do not delete the lines(!):
Updated documentation for June 2021 provider release (#16294)More documentation update for June providers release (#16405)Synchronizes updated changelog after buggfix release (#16464)1.1.0 .....
Features
* ``Remove odbc dependency in microsoft.mssql provider (#15594)``
1.0.1
.....
Updated documentation and readme files.
1.0.0
.....
Initial version of the provider.