title: Best way to insert data into a Bigquery table
body: <p>I would like to know if there are any preferred way to insert data into a bigquery table?</p>
  <p>I am inserting new rows to a BQ table at the end of a Cloud Composer DAG. I've used a custom operator based on the <a href="https://airflow.readthedocs.io/en/stable/_api/airflow/contrib/operators/bigquery_operator/index.html?highlight=bigquery%20operators#airflow.contrib.operators.bigquery_operator.BigQueryOperator" rel="nofollow noreferrer"><code>BigQueryOperator</code></a> as the following:</p>
  <pre><code>INSERT INTO `&lt;project&gt;.&lt;dataset&gt;.&lt;table&gt; (col1,col2,col3)
  VALUES
  (ccc,ccc,ddd),
  (...,...,...)
  </code></pre>
  <p>The values added to the table can be up to 500 rows (...,...,...) but it is generally around 10-100 rows.</p>
  <p>Is there a recommended/better way to do this? I don't know if it worth passing by GCS since the &quot;file&quot; containing all the rows won't be big.</p>