title: Create and replace BigQuery tables
body: <p>How do I create and replace an existing BigQuery table? I use datalab to define BigQuery queries and write the results to BigQuery tables.</p>
  
  <p>The most efficient way I found to do this is:</p>
  
  <pre><code>%%bq query --name helloWorld
  Select * from someTable
  </code></pre>
  
  <p>Followed by</p>
  
  <pre><code>%%bq execute --table schemaName.destination_table --query helloWorld
  </code></pre>
  
  <p>However I have to manually drop the table each time</p>
  
  <p>From the command line I can execute something like:</p>
  
  <pre><code>bq query --destination_table [PROJECT_ID]:[DATASET].[TABLE] --replace '[QUERY]'
  </code></pre>
  
  <p>Is there some similar functionality in python/Datalab?</p>