+1 (non binding) I agree with this direction. It would be helpful to guide users on their next steps as Jarek suggested.
Best, Wei > On Aug 18, 2023, at 9:29 PM, Michał Modras <michalmod...@google.com.INVALID> > wrote: > > +1 - I strongly agree with the direction too. > > On Fri, Aug 18, 2023 at 2:31 PM Jarek Potiuk <ja...@potiuk.com> wrote: > >> I am strongly for it. I wanted to raise the same proposal after we see the >> results of the survey (which I hope we will run after the Summit) - in >> order to get more data points on how many users use it. But I agree the >> datapoints we have support the "low usage, high trouble" status of it. >> MSSQL creates a lot of troubles, it has bitten us more than once. >> >> One comment though: I think an important point of this removal should be >> some viable way for our users to move out to (likely) Postgres. We should >> provide at least a description, ideally some scripts that will be able to >> move data from MSSQL to Postgres as part of this "support dropping". >> >> I hate to say to anyone "sorry, no more support, deal with it yourself". >> >> But saying: "sorry, no more support, here is a way how you can migrate to >> what we support" is a much better message . >> >> J. >> >> >> J. >> >> >> On Fri, Aug 18, 2023 at 2:06 PM Elad Kalif <elad...@apache.org> wrote: >> >>> Hello everyone, >>> >>> In May 2021 we added MsSQL as an experimental backend. PR >>> https://github.com/apache/airflow/pull/9973 >>> Mailing list announcement: >>> https://lists.apache.org/thread/byx4czfyowwm3qy8c8p2o65vd53fyvsd >>> >>> During this time we hoped it would become stable and widely adopted. >>> To my taste MsSQL a backend has left a niche and is *not* worth the >>> maintenance of it in our CI. >>> >>> Some data points: >>> >>> 1. Only 5 issues >>> < >>> >> https://github.com/apache/airflow/issues?q=is%3Aissue+label%3Abackend-mssql-experimintal+is%3Aopen >>>> >>> were >>> reported on MsSQL as a backend which suggests it's not widely adopted. >>> These issues also don't have much traffic. >>> 2. None of the Airflow as service cloud vendors use it as a backend or >>> expressed interest in it (to the best of my knowledge) >>> 3. We had many PRs trying to fix issues related to MsSQL. To name a >> few: >>> https://github.com/apache/airflow/pull/33265 >>> https://github.com/apache/airflow/pull/32433 >>> https://github.com/apache/airflow/pull/31815 >>> each one required diagnostic and effort to address the problems (in >> some >>> cases required also rebasing of all other PRs after fix was merged) >>> >>> >>> I think that after 2+ years of experiment we can terminate it. >>> Since this is experimental we can drop support for this feature as this >> is >>> not considered a breaking change. >>> >>> *My Proposal:* >>> Drop support for MsSQL as official/supported backend. >>> >>> WDYT? >>> >>> Elad Kalif >>> >>
