id stringlengths 15 25 | source stringclasses 1
value | chunk_index int64 0 393k | token_count int32 449 512 | content stringlengths 203 7.95k |
|---|---|---|---|---|
combine_chunk_300 | combine.txt | 300 | 512 | 2.11.0``
``apache-airflow-providers-common-compat`` ``>=1.10.1``
``python-arango`` ``>=7.3.2``
========================================== ==================
The changelog for the provider package can be found in the
`changelog <https://airflow.apache.org/docs/apache-airflow-providers-arango... |
combine_chunk_301 | combine.txt | 301 | 512 | hidden:
:maxdepth: 1
:caption: Commits
Detailed list of commits <commits>
apache-airflow-providers-arangodb package
------------------------------------------------------
`ArangoDB <https://www.arangodb.com/>`__
Release: 2.10.1
Provider package
----------------
This package is for the ``arangodb`` p... |
combine_chunk_302 | combine.txt | 302 | 512 | .sha512>`__)
<|file|>airflow/providers/arangodb/docs/operators/index.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 fi... |
combine_chunk_303 | combine.txt | 303 | 512 | _operator_template_file_arangodb]
:end-before: [END howto_aql_operator_template_file_arangodb]
Sensors
========
Use the :class:`~airflow.providers.arangodb.sensors.arangodb.AQLSensor` to wait for a document or collection using
AQL query in `ArangoDB <https://www.arangodb.com/>`__.
An example of waiting for a doc... |
combine_chunk_304 | combine.txt | 304 | 512 | INDER OF THE FILE IS AUTOMATICALLY GENERATED. IT WILL BE OVERWRITTEN!
Package apache-airflow-providers-arangodb
------------------------------------------------------
`ArangoDB <https://www.arangodb.com/>`__
This is detailed commit list of changes for versions provider package: ``arangodb``.
For high-level changelo... |
combine_chunk_305 | combine.txt | 305 | 512 | DB Connection
====================
The ArangoDB connection provides credentials for accessing the ArangoDB.
Configuring the Connection
--------------------------
ArangoDB Host (required)
Specify ArangoDB Host URL or comma separated list of URLs (coordinators in a cluster),
e.g. ``http://127.0.0.1:8529`` or ``h... |
combine_chunk_306 | combine.txt | 306 | 512 | 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! THIS FILE IS AUTOMATICALLY GENERATED ... |
combine_chunk_307 | combine.txt | 307 | 512 | ==========
Optional dependencies
----------------------
========== ===================================
Extra Dependencies
========== ===================================
``boto3`` ``boto3>=1.42.93``
``google`` ``apache-airflow-providers-google``
========== ===================================
The changelo... |
combine_chunk_308 | combine.txt | 308 | 512 | :maxdepth: 1
:caption: Commits
Detailed list of commits <commits>
apache-airflow-providers-hashicorp package
------------------------------------------------------
Hashicorp including `Hashicorp Vault <https://www.vaultproject.io/>`__
Release: 4.8.4
Provider package
----------------
This package is ... |
combine_chunk_309 | combine.txt | 309 | 512 | flow-providers-hashicorp 4.8.4 sdist package <https://downloads.apache.org/airflow/providers/apache_airflow_providers_hashicorp-4.8.4.tar.gz>`_ (`asc <https://downloads.apache.org/airflow/providers/apache_airflow_providers_hashicorp-4.8.4.tar.gz.asc>`__, `sha512 <https://downloads.apache.org/airflow/providers/apache_ai... |
combine_chunk_310 | combine.txt | 310 | 512 | -providers-hashicorp
------------------------------------------------------
Hashicorp including `Hashicorp Vault <https://www.vaultproject.io/>`__
This is detailed commit list of changes for versions provider package: ``hashicorp``.
For high-level changelog, see :doc:`package information including changelog <index>`... |
combine_chunk_311 | combine.txt | 311 | 512 | IDs
----------------------
Hooks related to Vault use ``vault_default`` by default.
Configuring the Connection
--------------------------
Host (required)
The host to connect to.
Schema
Vault mount point. Default value is ``secret``
Login
Required when used ``ldap`` or ``userpass`` auth types, and you c... |
combine_chunk_312 | combine.txt | 312 | 512 | : Host for radius (for ``radius`` auth_type).
``radius_port``: Port for radius (for ``radius`` auth_type).
``use_tls``: Whether to use https or http protocol for the connection.
Example "extras" field:
.. code-block:: JSON
{
"auth_type": "kubernetes",
"kubernetes_role": "vault... |
combine_chunk_313 | combine.txt | 313 | 512 | To enable Hashicorp vault to retrieve Airflow connection/variable, specify :py:class:`~airflow.providers.hashicorp.secrets.vault.VaultBackend`
as the ``backend`` in ``[secrets]`` section of ``airflow.cfg``.
Here is a sample configuration:
.. code-block:: ini
[secrets]
backend = airflow.providers.hashicorp.s... |
combine_chunk_314 | combine.txt | 314 | 512 | paths
"""""""""""""""""""""""""""""""""""""""""
``connections_path``, ``variables_path``, and ``config_path`` can take a list of paths. Each path is tried in order, and
the first path where a secret is found returns. This can be used as a fallback mechanism for e.g. teams, environments,
etc.:
.. code-block:: ini
... |
combine_chunk_315 | combine.txt | 315 | 512 | get connection.
Storing and Retrieving Connections using Connection class representation
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
If you have set ``connections_path`` as ``connections`` and ``mount_point`` as ``airflow``, then for a connection id of
``smtp_default``, you would want to... |
combine_chunk_316 | combine.txt | 316 | 512 | """""""""""""""""""""
If you have set ``config_path`` as ``config`` and ``mount_point`` as ``airflow``, then for config ``sql_alchemy_conn_secret`` with
``sql_alchemy_conn_value`` as value, you would want to store your secret as:
.. code-block:: bash
vault kv put airflow/config/sql_alchemy_conn_value value=postg... |
combine_chunk_317 | combine.txt | 317 | 512 | /services/sts/client/assume_role.html
.. code-block:: ini
[secrets]
backend = airflow.providers.hashicorp.secrets.vault.VaultBackend
backend_kwargs = {"connections_path": "airflow-connections", "variables_path": null, "mount_point": "airflow", "url": "http://127.0.0.1:8200", "auth_type": "aws_iam", "assum... |
combine_chunk_318 | combine.txt | 318 | 512 | it with ``auth_mount_point``.
Using multiple mount points
"""""""""""""""""""""""""""
You can use multiple mount points to store your secrets. For example, you might want to store the Airflow instance configurations
in one Vault KV engine only accessible by your Airflow deployment tools, while storing the variables ... |
combine_chunk_319 | combine.txt | 319 | 512 | 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 ... |
combine_chunk_320 | combine.txt | 320 | 512 | providers in order to use them.
You can install such cross-provider dependencies when installing from PyPI. For example:
.. code-block:: bash
pip install apache-airflow-providers-sftp[openlineage]
============================================================================================================== =... |
combine_chunk_321 | combine.txt | 321 | 512 | API <_api/airflow/providers/sftp/index>
.. toctree::
:hidden:
:maxdepth: 1
:caption: Resources
PyPI Repository <https://pypi.org/project/apache-airflow-providers-sftp/>
Installing from sources <installing-providers-from-sources>
.. toctree::
:hidden:
:maxdepth: 1
:caption: System tes... |
combine_chunk_322 | combine.txt | 322 | 512 | pip install apache-airflow-providers-sftp[openlineage]
============================================================================================================== ===============
Dependent package Extra
=============... |
combine_chunk_323 | combine.txt | 323 | 512 | 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 L... |
combine_chunk_324 | combine.txt | 324 | 512 | glob:
*
<|file|>airflow/providers/sftp/docs/filesystems/sftp.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
... |
combine_chunk_325 | combine.txt | 325 | 512 | 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 ... |
combine_chunk_326 | combine.txt | 326 | 512 | )
Specify the sftp username for the remote machine.
Password (optional)
Specify the sftp password for the remote machine.
Port (optional)
Specify the SSH port of the remote machine
Host (optional)
Specify the Hostname or IP of the remote machine
Extra (optional)
Specify the extra parameters (as ... |
combine_chunk_327 | combine.txt | 327 | 512 | if the public key of the endpoint matches this value.
* ``disabled_algorithms`` - A dictionary mapping algorithm type to an iterable of algorithm identifiers, which will be disabled for the lifetime of the transport.
* ``ciphers`` - A list of ciphers to use in order of preference.
Example "extras" field using... |
combine_chunk_328 | combine.txt | 328 | 512 | either a specific file or files with a specific pattern in a server using SFTP protocol.
To get more information about this sensor visit :class:`~airflow.providers.sftp.sensors.sftp.SFTPSensor`
.. exampleinclude:: /../../sftp/tests/system/sftp/example_sftp_sensor.py
:language: python
:dedent: 4
:start-aft... |
combine_chunk_329 | combine.txt | 329 | 512 | ]
<|file|>airflow/providers/sftp/docs/security.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 th... |
combine_chunk_330 | combine.txt | 330 | 512 | in ``airflow.providers.common.messaging`` python package.
You can find package information and changelog for the provider
in the `documentation <https://airflow.apache.org/docs/apache-airflow-providers-common-messaging/2.1.2/>`_.
Installation
------------
You can install this package on top of an existing Airflow i... |
combine_chunk_331 | combine.txt | 331 | 512 | .. toctree::
:hidden:
:maxdepth: 1
:caption: Guides
Triggers <triggers>
Supported providers <providers>
.. toctree::
:hidden:
:maxdepth: 1
:caption: References
Python API <_api/airflow/providers/common/messaging/index>
Base Provider <_api/airflow/providers/common/messaging/pro... |
combine_chunk_332 | combine.txt | 332 | 512 | 0``
================ ================================================
Downloading official packages
-----------------------------
You can download officially released packages and verify their checksums and signatures from the
`Official Apache Download site <https://downloads.apache.org/airflow/providers/>`_
* `The... |
combine_chunk_333 | combine.txt | 333 | 512 | .common.messaging.triggers.msg_queue.MessageQueueTrigger` to wait for a message in a
queue. Mandatory parameters of the trigger are:
- ``scheme`` - the queue scheme (e.g., 'kafka', 'redis+pubsub', 'sqs') you are using
Additional parameters can be provided depending on the queue provider. Connections needs to be provi... |
combine_chunk_334 | combine.txt | 334 | 512 | Process the payload as needed
print(f"Received message: {payload}")
chain(process_message())
The ``triggering_asset_events`` parameter contains the events that triggered the DAG run, indexed by asset.
Each event includes an ``extra`` dictionary where the message payload is stored under the ``... |
combine_chunk_335 | combine.txt | 335 | 512 | 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 lang... |
combine_chunk_336 | combine.txt | 336 | 512 | 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:/... |
combine_chunk_337 | combine.txt | 337 | 512 | .org/docs/apache-airflow-providers-common-compat/1.23.1/>`_.
Installation
------------
You can install this package on top of an existing Airflow installation (see ``Requirements`` below
for the minimum Airflow version supported) via
``pip install apache-airflow-providers-common-compat``
The package supports the fol... |
combine_chunk_338 | combine.txt | 338 | 512 | 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 Lice... |
combine_chunk_339 | combine.txt | 339 | 512 | ======================================
Optional 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 distributions in order to use them.
You can install... |
combine_chunk_340 | combine.txt | 340 | 512 | |file|>airflow/providers/common/compat/docs/commits.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 und... |
combine_chunk_341 | combine.txt | 341 | 512 | , either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
.. include:: /../../../../devel-common/src/sphinx_exts/includes/installing-providers-from-sources.rst
<|file|>airflow/providers/common/compat/docs/security.rst
.. Licensed to the A... |
combine_chunk_342 | combine.txt | 342 | 512 | flow-providers-common-io``
Release: ``1.11.1``
Common IO Provider
Provider package
----------------
This is a provider package for ``common.io`` provider. All classes for this provider package
are in ``airflow.providers.common.io`` python package.
You can find package information and changelog for the provider
i... |
combine_chunk_343 | combine.txt | 343 | 512 | 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... |
combine_chunk_344 | combine.txt | 344 | 512 | hidden:
:maxdepth: 1
:caption: System tests
System Tests <_api/tests/system/common/io/index>
.. toctree::
:hidden:
:maxdepth: 1
:caption: Resources
Example Dags <https://github.com/apache/airflow/tree/providers-common-io/|version|/providers/common/io/tests/system/common/io>
PyPI Repos... |
combine_chunk_345 | combine.txt | 345 | 512 | them when installing from PyPI. For example:
.. code-block:: bash
pip install apache-airflow-providers-common-io[openlineage]
=============== ========================================
Extra Dependencies
=============== ========================================
``openlineage`` ``apache-airflow-provi... |
combine_chunk_346 | combine.txt | 346 | 512 | governing permissions and limitations
under the License.
.. _howto/transfer:io:
Transferring a File
===================
The IO Provider package operators allow you to transfer files between various
locations, like local filesystem, S3, etc.
Default Connection ID
~~~~~~~~~~~~~~~~~~~~~
IO Operators under this p... |
combine_chunk_347 | combine.txt | 347 | 512 | 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 CO... |
combine_chunk_348 | combine.txt | 348 | 512 |
``assets/<asset_identifier>/<key>`` beneath the configured base path.
By default (``state_store_objectstorage_threshold = 0``) all serialized values are offloaded to object storage.
Set ``state_store_objectstorage_threshold`` to a positive number of bytes to only offload values whose
serialized size meets or exceeds ... |
combine_chunk_349 | combine.txt | 349 | 512 | 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 ... |
combine_chunk_350 | combine.txt | 350 | 512 | 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 o... |
combine_chunk_351 | combine.txt | 351 | 512 | as it's the same as file show above, see the `fsspec <https://github.com/fsspec/filesystem_spec/blob/f30bc759f30327dfb499f37e967648f175750fac/fsspec/implementations/local.py#L30>`_::
[core]
xcom_backend = airflow.providers.common.io.xcom.backend.XComObjectStorageBackend
[common.io]
xcom_objec... |
combine_chunk_352 | combine.txt | 352 | 512 | WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
Package ``apache-airflow-providers-common-dataquality``
Release: ``0.1.0``
Common Data Quality Provider
Provider package
----------------
... |
combine_chunk_353 | combine.txt | 353 | 512 | : 1
:caption: Resources
PyPI Repository <https://pypi.org/project/apache-airflow-providers-common-dataquality/>
Installing from sources <installing-providers-from-sources>
.. THE REMAINDER OF THE FILE IS AUTOMATICALLY GENERATED. IT WILL BE OVERWRITTEN AT RELEASE TIME!
.. toctree::
:hidden:
:maxd... |
combine_chunk_354 | combine.txt | 354 | 512 | <https://downloads.apache.org/airflow/providers/apache_airflow_providers_common_dataquality-0.1.0-py3-none-any.whl.sha512>`__)
<|file|>airflow/providers/common/dataquality/docs/commits.rst
.. Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
... |
combine_chunk_355 | combine.txt | 355 | 512 | 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.
.. include:: /../../../../devel-common/sr... |
combine_chunk_356 | combine.txt | 356 | 512 | _README_TEMPLATE.rst.jinja2`` IN the ``dev/breeze/src/airflow_breeze/templates`` DIRECTORY
Package ``apache-airflow-providers-common-sql``
Release: ``3.0.0``
`Common SQL Provider <https://en.wikipedia.org/wiki/SQL>`__
Provider package
----------------
This is a provider package for ``common.sql`` provider. All c... |
combine_chunk_357 | combine.txt | 357 | 512 | Optional dependencies
----------------------
================== =======================================================================================================================================================================
Extra Dependencies
================== =================================... |
combine_chunk_358 | combine.txt | 358 | 512 | the `common.sql` provider, and any updates in the API or behaviour of it, might potentially
break those released providers.
Therefore, we should keep an extra care when changing the APIs.
The approach we take is similar to one that has been applied by Android OS team to keep their API in check,
and it is based on st... |
combine_chunk_359 | combine.txt | 359 | 512 | MyPy automatically checks if only the methods available in the stubs are used. This gives enough protection
for most "static" usages of the `common.sql` provider by any other provider.
Of course, this is never 100% fool-proof, due to the dynamic Python behaviours and due to possible internal
changes in behaviours of t... |
combine_chunk_360 | combine.txt | 360 | 512 | flow/providers/common/sql/doc/adr/0003-introduce-notion-of-dialects-in-dbapihook.md
<!--
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... |
combine_chunk_361 | combine.txt | 361 | 512 | always be possible to use the replace
into (e.g. merge into) functionality as that won't be tied to a specific implementation with a Hook an thus the
connection type.
## Consequences
The consequence of this decision is that from now on database specific implementations should be done within the
dialect for that dat... |
combine_chunk_362 | combine.txt | 362 | 512 | . For a lightweight ADR toolset, see Nat Pryce's [adr-tools](https://github.com/npryce/adr-tools).
<|file|>airflow/providers/common/sql/src/airflow/providers/common/sql/doc/adr/0002-return-common-data-structure-from-dbapihook-derived-hooks.md
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more co... |
combine_chunk_363 | combine.txt | 363 | 512 | or even custom objects and
there are no guarantees that the data returned by the DBAPI interface is directly serializable.
Not having a common standard format made it difficult to implement planned open-lineage column-level
integration with the database Operators and - in later stage Hooks.
## Decision
We decided t... |
combine_chunk_364 | combine.txt | 364 | 512 | statements and it's up to the implementation
of the hook to split the statements and execute them separately.
* None - in case the run method is used to execute a query that does not return any rows (e.g. `INSERT`)
Additionally, it has been agreed to that description returned by the `run` method should be stored in... |
combine_chunk_365 | combine.txt | 365 | 512 | to perform various checks (declarative) on the database and return success/failure
based on the checks performed
* ``SQLValueCheckOperator`` - to perform various checks (declarative) on values in the database and
return matching rows
* ``SQLIntervalCheckOperator`` - to perform various checks (declarative) on inter... |
combine_chunk_366 | combine.txt | 366 | 512 | :hidden:
:maxdepth: 1
:caption: Basics
Home <self>
Changelog <changelog>
Security <security>
.. toctree::
:hidden:
:maxdepth: 1
:caption: Guides
Connecting to SQL Databases <connections>
Operators <operators>
.. toctree::
:hidden:
:maxdepth: 1
:caption: Refere... |
combine_chunk_367 | combine.txt | 367 | 512 | ``>=0.5.1``
``more-itertools`` ``>=9.0.0``
``methodtools`` ``>=0.4.7``
========================================== ==================
Optional cross provider package dependencies
--------------------------------------------
Those are... |
combine_chunk_368 | combine.txt | 368 | 512 | == =======================================================================================================================================================================
Downloading official packages
-----------------------------
You can download officially released packages and verify their checksums and signature... |
combine_chunk_369 | combine.txt | 369 | 512 | inja2` IN the `dev/breeze/src/airflow_breeze/templates` DIRECTORY
.. THE REMAINDER OF THE FILE IS AUTOMATICALLY GENERATED. IT WILL BE OVERWRITTEN!
Package apache-airflow-providers-common-sql
------------------------------------------------------
`Common SQL Provider <https://en.wikipedia.org/wiki/SQL>`__
This is ... |
combine_chunk_370 | combine.txt | 370 | 512 |
under the License.
SQL Dialects
=============
The :class:`~airflow.providers.common.sql.dialects.dialect.Dialect` offers an abstraction layer between the
:class:`~airflow.providers.common.sql.hooks.sql.DbApiHook` implementation and the database. For some database multiple
connection types are available, like na... |
combine_chunk_371 | combine.txt | 371 | 512 | ssql.MsSqlDialect` specialized for Microsoft SQL Server;
- ``postgresql`` :class:`~airflow.providers.postgres.dialects.postgres.PostgresDialect` specialized for PostgreSQL;
The dialect is derived from the connection URI. ODBC and JDBC connections have no database in their connection type, so
set the ``sqlalchemy_schem... |
combine_chunk_372 | combine.txt | 372 | 512 | be applied to the cursor. If it's ``None`` results won't returned (default: fetch_all_handler).
- ``split_statements`` (optional) if split single SQL string into statements and run separately (default: False).
- ``return_last`` (optional) depends ``split_statements`` and if it's ``True`` this parameter is used to retu... |
combine_chunk_373 | combine.txt | 373 | 512 | 0.01},
}
}
Where col_name is the name of the column to run checks on, and each entry in its dictionary is a check.
The valid checks are:
- null_check: checks the number of NULL values in the column
- distinct_check: checks the COUNT of values in the column that are distinct
- unique_check: checks ... |
combine_chunk_374 | combine.txt | 374 | 512 | column_sum_check": {
"check_statement": "col_a + col_b < col_c",
"partition_clause": "col_a IS NOT NULL",
},
},
)
The first set of keys are the check names, which are referenced in the templated query the operator builds.
A dictionary key unde... |
combine_chunk_375 | combine.txt | 375 | 512 | thresholds.
Both thresholds can either be a numeric value or another SQL query that evaluates to a numeric value.
This operator requires a connection ID, along with the SQL query to execute, and allows optional specification of a database, if the one from the connection_id should be overridden.
The parameters are:
- `... |
combine_chunk_376 | combine.txt | 376 | 512 | ``postoperator`` (optional) - SQL statement or list of statements to execute after inserting data (templated).
- ``hook_params`` (optional) - dictionary of additional parameters passed to the underlying hook.
- ``insert_args`` (optional) - dictionary of additional arguments passed to the hook's ``insert_rows`` method,... |
combine_chunk_377 | combine.txt | 377 | 512 | :language: python
:dedent: 4
:start-after: [START howto_operator_generic_transfer]
:end-before: [END howto_operator_generic_transfer]
.. _howto/sensor:SqlSensor:
Wait for a SQL condition
~~~~~~~~~~~~~~~~~~~~~~~~
Use the :class:`~airflow.providers.common.sql.sensors.sql.SqlSensor` to wait until a query r... |
combine_chunk_378 | combine.txt | 378 | 512 | ``, because the triggerer would not run that code;
- it runs on Airflow 3 before 3.2.2, whose triggerer cannot safely look up connections from the thread
that runs the query. Deferring works on Airflow 2.11 and on 3.2.2 and later;
- on Airflow 2, ``parameters`` holds values other than strings, numbers, booleans and `... |
combine_chunk_379 | combine.txt | 379 | 512 | `` (DataFusionEngine, optional): Query engine to use. Default is "datafusion". Currently, only "datafusion" is supported.
* ``result_output_format`` (str, optional): Output format for the results. Default is ``tabulate``. Supported formats are ``tabulate``, ``json``.
DataSourceConfig Parameters
-----------------------... |
combine_chunk_380 | combine.txt | 380 | 512 | _name``,
``credential_config_file``, and ``impersonation_chain`` are not supported.
.. exampleinclude:: /../../sql/src/airflow/providers/common/sql/example_dags/example_analytics.py
:language: python
:dedent: 4
:start-after: [START howto_analytics_operator_with_gcs]
:end-before: [END howto_analytics_op... |
combine_chunk_381 | combine.txt | 381 | 512 | read here.
The connection supplies one of the following credentials, checked in this
order (matching ``WasbHook.get_conn``):
1. Azure AD service principal -- ``tenant_id`` extra, with ``login`` as the
client ID and ``password`` as the client secret (both required together)
2. Shared key -- the ``shared_access_key... |
combine_chunk_382 | combine.txt | 382 | 512 | alytics_operator_with_local]
Analytics TaskFlow Decorator
----------------------------
The ``@task.analytics`` decorator lets you write a function that returns the
analytics sql queries:
.. exampleinclude:: /../../sql/src/airflow/providers/common/sql/example_dags/example_analytics.py
:language: python
:start... |
combine_chunk_383 | combine.txt | 383 | 512 | ="SELECT * FROM my_table WHERE date_column >= %s", parameters=["2023-01-01"], df_type="pandas"
)
# Get DataFrame in chunks for memory-efficient processing of large results
for chunk_df in hook.get_df_by_chunks(sql="SELECT * FROM large_table", chunksize=10000, df_type="pandas"):
process_chunk(chunk_... |
combine_chunk_384 | combine.txt | 384 | 512 | to SQL Databases
===========================
The common SQL provider has no connection type of its own. Its operators, sensor and
``@task.sql`` decorator work with a connection from a database provider: a ``postgres``
connection from the Postgres provider, a ``snowflake`` connection from the Snowflake provider,
and s... |
combine_chunk_385 | combine.txt | 385 | 512 | share, set
``database`` or ``hook_params`` on the operator.
``database``
Runs the task against a different database from the one set in the connection. For most
connection types this replaces the connection's ``schema`` field, which is where Postgres,
MySQL and similar providers store the database name.
... |
combine_chunk_386 | combine.txt | 386 | 512 | so ``mssql+pyodbc`` selects the
``mssql`` dialect. It takes precedence over ``dialect``.
* - ``dialect``
- ``default``
- Name of the dialect to use, such as ``mssql`` or ``postgresql``. Read only when neither the
connection URI nor ``sqlalchemy_scheme`` gives a dialect, as with a JDBC connec... |
combine_chunk_387 | combine.txt | 387 | 512 | 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 ... |
combine_chunk_388 | combine.txt | 388 | 512 | viders-exasol:index>`
- :doc:`Google <apache-airflow-providers-google:index>`
- :doc:`JDBC <apache-airflow-providers-jdbc:index>`
- :doc:`Microsoft SQL Server <apache-airflow-providers-microsoft-mssql:index>`
- :doc:`MySQL <apache-airflow-providers-mysql:index>`
- :doc:`ODBC <apache-airflow-providers-odbc:index>`
- :do... |
combine_chunk_389 | combine.txt | 389 | 512 | Install the `sbx` CLI on every worker that can run this Dag and initialize its network policy once:
```console
sbx policy init deny-all
```
The worker must also be able to pull the default `python:3.12-slim` template. Run the test in an
Airflow system-test environment whose task process has access to the host `sbx` i... |
combine_chunk_390 | combine.txt | 390 | 512 | it from a sandbox command, exercises successful and
non-zero command exits plus write/read/list operations, checks that a command stopped by its
in-guest deadline leaves the sandbox and its files in place, checks that the toolset deletes
the one sandbox when the run ends, and requests open egress
(`SandboxSpec(block_n... |
combine_chunk_391 | combine.txt | 391 | 512 | dantic.dev/models/
- **Keep the hook thin.** `PydanticAIHook.get_conn()` maps Airflow connection fields to pydantic-ai
constructors. That is the hook's entire job. Do not add abstraction layers (builders, factories,
registries, Protocols) on top of pydantic-ai's own abstractions.
- **No premature abstraction.** Do ... |
combine_chunk_392 | combine.txt | 392 | 512 |
in the toolsets package rather than inheritance.
3. Keep constructors focused — only accept params that apply to the backend. Don't add params that
are silently ignored in certain modes.
4. Mark tools `sequential=True` when the backend uses synchronous I/O.
## Security
- **No dynamic imports from connection ex... |
combine_chunk_393 | combine.txt | 393 | 512 | governing permissions and limitations
under the License.
.. NOTE! THIS FILE IS AUTOMATICALLY GENERATED AND WILL BE OVERWRITTEN!
.. IF YOU WANT TO MODIFY TEMPLATE FOR THIS FILE, YOU SHOULD MODIFY THE TEMPLATE
``PROVIDER_README_TEMPLATE.rst.jinja2`` IN the ``dev/breeze/src/airflow_breeze/templates`` DIRECTORY
P... |
combine_chunk_394 | combine.txt | 394 | 512 | viders-common-sql>`_ ``common.sql``
`apache-airflow-providers-git <https://airflow.apache.org/docs/apache-airflow-providers-git>`_ ``git``
`apache-airflow-providers-modal <https://airflow.apache.org/docs/apache-airflow-providers-modal>`_ ``modal``
=============================================... |
combine_chunk_395 | combine.txt | 395 | 512 | ``sql`` ``apache-airflow-providers-common-sql>=2.2.0``, ``sqlglot>=30.0.0``
``common.sql`` ``apache-airflow-providers-common-sql>=2.2.0``
``langchain`` ``langchain>=1.0.0``
``llamaindex`` ``dataclasses-json>=0.6.7``, ``llama-index-core>=0.14.5``, ``llama-index-embeddings-openai>=0.6.... |
combine_chunk_396 | combine.txt | 396 | 512 | gather evidence from **all three sources** before assessing:
1. **Confluence spec** -- call `fetch_confluence_page` with the AIP's page ID.
Extract: deliverables, phases, completion criteria, and status.
2. **GitHub PRs and commits** -- call `search_github_prs` with both the AIP
number (e.g. "AIP-76") AND topic... |
combine_chunk_397 | combine.txt | 397 | 512 | numbers.
6. Do NOT characterize AIPs with vague editorializing like "near
completion", "minimal blockers", "requires foundational work", or
"Advanced maturity". State the fraction (e.g. "9/10 shipped,
1 in progress") and let the reader draw conclusions.
7. Do NOT add information beyond what the tools return. ... |
combine_chunk_398 | combine.txt | 398 | 512 | completion", "Advanced maturity",
"substantially implemented"). Replace with the fraction.
8. shipped_count + in_progress_count + not_started_count +
beyond_spec_count = total_count for each AIP.
<|file|>airflow/providers/common/ai/src/airflow/providers/common/ai/example_dags/skills/sql-reporting/SKILL.md
---
n... |
combine_chunk_399 | combine.txt | 399 | 512 | -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
un... |
Subsets and Splits
No community queries yet
The top public SQL queries from the community will appear here once available.