dimanche 24 juillet 2016

Google Bigquery API: How to get the name of temporary table

I know that: The result of query will save in a temporary table. But how to get its name to use in other query. from googleapiclient.discovery import build from googleapiclient.errors import HttpError from oauth2client.client import GoogleCredentials def test(): project_id = "598330041668" credentials = GoogleCredentials.get_application_default() bigquery_service = build('bigquery', 'v2', credentials=credentials) # [START run_query] query_request = bigquery_service.jobs() query_data = { 'query': ( 'SELECT * ' 'FROM [test.names];') } query_response = query_request.query( projectId=project_id, body=query_data).execute() # [END run_query]

Aucun commentaire:

Enregistrer un commentaire