title: GBQexception: How to read data with big query that is stored on google drive spreadsheet
body: <p>I uploaded a dataset to bigquery via the google drive option and linking the google spreadsheet to a dataset which I call 'dim_table' </p>
  
  <p>I then created a query to pull data from that dim_table dataset that I run daily.</p>
  
  <p>I am trying to create an automated script that will run the same query code I created to get the dim_table data set and create a new dataset call chart_A</p>
  
  <p>When I run this simple code:</p>
  
  <pre><code>import pandas_gbq as gbq
  gbq.read_gbq("Select * from data.dim_stats",'ProjectID')
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>GenericGBQException: Reason: 403 Access Denied: BigQuery BigQuery: No
    OAuth token with Google Drive scope was found.</p>
  </blockquote>
  
  <p>I have been trying to read documentation on pandas gbq but could not find any documentation that points me on how I can authenticate gdrive with pandas gbq or use oauth. Any help is appreciated! :)</p>
  
  <p>Let me know if you need me to comeup with a sample table online for testing.</p>
  
  <p>best</p>