In Airflow, I need to run a query (with some joins) on BigQuery tables. The query results in a single computed value. What is the best way to push this result to xcom? I have to use this result in the next task in pipeline.

I tried BigQueryExecuteQueryOperator but it’s not pushing values to xcom.

Thank you.