title: google bigquery bq command syntax error
body: <p>Could somebody explain me why I am getting an syntax error in the following code:</p>
  
  <pre><code>$ bq query --allow_large_results --destination_table=clients.tab_cl1 "SELECT * from adagency-167918:sourcedataset.src_table$20170516 where advertiserid=1 and timestamp="2017-05-16""
  </code></pre>
  
  <p>and this is the error I am getting:</p>
  
  <blockquote>
    <p>Error in query string: Error processing job 'adagency-167918:bqjob_r215d56938dbaa2b7_0000015c1a4c2932_1': Encountered " "-" "- "" at line 1, column 31.
        Was expecting:
        </p>
  </blockquote>