title: Bigquery command line tool on Windows
body: <p>This may be simple but for quite some time I am getting this error!</p>
  
  <p>On windows and python 2.7</p>
  
  <blockquote>
    <p>import subprocess</p>
    
    <p>p = subprocess.Popen(["C:\Program Files\Google\Cloud
    SDK\google-cloud-sdk\bin\bq"])</p>
  </blockquote>
  
  <p>Traceback (most recent call last):
    File "", line 1, in 
    File "C:\Python27\lib\subprocess.py", line 710, in <strong>init</strong>
      errread, errwrite)
    File "C:\Python27\lib\subprocess.py", line 958, in _execute_child
      startupinfo)
  WindowsError: [Error 2] The system cannot find the file specified</p>
  
  <p>When I run normally from command prompt with bq it runs perfectly. 
  I am missing something with subprocess and bq.</p>
  
  <p>Thanks</p>
  
  <p>EDIT:
  After trying with several solutions provided below I found that when I use "shell=True" most of the commands work on windows shell!</p>
  
  <blockquote>
    <p>e.g:  p = subprocess.Popen('dir', shell=True)</p>
  </blockquote>