Shahar Epstein

@eladkal Could you please assign me?

@eladkal Could you please assign me?

`BigQueryGetData`'s `generate_query()` method is used for submitting **deferred** jobs, while normally, the operator utilizes the hook's method `list_rows`. The latter utilizes [BigQuery's API](https://cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/list) directly, **which does not support ordering clauses**....

> But, how do you get the result when using `BigQueryInsertJobOperator`? As far as I understood it, it returns the job_id, not the result 🤔 You got me on that...

> > A better option, IMO, would be to create a dedicated operator that will return the results into the XCOM given a job_id, to keep operations atomic. > >...

cc: @Lee-W, @eladkal

Please assign me :)

@Ram-tripath would you still like to work on this issue? It would be helpful if you could provide additional screenshots so it could be resolved.

I'm closing this issue, as the original PR (#34337) that caused it was [reverted](https://github.com/astronomer/airflow/commit/b4321bb0947cec5c8ba17382f8fe1dfc3f8cfed4). I'm trying to work on an improved version of the original PR, and I'll ensure that...

@abhishekbhakat Would you still like to work on this issue? I'd also suggest to rename the title to "Deprecate task lop prefix", as it seems that a decision has been...