This is an automated email from the ASF dual-hosted git repository. potiuk pushed a commit to branch 2.2.4-fix-docs in repository https://gitbox.apache.org/repos/asf/airflow-site.git
commit 7416b30b58647e1b3e51dd3c6dc56e783a1eb3bd Author: Jarek Potiuk <[email protected]> AuthorDate: Fri Mar 4 20:54:52 2022 +0100 Remove MSSQL from the published doc --- .../2.2.4/_sources/howto/set-up-database.rst.txt | 39 +--------------------- docs-archive/apache-airflow/2.2.4/changelog.html | 13 +++++--- .../2.2.4/cli-and-env-variables-ref.html | 16 ++++----- docs-archive/apache-airflow/2.2.4/howto/index.html | 1 - .../2.2.4/howto/set-up-database.html | 33 +----------------- .../_static/redoc.js | 8 ----- docs-archive/apache-airflow/2.2.4/searchindex.js | 2 +- 7 files changed, 19 insertions(+), 93 deletions(-) diff --git a/docs-archive/apache-airflow/2.2.4/_sources/howto/set-up-database.rst.txt b/docs-archive/apache-airflow/2.2.4/_sources/howto/set-up-database.rst.txt index 14051b3..cb1e944 100644 --- a/docs-archive/apache-airflow/2.2.4/_sources/howto/set-up-database.rst.txt +++ b/docs-archive/apache-airflow/2.2.4/_sources/howto/set-up-database.rst.txt @@ -27,14 +27,13 @@ The document below describes the database engine configurations, the necessary c Choosing database backend ------------------------- -If you want to take a real test drive of Airflow, you should consider setting up a database backend to **PostgreSQL**, **MySQL**, or **MSSQL**. +If you want to take a real test drive of Airflow, you should consider setting up a database backend to **PostgreSQL**, **MySQL**. By default, Airflow uses **SQLite**, which is intended for development purposes only. Airflow supports the following database engine versions, so make sure which version you have. Old versions may not support all SQL statements. * PostgreSQL: 9.6, 10, 11, 12, 13 * MySQL: 5.7, 8 -* MsSQL: 2017, 2019 * SQLite: 3.15.0+ If you plan on running more than one scheduler, you have to meet additional requirements. @@ -273,42 +272,6 @@ and setup of the SqlAlchemy connection. In addition, you also should pay particular attention to MySQL's encoding. Although the ``utf8mb4`` character set is more and more popular for MySQL (actually, ``utf8mb4`` becomes default character set in MySQL8.0), using the ``utf8mb4`` encoding requires additional setting in Airflow 2+ (See more details in `#7570 <https://github.com/apache/airflow/pull/7570>`__.). If you use ``utf8mb4`` as character set, you should also set ``sql_engine_collation_for_ids=utf8mb3_bin``. -Setting up a MsSQL Database ---------------------------- - -You need to create a database and a database user that Airflow will use to access this database. -In the example below, a database ``airflow_db`` and user with username ``airflow_user`` with password ``airflow_pass`` will be created. -Note, that in case of MsSQL, Airflow uses ``READ COMMITTED`` transaction isolation and it must have -``READ_COMMITTED_SNAPSHOT`` feature enabled, otherwise read transactions might generate deadlocks -(especially in case of backfill). Airflow will refuse to use database that has the feature turned off. -You can read more about transaction isolation and snapshot features at -`Transaction isolation level <https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql>`_ - -.. code-block:: sql - - CREATE DATABASE airflow; - ALTER DATABASE airflow SET READ_COMMITTED_SNAPSHOT ON; - CREATE LOGIN airflow_user WITH PASSWORD='airflow_pass123%'; - USE airflow; - CREATE USER airflow_user FROM LOGIN airflow_user; - GRANT ALL PRIVILEGES ON DATABASE airflow TO airflow_user; - - -We recommend using the ``mssql+pyodbc`` driver and specifying it in your SqlAlchemy connection string. - -.. code-block:: text - - mssql+pyodbc://<user>:<password>@<host>[:port]/<db>?[driver=<driver>] - - -You do not need to specify the Driver if you have default driver configured in your system. For the -Official Docker image we have ODBC driver installed, so you need to specify the ODBC driver to use: - -.. code-block:: text - - mssql+pyodbc://<user>:<password>@<host>[:port]/<db>[?driver=ODBC+Driver+17+for+SQL+Server] - - Other configuration options --------------------------- diff --git a/docs-archive/apache-airflow/2.2.4/changelog.html b/docs-archive/apache-airflow/2.2.4/changelog.html index c1316f1..37948b7 100644 --- a/docs-archive/apache-airflow/2.2.4/changelog.html +++ b/docs-archive/apache-airflow/2.2.4/changelog.html @@ -342,7 +342,7 @@ <li class="toctree-l1"><a class="reference internal" href="modules_management.html">Modules Management</a></li> <li class="toctree-l1"><a class="reference internal" href="release-process.html">Release Policies</a></li> <li class="toctree-l1 current"><a class="current reference internal" href="#">Changelog</a><ul> -<li class="toctree-l2"><a class="reference internal" href="#airflow-2-2-4-2022-02-22">Airflow 2.2.4, 2022-02-22</a><ul> +<li class="toctree-l2"><a class="reference internal" href="#airflow-2-2-4-2021-02-22">Airflow 2.2.4, 2021-02-22</a><ul> <li class="toctree-l3"><a class="reference internal" href="#bug-fixes">Bug Fixes</a></li> <li class="toctree-l3"><a class="reference internal" href="#doc-only-changes">Doc only changes</a></li> <li class="toctree-l3"><a class="reference internal" href="#misc">Misc</a></li> @@ -698,7 +698,7 @@ <li class="toctree-l1"><a class="reference internal" href="modules_management.html">Modules Management</a></li> <li class="toctree-l1"><a class="reference internal" href="release-process.html">Release Policies</a></li> <li class="toctree-l1 current"><a class="current reference internal" href="#">Changelog</a><ul> -<li class="toctree-l2"><a class="reference internal" href="#airflow-2-2-4-2022-02-22">Airflow 2.2.4, 2022-02-22</a><ul> +<li class="toctree-l2"><a class="reference internal" href="#airflow-2-2-4-2021-02-22">Airflow 2.2.4, 2021-02-22</a><ul> <li class="toctree-l3"><a class="reference internal" href="#bug-fixes">Bug Fixes</a></li> <li class="toctree-l3"><a class="reference internal" href="#doc-only-changes">Doc only changes</a></li> <li class="toctree-l3"><a class="reference internal" href="#misc">Misc</a></li> @@ -1008,8 +1008,8 @@ <div></div></blockquote> <div class="section" id="changelog"> <h1>Changelog<a class="headerlink" href="#changelog" title="Permalink to this headline">¶</a></h1> -<div class="section" id="airflow-2-2-4-2022-02-22"> -<h2>Airflow 2.2.4, 2022-02-22<a class="headerlink" href="#airflow-2-2-4-2022-02-22" title="Permalink to this headline">¶</a></h2> +<div class="section" id="airflow-2-2-4-2021-02-22"> +<h2>Airflow 2.2.4, 2021-02-22<a class="headerlink" href="#airflow-2-2-4-2021-02-22" title="Permalink to this headline">¶</a></h2> <div class="section" id="bug-fixes"> <h3>Bug Fixes<a class="headerlink" href="#bug-fixes" title="Permalink to this headline">¶</a></h3> <ul class="simple"> @@ -1038,6 +1038,7 @@ <li><p>Bump flask-appbuilder to <code class="docutils literal notranslate"><span class="pre">>=3.3.4</span></code> (#20628)</p></li> <li><p>upgrade celery to <code class="docutils literal notranslate"><span class="pre">5.2.3</span></code> (#19703)</p></li> <li><p>Bump croniter from <code class="docutils literal notranslate"><span class="pre"><1.1</span></code> to <code class="docutils literal notranslate"><span class="pre"><1.2</span></code> (#20489)</p></li> +<li><p>Lift off upper bound for MarkupSafe (#20113)</p></li> <li><p>Avoid calling <code class="docutils literal notranslate"><span class="pre">DAG.following_schedule()</span></code> for <code class="docutils literal notranslate"><span class="pre">TaskInstance.get_template_context()</span></code> (#20486)</p></li> <li><p>Fix(standalone): Remove hardcoded Webserver port (#20429)</p></li> <li><p>Remove unnecssary logging in experimental API (#20356)</p></li> @@ -1070,6 +1071,8 @@ <li><p>Add docker-compose explanation to conn localhost (#19076)</p></li> <li><p>Update CSV ingest code for tutorial (#18960)</p></li> <li><p>Adds Pendulum 1.x -> 2.x upgrade documentation (#18955)</p></li> +<li><p>Updating explicit arg example in TaskFlow API tutorial doc (#18907)</p></li> +<li><p>Adds back documentation about context usage in <a class="reference external" href="mailto:Python/%40task";>Python/<span>@</span>task</a> (#18868)</p></li> <li><p>Clean up dynamic <cite>start_date</cite> values from docs (#19607)</p></li> <li><p>Docs for multiple pool slots (#20257)</p></li> <li><p>Update upgrading.rst with detailed code example of how to resolve post-upgrade warning (#19993)</p></li> @@ -6615,7 +6618,7 @@ instead.</p> <div class="wy-menu-vertical"> <ul> <li><a class="reference internal" href="#">Changelog</a><ul> -<li><a class="reference internal" href="#airflow-2-2-4-2022-02-22">Airflow 2.2.4, 2022-02-22</a><ul> +<li><a class="reference internal" href="#airflow-2-2-4-2021-02-22">Airflow 2.2.4, 2021-02-22</a><ul> <li><a class="reference internal" href="#bug-fixes">Bug Fixes</a></li> <li><a class="reference internal" href="#doc-only-changes">Doc only changes</a></li> <li><a class="reference internal" href="#misc">Misc</a></li> diff --git a/docs-archive/apache-airflow/2.2.4/cli-and-env-variables-ref.html b/docs-archive/apache-airflow/2.2.4/cli-and-env-variables-ref.html index 24729b9..e36d997 100644 --- a/docs-archive/apache-airflow/2.2.4/cli-and-env-variables-ref.html +++ b/docs-archive/apache-airflow/2.2.4/cli-and-env-variables-ref.html @@ -1782,14 +1782,14 @@ development and testing.</p> <div class="section" id="list"> <h6>list<a class="headerlink" href="#list" title="Permalink to this headline">¶</a></h6> <p>List options for the configuration</p> -<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">config</span> <span class="nb">list</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">auto</span><span class="p">,</span><span class="n">on</span><span class="p">,</span><span class="n">off [...] +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">config</span> <span class="nb">list</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">off</span><span class="p">,</span><span class="n">auto</span><span class="p">,</span><span class="n">on [...] </pre></div> </div> <div class="section" id="Named Arguments_repeat4"> <h7>Named Arguments<a class="headerlink" href="#Named Arguments_repeat4" title="Permalink to this headline">¶</a></h7> <dl class="option-list"> <dt><kbd>--color</kbd></dt> -<dd><p>Possible choices: auto, on, off</p> +<dd><p>Possible choices: off, auto, on</p> <p>Do emit colored output (default: auto)</p> <p>Default: “auto”</p> </dd> @@ -1870,7 +1870,7 @@ development and testing.</p> <div class="section" id="delete"> <h6>delete<a class="headerlink" href="#delete" title="Permalink to this headline">¶</a></h6> <p>Delete a connection</p> -<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">connections</span> <span class="n">delete</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">auto</span><span class="p">,</span><span class="n">on</span><span class="p">,</span><span class=" [...] +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">connections</span> <span class="n">delete</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">off</span><span class="p">,</span><span class="n">auto</span><span class="p">,</span><span class= [...] </pre></div> </div> <div class="section" id="Positional Arguments_repeat6"> @@ -1885,7 +1885,7 @@ development and testing.</p> <h7>Named Arguments<a class="headerlink" href="#Named Arguments_repeat6" title="Permalink to this headline">¶</a></h7> <dl class="option-list"> <dt><kbd>--color</kbd></dt> -<dd><p>Possible choices: auto, on, off</p> +<dd><p>Possible choices: off, auto, on</p> <p>Do emit colored output (default: auto)</p> <p>Default: “auto”</p> </dd> @@ -1926,7 +1926,7 @@ airflow connections export /tmp/connections –format json</p> <div class="section" id="get"> <h6>get<a class="headerlink" href="#get" title="Permalink to this headline">¶</a></h6> <p>Get a connection</p> -<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">connections</span> <span class="n">get</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">auto</span><span class="p">,</span><span class="n">on</span><span class="p">,</span><span class="n"> [...] +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">connections</span> <span class="n">get</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">off</span><span class="p">,</span><span class="n">auto</span><span class="p">,</span><span class="n" [...] <span class="p">[</span><span class="o">-</span><span class="n">o</span> <span class="n">table</span><span class="p">,</span> <span class="n">json</span><span class="p">,</span> <span class="n">yaml</span><span class="p">,</span> <span class="n">plain</span><span class="p">]</span> <span class="p">[</span><span class="o">-</span><span class="n">v</span><span class="p">]</span> <span class="n">conn_id</span> </pre></div> @@ -1943,7 +1943,7 @@ airflow connections export /tmp/connections –format json</p> <h7>Named Arguments<a class="headerlink" href="#Named Arguments_repeat8" title="Permalink to this headline">¶</a></h7> <dl class="option-list"> <dt><kbd>--color</kbd></dt> -<dd><p>Possible choices: auto, on, off</p> +<dd><p>Possible choices: off, auto, on</p> <p>Do emit colored output (default: auto)</p> <p>Default: “auto”</p> </dd> @@ -3010,7 +3010,7 @@ To check if the local scheduler is still working properly, run:</p> <div class="section" id="get_repeat2"> <h6>get<a class="headerlink" href="#get_repeat2" title="Permalink to this headline">¶</a></h6> <p>Get detailed information about a provider</p> -<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">providers</span> <span class="n">get</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">auto</span><span class="p">,</span><span class="n">on</span><span class="p">,</span><span class="n">of [...] +<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">airflow</span> <span class="n">providers</span> <span class="n">get</span> <span class="p">[</span><span class="o">-</span><span class="n">h</span><span class="p">]</span> <span class="p">[</span><span class="o">--</span><span class="n">color</span> <span class="p">{</span><span class="n">off</span><span class="p">,</span><span class="n">auto</span><span class="p">,</span><span class="n">o [...] <span class="p">[</span><span class="o">-</span><span class="n">o</span> <span class="n">table</span><span class="p">,</span> <span class="n">json</span><span class="p">,</span> <span class="n">yaml</span><span class="p">,</span> <span class="n">plain</span><span class="p">]</span> <span class="p">[</span><span class="o">-</span><span class="n">v</span><span class="p">]</span> <span class="n">provider_name</span> </pre></div> @@ -3027,7 +3027,7 @@ To check if the local scheduler is still working properly, run:</p> <h7>Named Arguments<a class="headerlink" href="#Named Arguments_repeat38" title="Permalink to this headline">¶</a></h7> <dl class="option-list"> <dt><kbd>--color</kbd></dt> -<dd><p>Possible choices: auto, on, off</p> +<dd><p>Possible choices: off, auto, on</p> <p>Do emit colored output (default: auto)</p> <p>Default: “auto”</p> </dd> diff --git a/docs-archive/apache-airflow/2.2.4/howto/index.html b/docs-archive/apache-airflow/2.2.4/howto/index.html index 1fe87b9..2c90eb3 100644 --- a/docs-archive/apache-airflow/2.2.4/howto/index.html +++ b/docs-archive/apache-airflow/2.2.4/howto/index.html @@ -680,7 +680,6 @@ configuring an Airflow environment.</p> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#setting-up-a-sqlite-database">Setting up a SQLite Database</a></li> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#setting-up-a-postgresql-database">Setting up a PostgreSQL Database</a></li> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#setting-up-a-mysql-database">Setting up a MySQL Database</a></li> -<li class="toctree-l2"><a class="reference internal" href="set-up-database.html#setting-up-a-mssql-database">Setting up a MsSQL Database</a></li> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#other-configuration-options">Other configuration options</a></li> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#initialize-the-database">Initialize the database</a></li> <li class="toctree-l2"><a class="reference internal" href="set-up-database.html#what-s-next">What’s next?</a></li> diff --git a/docs-archive/apache-airflow/2.2.4/howto/set-up-database.html b/docs-archive/apache-airflow/2.2.4/howto/set-up-database.html index 443e40d..3457a75 100644 --- a/docs-archive/apache-airflow/2.2.4/howto/set-up-database.html +++ b/docs-archive/apache-airflow/2.2.4/howto/set-up-database.html @@ -334,7 +334,6 @@ <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-sqlite-database">Setting up a SQLite Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-postgresql-database">Setting up a PostgreSQL Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-mysql-database">Setting up a MySQL Database</a></li> -<li class="toctree-l3"><a class="reference internal" href="#setting-up-a-mssql-database">Setting up a MsSQL Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#other-configuration-options">Other configuration options</a></li> <li class="toctree-l3"><a class="reference internal" href="#initialize-the-database">Initialize the database</a></li> <li class="toctree-l3"><a class="reference internal" href="#what-s-next">What’s next?</a></li> @@ -530,7 +529,6 @@ <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-sqlite-database">Setting up a SQLite Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-postgresql-database">Setting up a PostgreSQL Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#setting-up-a-mysql-database">Setting up a MySQL Database</a></li> -<li class="toctree-l3"><a class="reference internal" href="#setting-up-a-mssql-database">Setting up a MsSQL Database</a></li> <li class="toctree-l3"><a class="reference internal" href="#other-configuration-options">Other configuration options</a></li> <li class="toctree-l3"><a class="reference internal" href="#initialize-the-database">Initialize the database</a></li> <li class="toctree-l3"><a class="reference internal" href="#what-s-next">What’s next?</a></li> @@ -694,13 +692,12 @@ <p>The document below describes the database engine configurations, the necessary changes to their configuration to be used with Airflow, as well as changes to the Airflow configurations to connect to these databases.</p> <div class="section" id="choosing-database-backend"> <h2>Choosing database backend<a class="headerlink" href="#choosing-database-backend" title="Permalink to this headline">¶</a></h2> -<p>If you want to take a real test drive of Airflow, you should consider setting up a database backend to <strong>PostgreSQL</strong>, <strong>MySQL</strong>, or <strong>MSSQL</strong>. +<p>If you want to take a real test drive of Airflow, you should consider setting up a database backend to <strong>PostgreSQL</strong>, <strong>MySQL</strong>. By default, Airflow uses <strong>SQLite</strong>, which is intended for development purposes only.</p> <p>Airflow supports the following database engine versions, so make sure which version you have. Old versions may not support all SQL statements.</p> <ul class="simple"> <li><p>PostgreSQL: 9.6, 10, 11, 12, 13</p></li> <li><p>MySQL: 5.7, 8</p></li> -<li><p>MsSQL: 2017, 2019</p></li> <li><p>SQLite: 3.15.0+</p></li> </ul> <p>If you plan on running more than one scheduler, you have to meet additional requirements. @@ -891,33 +888,6 @@ without any cert options provided.</p> and setup of the SqlAlchemy connection.</p> <p>In addition, you also should pay particular attention to MySQL’s encoding. Although the <code class="docutils literal notranslate"><span class="pre">utf8mb4</span></code> character set is more and more popular for MySQL (actually, <code class="docutils literal notranslate"><span class="pre">utf8mb4</span></code> becomes default character set in MySQL8.0), using the <code class="docutils literal notranslate"><span class="pre">utf8mb4</span></code> encoding requires additional setting i [...] </div> -<div class="section" id="setting-up-a-mssql-database"> -<h2>Setting up a MsSQL Database<a class="headerlink" href="#setting-up-a-mssql-database" title="Permalink to this headline">¶</a></h2> -<p>You need to create a database and a database user that Airflow will use to access this database. -In the example below, a database <code class="docutils literal notranslate"><span class="pre">airflow_db</span></code> and user with username <code class="docutils literal notranslate"><span class="pre">airflow_user</span></code> with password <code class="docutils literal notranslate"><span class="pre">airflow_pass</span></code> will be created. -Note, that in case of MsSQL, Airflow uses <code class="docutils literal notranslate"><span class="pre">READ</span> <span class="pre">COMMITTED</span></code> transaction isolation and it must have -<code class="docutils literal notranslate"><span class="pre">READ_COMMITTED_SNAPSHOT</span></code> feature enabled, otherwise read transactions might generate deadlocks -(especially in case of backfill). Airflow will refuse to use database that has the feature turned off. -You can read more about transaction isolation and snapshot features at -<a class="reference external" href="https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql";>Transaction isolation level</a></p> -<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">DATABASE</span><span class="w"> </span><span class="n">airflow</span><span class="p">;</span><span class="w"></span> -<span class="k">ALTER</span><span class="w"> </span><span class="k">DATABASE</span><span class="w"> </span><span class="n">airflow</span><span class="w"> </span><span class="k">SET</span><span class="w"> </span><span class="n">READ_COMMITTED_SNAPSHOT</span><span class="w"> </span><span class="k">ON</span><span class="p">;</span><span class="w"></span> -<span class="k">CREATE</span><span class="w"> </span><span class="n">LOGIN</span><span class="w"> </span><span class="n">airflow_user</span><span class="w"> </span><span class="k">WITH</span><span class="w"> </span><span class="n">PASSWORD</span><span class="o">=</span><span class="s1">'airflow_pass123%'</span><span class="p">;</span><span class="w"></span> -<span class="n">USE</span><span class="w"> </span><span class="n">airflow</span><span class="p">;</span><span class="w"></span> -<span class="k">CREATE</span><span class="w"> </span><span class="k">USER</span><span class="w"> </span><span class="n">airflow_user</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">LOGIN</span><span class="w"> </span><span class="n">airflow_user</span><span class="p">;</span><span class="w"></span> -<span class="k">GRANT</span><span class="w"> </span><span class="k">ALL</span><span class="w"> </span><span class="k">PRIVILEGES</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="k">DATABASE</span><span class="w"> </span><span class="n">airflow</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="n">airflow_user</span><span class="p">;</span><span class="w"></span> -</pre></div> -</div> -<p>We recommend using the <code class="docutils literal notranslate"><span class="pre">mssql+pyodbc</span></code> driver and specifying it in your SqlAlchemy connection string.</p> -<div class="highlight-text notranslate"><div class="highlight"><pre><span></span>mssql+pyodbc://<user>:<password>@<host>[:port]/<db>?[driver=<driver>] -</pre></div> -</div> -<p>You do not need to specify the Driver if you have default driver configured in your system. For the -Official Docker image we have ODBC driver installed, so you need to specify the ODBC driver to use:</p> -<div class="highlight-text notranslate"><div class="highlight"><pre><span></span>mssql+pyodbc://<user>:<password>@<host>[:port]/<db>[?driver=ODBC+Driver+17+for+SQL+Server] -</pre></div> -</div> -</div> <div class="section" id="other-configuration-options"> <h2>Other configuration options<a class="headerlink" href="#other-configuration-options" title="Permalink to this headline">¶</a></h2> <p>There are more configuration options for configuring SQLAlchemy behavior. For details, see <a class="reference internal" href="../configurations-ref.html#config-core"><span class="std std-ref">reference documentation</span></a> for <code class="docutils literal notranslate"><span class="pre">sqlalchemy_*</span></code> option in <code class="docutils literal notranslate"><span class="pre">[core]</span></code> section.</p> @@ -1017,7 +987,6 @@ configuring a different <a class="reference internal" href="../executor/index.ht <li><a class="reference internal" href="#setting-up-a-sqlite-database">Setting up a SQLite Database</a></li> <li><a class="reference internal" href="#setting-up-a-postgresql-database">Setting up a PostgreSQL Database</a></li> <li><a class="reference internal" href="#setting-up-a-mysql-database">Setting up a MySQL Database</a></li> -<li><a class="reference internal" href="#setting-up-a-mssql-database">Setting up a MsSQL Database</a></li> <li><a class="reference internal" href="#other-configuration-options">Other configuration options</a></li> <li><a class="reference internal" href="#initialize-the-database">Initialize the database</a></li> <li><a class="reference internal" href="#what-s-next">What’s next?</a></li> diff --git a/docs-archive/apache-airflow/2.2.4/output-spelling-results-apache-airflow/_static/redoc.js b/docs-archive/apache-airflow/2.2.4/output-spelling-results-apache-airflow/_static/redoc.js deleted file mode 100644 index 4b631fa..0000000 --- a/docs-archive/apache-airflow/2.2.4/output-spelling-results-apache-airflow/_static/redoc.js +++ /dev/null @@ -1,8 +0,0 @@ -/*! - * ReDoc - OpenAPI/Swagger-generated API Reference Documentation - * ------------------------------------------------------------- - * Version: "1.21.2" - * Repo: https://github.com/Rebilly/ReDoc - */ -!function(e,t){"object"==typeof exports&&"object"==typeof module?module.exports=t(function(){try{return require("esprima")}catch(e){}}(),function(){try{return require("jquery")}catch(e){}}()):"function"==typeof define&&define.amd?define("Redoc",["esprima","jquery"],t):"object"==typeof exports?exports.Redoc=t(function(){try{return require("esprima")}catch(e){}}(),function(){try{return require("jquery")}catch(e){}}()):e.Redoc=t(e.esprima,e.jquery)}("undefined"!=typeof self?self:this,functi [...] -//# sourceMappingURL=redoc.min.map \ No newline at end of file diff --git a/docs-archive/apache-airflow/2.2.4/searchindex.js b/docs-archive/apache-airflow/2.2.4/searchindex.js index 16e7cca..3e8ca31 100644 --- a/docs-archive/apache-airflow/2.2.4/searchindex.js +++ b/docs-archive/apache-airflow/2.2.4/searchindex.js @@ -1 +1 @@ -Search.setIndex({docnames:["_api/airflow/exceptions/index","_api/airflow/executors/base_executor/index","_api/airflow/executors/celery_executor/index","_api/airflow/executors/celery_kubernetes_executor/index","_api/airflow/executors/dask_executor/index","_api/airflow/executors/debug_executor/index","_api/airflow/executors/executor_constants/index","_api/airflow/executors/executor_loader/index","_api/airflow/executors/index","_api/airflow/executors/kubernetes_executor/index","_api/airflow [...] \ No newline at end of file +Search.setIndex({docnames:["_api/airflow/exceptions/index","_api/airflow/executors/base_executor/index","_api/airflow/executors/celery_executor/index","_api/airflow/executors/celery_kubernetes_executor/index","_api/airflow/executors/dask_executor/index","_api/airflow/executors/debug_executor/index","_api/airflow/executors/executor_constants/index","_api/airflow/executors/executor_loader/index","_api/airflow/executors/index","_api/airflow/executors/kubernetes_executor/index","_api/airflow [...] \ No newline at end of file
