title: Executing the query using bq command line in Google Big Query
body: <p>I execute a query using the below Python script and the table gets populated with 2,564,691 rows. When I run the same query using Google Big Query console, it returns 17,379,353 rows (query is as-is). I was wondering whether there is some issue with the below script. Not sure whether --replace in bq query replaces the past result set instead of appending to it.</p>
  
  <p>Any help would be appreciated.</p>
  
  <pre><code>dateToday =  (time.strftime("%Y/%m/%d"))
  dateToday1 = dateToday.replace('/','')
  
  commandStr = "type C:\Users\query.txt | bq query --allow_large_results --replace --destination_table table:dataset1_%s -n 1" %(dateToday1)
  </code></pre>