title: How to "Save as Table" on Bigquery and define the location of the table?
body: <p>I'm querying data with BigQuery in two different projects in Google Cloud. Both projects have the tables with Data Location (table>details> Data Location) as "US".</p>
  
  <p>When I query it and get a result I want to save it as another table. So using the BQ UI I try hitting the "save as table" button on top the query results. </p>
  
  <p>As I said, both projects have their data in the US but when clicking here I get the following error message:</p>
  
  <blockquote>
    <p>Errors: Cannot read and write in different locations: source: US,
    destination: EU</p>
  </blockquote>
  
  <p>But I didn't define EU anywhere.</p>
  
  <p>Does anyone know how I can change that parameter from the BigQuery UI? Or even how to write it straight in the Query</p>
  
  <p>Thanks a lot!</p>