You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airflow.apache.org by "Cieplucha, Michal" <mi...@intel.com> on 2017/06/21 13:51:42 UTC

airflow with MSSQL db

Hello,

Is MSSQL server supported as airflow metadata DB host? Have anybody tried to set it up? Any concerns?

Thanks
mC
--------------------------------------------------------------------

Intel Technology Poland sp. z o.o.
ul. Slowackiego 173 | 80-298 Gdansk | Sad Rejonowy Gdansk Polnoc | VII Wydzial Gospodarczy Krajowego Rejestru Sadowego - KRS 101882 | NIP 957-07-52-316 | Kapital zakladowy 200.000 PLN.

Ta wiadomosc wraz z zalacznikami jest przeznaczona dla okreslonego adresata i moze zawierac informacje poufne. W razie przypadkowego otrzymania tej wiadomosci, prosimy o powiadomienie nadawcy oraz trwale jej usuniecie; jakiekolwiek
przegladanie lub rozpowszechnianie jest zabronione.
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). If you are not the intended recipient, please contact the sender and delete all copies; any review or distribution by
others is strictly prohibited.


Re: airflow with MSSQL db

Posted by Chad Henderson <ch...@gritlogic.com>.
I've been running it for a few months without issue. I'm pretty sure you'll
need to make sure to include this commit if it hasn't made it onto 1.8 yet

https://github.com/apache/incubator-airflow/pull/2022/commits/702d3abd0d84773ca27f608d26b1f7243abc7336



On Wed, Jun 21, 2017 at 12:09 PM, Bolke de Bruin <bd...@gmail.com> wrote:

> It is not officially supported but I know of some that run airflow on top
> of mssql. We do integrate fixes for it and did so in the past.
>
> The sql we run is not overly complex, so in general you should be fine. I
> would stress test it with a couple of examples and run the tests against it.
>
> Bolke
>
> Sent from my iPhone
>
> > On 21 Jun 2017, at 15:51, Cieplucha, Michal <mi...@intel.com>
> wrote:
> >
> > Hello,
> >
> > Is MSSQL server supported as airflow metadata DB host? Have anybody
> tried to set it up? Any concerns?
> >
> > Thanks
> > mC
> > --------------------------------------------------------------------
> >
> > Intel Technology Poland sp. z o.o.
> > ul. Slowackiego 173 | 80-298 Gdansk | Sad Rejonowy Gdansk Polnoc | VII
> Wydzial Gospodarczy Krajowego Rejestru Sadowego - KRS 101882 | NIP
> 957-07-52-316 | Kapital zakladowy 200.000 PLN.
> >
> > Ta wiadomosc wraz z zalacznikami jest przeznaczona dla okreslonego
> adresata i moze zawierac informacje poufne. W razie przypadkowego
> otrzymania tej wiadomosci, prosimy o powiadomienie nadawcy oraz trwale jej
> usuniecie; jakiekolwiek
> > przegladanie lub rozpowszechnianie jest zabronione.
> > This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). If you are not the intended
> recipient, please contact the sender and delete all copies; any review or
> distribution by
> > others is strictly prohibited.
> >
>

Re: airflow with MSSQL db

Posted by Bolke de Bruin <bd...@gmail.com>.
It is not officially supported but I know of some that run airflow on top of mssql. We do integrate fixes for it and did so in the past. 

The sql we run is not overly complex, so in general you should be fine. I would stress test it with a couple of examples and run the tests against it. 

Bolke

Sent from my iPhone

> On 21 Jun 2017, at 15:51, Cieplucha, Michal <mi...@intel.com> wrote:
> 
> Hello,
> 
> Is MSSQL server supported as airflow metadata DB host? Have anybody tried to set it up? Any concerns?
> 
> Thanks
> mC
> --------------------------------------------------------------------
> 
> Intel Technology Poland sp. z o.o.
> ul. Slowackiego 173 | 80-298 Gdansk | Sad Rejonowy Gdansk Polnoc | VII Wydzial Gospodarczy Krajowego Rejestru Sadowego - KRS 101882 | NIP 957-07-52-316 | Kapital zakladowy 200.000 PLN.
> 
> Ta wiadomosc wraz z zalacznikami jest przeznaczona dla okreslonego adresata i moze zawierac informacje poufne. W razie przypadkowego otrzymania tej wiadomosci, prosimy o powiadomienie nadawcy oraz trwale jej usuniecie; jakiekolwiek
> przegladanie lub rozpowszechnianie jest zabronione.
> This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). If you are not the intended recipient, please contact the sender and delete all copies; any review or distribution by
> others is strictly prohibited.
>