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]

Reply via email to