title: Sending bigquery data by email -airflow
body: <p>I have a project in BQ that consists of sending reports in csv format on a daily basis.
  These reports are the results of queries to bigquery which are then compressed to csv and mailed.</p>
  <p>Use the implementation of the following question to solve my problem.
  <a href="https://stackoverflow.com/questions/58456094/how-to-run-a-bigquery-query-and-then-send-the-output-csv-to-google-cloud-storage">How to run a BigQuery query and then send the output CSV to Google Cloud Storage in Apache Airflow?</a>
  <a href="https://i.stack.imgur.com/s4PYG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s4PYG.png" alt="enter image description here" /></a></p>
  <p>Now, I am trying to change that implementation.</p>
  <p>the reason is because:</p>
  <ol>
  <li><p>the main reason is because I don't like the idea of ​​creating temporary tables to export the result. I have not found an operator that exports the result of a query.</p>
  </li>
  <li><p>I don't need to take the data to storage, especially if I'm going to download it to the local airflow directory anyway.</p>
  </li>
  </ol>
  <p>Try using &quot;get_pandas_df&quot; from
  bigquery_hook and then pass the result through xcom to another task that will be in charge of compressing to csv. Due to the heavyness of the Dataframe it was not possible.</p>
  <p>Do you have any idea how to do it directly?</p>