title: BigQuery - Transfers automation from Google Cloud Storage - Overwrite table
body: <p>Here's the case:</p>
  
  <ul>
  <li>Our client daily uploads CSVs (overwritten) to a bucket in Google Cloud Storage (each table in a different file).</li>
  <li>We use BigQuery as DataSource in DataStudio</li>
  <li>We want to automatically transfer the CSVs to BigQuery.</li>
  </ul>
  
  <p>The thing is, even though we've:</p>
  
  <ol>
  <li>Declared the tables in BigQuery with "Overwrite table" write preference option</li>
  <li>Configured the daily Transfers vía UI (BigQuery  >  Transfers) to automatically upload the CSVs from Google Cloud one hour after the files are uploaded to Google Cloud, <a href="https://cloud.google.com/bigquery/docs/cloud-storage-transfer" rel="noreferrer">as stated by the limitations</a>.</li>
  </ol>
  
  <p>The automated transfer/load is by default in "WRITE_APPEND", thus the tables are appended instead of overwritten in BigQuery.</p>
  
  <p>Hence the question: How/where can we change the</p>
  
  <blockquote>
    <p>configuration.load.writeDisposition = WRITE_TRUNCATE</p>
  </blockquote>
  
  <p>as stated <a href="https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.load.writeDisposition" rel="noreferrer">here</a> in order to overwrite the tables when the CSVs are automatically loaded?</p>
  
  <p>I think that's what we're missing.</p>
  
  <p>Cheers.</p>