title: Append / Insert Data Into BigQuery Table Using R's bigrquery Library
body: <p>Question is straightforward. I have the following code:</p>
  <pre><code># authenticate
  bigrquery::bq_auth(path = '/Users/me/restofthepath/bigquery-credentials.json')
  
  # set my project ID and dataset name
  project_id &lt;- 'mygreatprojectid'
  dataset_name &lt;- 'static'
  
  # how i normally create a new table
  players_table = bq_table(project = project_id, dataset = dataset_name, table = 'players')
  bq_table_create(x = players_table, fields = as_bq_fields(players_df))
  bq_table_upload(x = players_table, values = players_df)
  </code></pre>
  <p>Here, <code>players_df</code> is a dataframe of player statistics already computed in R. The following code works successfully, creating a new table. However, if I have more players that I'd like to append to the table, I am struggling. I have tried the following:</p>
  <pre><code>bq_table_upload(x = players_table, values = players_df_2)
  </code></pre>
  <p>...where <code>players_df_2</code> is another dataframe with more player statistics... However, this returns the error <code>Error: Already Exists: Table mygreatprojectid:static.players [duplicate]</code></p>
  <p>Any thoughts on how to do this, preferably without having to delete + recreate the table? Thanks!!</p>
  <p><strong>EDIT</strong>: It looks like <a href="https://github.com/r-dbi/bigrquery/pull/304" rel="noreferrer">bq_table_patch</a> exists, however this appears to be for adding new fields/columns, not for appending new rows...</p>