title: How to select data from partitioned tables into partitioned destination tables?
body: <p>In Google Big Query, it's straightforward to select across all partitioned tables using wildcard operators. For example, I could select all rows from date partitioned tables with something like this:</p>
  
  <pre><code>SELECT * FROM `project.dataset.table_name__*`;
  </code></pre>
  
  <p>That would give me all results from <code>project.dataset.table_name__20161127</code>,
  <code>project.dataset.table_name__20161128</code>, <code>project.dataset.table_name__20161129</code>, etc.</p>
  
  <p>What I don't understand is how to specify partitioned destination tables. How do I ensure that result set is written to, as an example, <code>project.dataset.dest-table__20161127</code>,
  <code>project.dataset.table-name__20161128</code>, <code>project.dataset.table-name__20161129</code>? </p>
  
  <p>Thanks in advance!</p>