Page History

Status

Motivation

Incremental processing is a very one of the most, it not the most common pattern in implement with Airflow use cases. In some pipelines, this is strictly necessary. Although external event driven scheduling is supported today in Airflow through via AIP-82, incremental polling is not something that has been easy to implement. In more traditional DAG Authoring authoring (Sensors, Operators, etc.), users are forced to use XCom or Variables for storing values (watermarks) for incremental processing, or inventing and implementing their own solution. In the case of event-driven triggering, it’s even more challenging for users to build their custom incremental processing implantationimplementation, due to the lack of XCom support and limitations of Variable support s. 

There have been several attempts to store state within a child of the BaseEventTrigger to  to manage incremental processes, while none of these have proven to be effective or robust. This has seriously hampered the ability for the community to build logic to monitor Assets such as object stores, SQL databases, and other non-queue/stream-based Assets.   With AIP-103, this state store will be developed and available to use as part of this AIP.

For Triggers built for "Asset watching", it is helpful, if not essential to to persist some state. This AIP will provide an interface for using the state store built by AIP-103 for "Asset watching".

Considerations

What change do you propose to make?

At a high level, we propose to make the following changes:

•   
•  "Flipping" the current model to make Asset watching Asset-aware.
•  Adding some sort of helper and/or updating BaseEventTrigger to include methods allowing users to store and retrieve values (watermarks). 
•  Introducing a StateVariable model for persisting Asset/Trigger state metadata. This would be a general model, not limited to event-driven scheduling, allowing for Airflow users to store and retrieve state as specified in EventTrigger code, as well as within things like Operators, Sensors, etc.
•  This model should be reusable and extendable in other Airflow components (Workers, Scheduler, etc). The way it fetches and stores the data should also vary depending on the components.
•  Create a pluggable backend, similar to the XCom model, to act as a state store for users not interested in using the “batteries included” model.
•  Adding a UI component to surface StateVariable 's.
• Pass through context including the Asset being "watched" to the BaseEventTrigger  to make the BaseEventTrigger  Asset-aware.
•  (Stretch Goal) Provide a more intuitive, decorator-based approach for authoring logic used for "Asset watching".

What problem does it solve?

This solves one of the most glaring problems with building Triggers compatible with "Asset-watching", or event-driven scheduling; the inability to persist and retrieve state for an Asset. Without a model like StateVariable way to retrieve the state for an Asset , it's nearly impossible to do things like monitor an S3 bucket for new files landing or handle the addition/removal of a new row to a SQL database. Despite being one of the most touted features of Airflow 3.0, the community has been very slow to develop and distribute Event Triggers to be used for "Asset-watching". This AIP aims to address this problem in an elegant and "Airflow-onic" way, using a "batteries included" model, along with a pluggable backend.

Technical Details

using the work laid in AIP-103.

Technical Details

The important thing about this change is this; this is not a breaking change to any existing processes. The same interface will be used to define AssetWatcher 's; a BaseEventTrigger  is defined and passed to the AssetWatcher . Then, the AssetWatcher  is passed to the Asset  via the watchers  parameter. At runtime, a reference to the Asset  will be passed through to the BaseEventTrigger , allowing for the Trigger to be Asset-aware.

Defining Assets and AssetWatchers

from airflow.sdk import Asset, AssetWatcher
from plugins.triggers import GenericEventTrigger

...  # Other imports

generic_asset_watcher = AssetWatcher(
    name="generic_asset_watcher",
    trigger=GenericEventTrigger(
        ...
    )
)

generic_asset = Asset(
    name="generic_asset",
    watchers=[generic_asset_watcher]
)

with DAG(
    dag_id="my_dag",
    start_date=datetime(2026, 1, 1),
    schedule=[generic_asset]
) as dag:
    ...

BaseEventTrigger

Examples

“Watching” an S3 Bucket

One of the most common use-cases for event-driven scheduling will most likely be “watching” an object store for changes. Ideally, each time that an AssetWatcher’s AssetWatcher ’s Trigger runs, it willshould not re-scan the entire bucket. The workflow would look something like this:

1. After the first Trigger run, a timestamp of this “scan” for data of the Asset is recorded.
2. On the second run, the Trigger retrieves the timestamp (watermark) from the completion of the last run for that Asset and only scans the object store for files files after that watermark.
3. Trigger writes the watermark state for the Asset again.
4. Process repeats for N Trigger runs following.

