title: Downloading Large data from bigquery dataset and pandas
body: <p>I'm trying to download data from the big query public dataset and store it locally in a <code>CSV</code> file. When I add  <code>LIMIT 10</code> at the end of the query, my code works but if not, I get an error that says:</p>
  
  <pre><code>Response too large to return. Consider setting allowLargeResults to true in your job configuration. 
  </code></pre>
  
  <p>Thank you in Advance!</p>
  
  <p>Here is my code:</p>
  
  <pre><code>import pandas as pd
  import pandas_gbq as gbq
  import tqdm
  
  def get_data(query,project_id):
      data = gbq.read_gbq(query, project_id=project_id,configuration={"allow_large_results":True})
      data.to_csv('blockchain.csv',header=True,index=False)
  
  if __name__ == "__main__":
      query = """SELECT * FROM `bigquery-public-data.crypto_bitcoin.transactions` WHERE block_timestamp&gt;='2017-09-1' and block_timestamp&lt;'2017-10-1';"""
      project_id = "bitcoin-274091"
      get_data(query,project_id)   
  </code></pre>