title: google-bigquery server to server authentification fails - python
body: <p>I'm building the app that gets the data from BigQuery to another server. And trying to use the server to server auth with genereted key for service account. 
  But receive the followig error.</p>
  
  <pre><code>import json
  
  from httplib2 import Http
  import argparse
  from oauth2client.client import GoogleCredentials
  from googleapiclient.errors import HttpError
  from oauth2client.service_account import ServiceAccountCredentials
  from apiclient.discovery import build
  from oauth2client.service_account import ServiceAccountCredentials
  
  scopes = ['https://www.googleapis.com/auth/sqlservice.admin']
  credentials = ServiceAccountCredentials.from_json_keyfile_name(
      'credentials_bq.json', scopes)
  bigquery_service = build('bigquery', 'v1', credentials=credentials)
  
  
  query_request = bigquery_service.jobs()
  query_data = {
      'query': (
          'select count( distinct meta_id) from  [..table.name] '
          'where MSEC_TO_TIMESTAMP(meta_serverTs) &gt;= \'2016-10-28 10:00:00 UTC\'')
  }
  
  
  
  query_response = query_request.query(
      projectId='my_project_id',
      body=query_data).execute()
  </code></pre>
  
  <p>Error returned :</p>
  
  <pre><code>Traceback (most recent call last):
    File "test_connection_bq.py", line 35, in &lt;module&gt;
      body=query_data).execute()
    File "/usr/local/lib/python2.7/dist-packages/oauth2client/_helpers.py", line 133, in positional_wrapper
      return wrapped(*args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/googleapiclient/http.py", line 838, in execute
      raise HttpError(resp, content, uri=self.uri)
  googleapiclient.errors.HttpError: &lt;HttpError 403 when requesting https://www.googleapis.com/bigquery/v2/projects/my_project_id/queries?alt=json returned "Insufficient Permission"&gt;
  </code></pre>