Re: [I] Cannot schedule a DAG on a DatasetAlias when using a clean Airflow docker image (for CI) [airflow]

["Dev-iL (via GitHub)" <gi...@apache.org>]

Dev-iL commented on issue #44775:
URL: https://github.com/apache/airflow/issues/44775#issuecomment-2548344196

   ## Possible solution:
   
   Modify `airflow/datasets/__init__.py` as follows:
   
   ```diff
   @@ 26 @@
   - from sqlalchemy import select
   + from sqlalchemy import exc, select
   
   @@ 142 @@
   @internal_api_call
   @provide_session
   def expand_alias_to_datasets(
       alias: str | DatasetAlias, *, session: Session = NEW_SESSION
   ) -> list[BaseDataset]:
       """Expand dataset alias to resolved datasets."""
       from airflow.models.dataset import DatasetAliasModel
   
       alias_name = alias.name if isinstance(alias, DatasetAlias) else alias
   
   +    try:
           dataset_alias_obj = session.scalar(
               select(DatasetAliasModel).where(DatasetAliasModel.name == alias_name).limit(1)
           )
   +    except exc.OperationalError:
   +       return []
       if dataset_alias_obj:
           return [Dataset(uri=dataset.uri, extra=dataset.extra) for dataset in dataset_alias_obj.datasets]
       return []
   ```


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org