dstandish commented on code in PR #44456:
URL: https://github.com/apache/airflow/pull/44456#discussion_r1876223820
##########
airflow/dag_processing/collection.py:
##########
@@ -435,14 +456,17 @@ def add_asset_trigger_references(
refs_to_add: dict[tuple[str, str], set[str]] = {}
refs_to_remove: dict[tuple[str, str], set[str]] = {}
triggers: dict[str, BaseTrigger] = {}
+ active_assets = _find_active_assets(self.assets.keys(),
session=session)
Review Comment:
here's the generated query:
```
SELECT
asset.id,
asset.name,
asset.uri,
asset."group",
asset.extra,
asset.created_at,
asset.updated_at,
dag_1.dag_display_name,
dag_1.dag_id,
dag_1.is_paused,
dag_1.is_active,
dag_1.last_parsed_time,
dag_1.last_expired,
dag_1.fileloc,
dag_1.processor_subdir,
dag_1.bundle_id,
dag_1.latest_bundle_version,
dag_1.owners,
dag_1.description,
dag_1.default_view,
dag_1.timetable_summary,
dag_1.timetable_description,
dag_1.asset_expression,
dag_1.max_active_tasks,
dag_1.max_active_runs,
dag_1.max_consecutive_failed_dag_runs,
dag_1.has_task_concurrency_limits,
dag_1.has_import_errors,
dag_1.next_dagrun,
dag_1.next_dagrun_data_interval_start,
dag_1.next_dagrun_data_interval_end,
dag_1.next_dagrun_create_after,
dag_schedule_asset_reference_1.asset_id,
dag_schedule_asset_reference_1.dag_id AS dag_id_1,
dag_schedule_asset_reference_1.created_at AS created_at_1,
dag_schedule_asset_reference_1.updated_at AS updated_at_1
FROM
asset
JOIN asset_active ON asset_active.name = asset.name AND asset_active.uri
= asset.uri
LEFT OUTER JOIN dag_schedule_asset_reference AS
dag_schedule_asset_reference_1
ON asset.id = dag_schedule_asset_reference_1.asset_id
LEFT OUTER JOIN dag AS dag_1 ON dag_1.dag_id =
dag_schedule_asset_reference_1.dag_id
WHERE
(asset_active.name, asset_active.uri) IN (VALUES (?, ?))
AND (EXISTS (SELECT
1
FROM dag_schedule_asset_reference
WHERE
asset.id = dag_schedule_asset_reference.asset_id
AND dag_schedule_asset_reference.dag_id IN (?)
))
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]