`apache-airflow-providers-microsoft-mssql`¶

Content¶

Guides

References

Python API

Resources

Commits

Detailed list of commits

Package apache-airflow-providers-microsoft-mssql¶

Microsoft SQL Server (MSSQL)

Release: 3.4.0

Provider package¶

This is a provider package for microsoft.mssql provider. All classes for this provider package are in airflow.providers.microsoft.mssql python package.

Installation¶

You can install this package on top of an existing Airflow 2 installation (see Requirements below) for the minimum Airflow version supported) via pip install apache-airflow-providers-microsoft-mssql

Requirements¶

The minimum Apache Airflow version supported by this provider package is 2.4.0.

PIP package	Version required
`apache-airflow`	`>=2.4.0`
`apache-airflow-providers-common-sql`	`>=1.3.1`
`pymssql`	`>=2.1.5`

Cross provider package dependencies¶

Those are dependencies that might be needed in order to use all the features of the package. You need to install the specified provider packages in order to use them.

You can install such cross-provider dependencies when installing from PyPI. For example:

pip install apache-airflow-providers-microsoft-mssql[common.sql]

Dependent package	Extra
apache-airflow-providers-common-sql	`common.sql`

Downloading official packages¶

You can download officially released packages and verify their checksums and signatures from the Official Apache Download site

Changelog¶

3.4.0¶

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¶

Misc¶

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

3.3.1¶

Bug Fixes¶

Bump common.sql provider to 1.3.1 (#27888)

3.3.0¶

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¶

Misc¶

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

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)

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.

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

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)

2.0.1¶

Misc¶

Optimise connection importing for Airflow 2.2.0

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.

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.