title: Bigquery API: Running query with destinationTable does not save results
body: <p>I'm trying to use Google Apps Script to automate a daily aggregation process. The idea is to run on a few tables from one dataset, and save their results to a table on a second dataset. My user has permissions on both relevant datasets.</p>
  
  <p>My request looks as follows</p>
  
  <pre><code>        var request = {
          "maxResults": 10000,
          "useQueryCache": false,
          "destinationTable": {
                "projectId": "project_name_obfuscated",
                "datasetId": "project_114151_shared",
                "tableId": "test123"
              },
          "writeDisposition": "WRITE_TRUNCATE",
          "createDisposition": "CREATE_IF_NEEDED",
          "allowLargeResults": true,
          "query": "query syntax here"
        };
  
    var queryResults = BigQuery.Jobs.query(request, "project_name_obfuscated");
  </code></pre>
  
  <p>(I've obfuscated the name of the projects and the query itself for confidentiality reasons).</p>
  
  <p>The query actually runs fine, however, it's not being saved into the designated project/dataset/table which I've defined.</p>
  
  <p>In the BQ UI I'm seeing something like:</p>
  
  <pre><code>Job ID: project_name_obfuscated:job_NhkQpi110p3i5yoOO7nzXp3tTKY
  Start Time: 5:47pm, 20 Oct 2014
  End Time: 5:47pm, 20 Oct 2014
  Bytes Processed: 0 B
  Destination Table: project_name_obfuscated:_138c3340e691065e8db0b55781b5a41c6b4bcd49.anonev_SOiiRC10lfetj000kcj4rmXNc5E
  </code></pre>
  
  <p>Any ideas what I'm doing wrong?</p>