title: Copy table from one dataset to another in google big query
body: <p>I intend to copy a set of tables from one dataset to another within the same project. I execute the code in Ipython notebook.</p>
  <p>I get the list of table names to be copied in the variable “value” using the below code:</p>
  <pre><code>list = bq.DataSet('test:TestDataset')
  
  for x in list.tables():
     if(re.match('table1(.*)',x.name.table_id)):
       value = 'test:TestDataset.'+ x.name.table_id
  </code></pre>
  <p>Then i tried using the “bq cp” command to copy table from one dataset to another. But I cannot execute the bq command in the notebook.</p>
  <pre><code>!bq cp $value proj1:test1.table1_20162020
  </code></pre>
  <p>Note:</p>
  <p>I tried with bigquery command to check whether there is a copy command associated with it but could not find any.</p>