Incremental Data in SQL Databases

Another common use-case for event-driven scheduling is “watching” tables in relational databases; we’ll use Postgres as an example. Outside of traditional CDC, it’s common for data teams to use an updated column in a Postgres database to upsert data. Using the StateVariable approach, Airflow users can use the following workflow. This  This workflow should feel quite similar to the workflow for “watching” an S3 Bucket; that’s intentional, as we’re trying to implement a repeatable pattern.

1. After the first Trigger run, a timestamp of this “scan” for data is recorded and stored to the table_last_updated_at StateVariableof the Asset is recorded and persisted.
2. On the second run, the Trigger retrieves the watermark (value) state for that Asset from the completion of the last run and only scans the updated column in the desired table for records with a timestamp greater than the watermark.
3. Trigger writes the watermark updates the state of the Asset again.
4. Process repeats for N Trigger runs following.

Below is an example of a Trigger that executes a SQL query to incrementally read data, with a watermark. Implementing something like the new_watermark  and get_watermark  methods is not required; it just shows an example of how StateVariable  can be used.

from airflow.sdk import StateVariable

class SQLIncrementalQueryTrigger(BaseEventTrigger):
	state_variable_name = "table_last_updated_at"
    ...
	
	@property
	def new_watermark(self):
		return datetime.now()
	
	@property
	def get_watermark(self):
		return StateVariable.get(self.state_variable_name)

    async def run(self):
        while True:
            results = conn.get_records("SELECT * FROM table WHERE updated_at > '%s'", self.get_watermark())

            if results:
    		 	StateVariable.set(key=self.state_variable_name, value=self.new_watermark)
                yield TriggerEvent({"status": "success", "results": results})
                break
            else:
                await asyncio.sleep(self.poke_interval)

Why is it needed?

Allow for an Airflow-supported methodology for persisting state and unblocking Being able to persist and access the state  of an Asset unblocks the development of Event Triggers for Airflow users interested in "Asset-watching".

Are there any downsides to this change?

There is one theorized downside; Airflow users leveraging the StateVariable  model as a sort of key-value store outside of an Event Trigger. However, this is not something that is overly concerning. It would be much more likely for Airflow users to abuse the Variable  model instead. Along with this are the general downsides to added complexity, but those are minimal with this proposalNo, there are no significant downsides to this change. This will not be a breaking change.

Which users are affected by the change?

DAG Authors: these users will now have access to a tool that makes authoring Triggers, Sensors, and Tasks used to orchestrate incremental processes more accessible and unlocks the ability to further build out event-driven logic.Deployment Managers: introducing a pattern with a pluggable backend may provide deployment managers an additional component of their Airflow “stack” to stand up and manage. This will also require a DB migration, which is outlined below.

How are users affected by the change? (e.g. DB upgrade required?)

Current users who don't use incremental event triggers are unaffected by this change. However, this new feature requires a DB migration, since a new model is being added. The only changes needed in this case would be the addition of a new tableUsers who are "Asset-watching" will now have the ability to make these process Asset-ware and persist state for that Asset.

What is the level of migration effort (manual and automated) needed for the users to adapt to the breaking changes? (especially in context of Airflow 3)

There are not breaking changes included as part of this AIP. Added the StateVariable model will require a DB migration, but forces no breaking changes upon users.

Other considerations?

• This would be compatible with Asset partitions.
• For now, this sort of “state store” would be limited to Asset “watching”.
• Naming is going to be important, both for the state store, as well as the properties/methods used to store/retrieve state. Some options that have been throw around include State , StateVariable , ProcessState , Watermark , and more.
One of the biggest challenges that we're facing is how this is tied to an Asset. A Trigger defined for an AssetWatcher  is in no way tied to the Asset itself. This disconnect makes the naming and implementation of this functionality challenging. Should this be something that is tied to an Asset? Should it be only applicable at the Trigger-level? Overall, the goal of this AIP is to make event-driven scheduling more intuitive for Airflow users
• .
 
• One of the potential future works is to add StateVariable to the Airflow UI, so users can see exactly the StateVariable values, similar to how Airflow Variable is presented.

What defines this AIP as "done"?

This AIP will be considered “done” when the PR creates the model and the pluggable backend is merged passes through the needed context to make BaseEventTrigger  Asset-aware and the solution is well-documented.