Executing the query using bq command line in Google Big Query -

i execute query using below python script , table gets populated 2,564,691 rows. when run same query using google big query console, returns 17,379,353 rows (query as-is). wondering whether there issue below script. not sure whether --replace in bq query replaces past result set instead of appending it.

any appreciated.

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) 

in web ui can use query history option navigate respective queries.
after locate them - can expand respective entries , see query executed
more sure comparing query texts see source of "discrepancy" right away!

added

in query history - not can see query text, configuration properties used respective query - write preference example , others. if query text same can see potential difference in configuration give clue