BigQuery API returns "No query found"

Question

I am trying to query my BigQuery database using Python but every time I run this code I get an error saying "No query found" even though the query works fine on Google Cloud Console.

Note: myfilepath.json and my-project-id are valid values in the code I have.

def explicit():
    import os
    os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "myfilepath.json"
    credentials = GoogleCredentials.get_application_default()
    bigquery_service = build('bigquery', 'v2', credentials=credentials)
    query_request = bigquery_service.jobs()

    query_data = {
        'query': ('#standardSQL SELECT * FROM `SentimentAnalysis.testdataset`')
    }

    query_response = query_request.query(
        projectId='my-project-id',
        body=query_data).execute()
    print(query_response)

explicit()

The error I get every time is:

googleapiclient.errors.HttpError: <HttpError 400 when requesting https://www.googleapis.com/bigquery/v2/projects/my-project-id/queries?alt=json returned "1.58 - 1.58: No query found.">

It returns "Invalid table name: SentimentAnalysis.testdataset [Try using standard SQL] — Anas Al-Masri
– Anas Al-Masri, Commented Feb 2, 2018 at 16:33
exactly! I hoped this small exercise will give you an idea. so what was happenning before is the whole query was treated as a one string starting with # which made it a comment. do now you should just set respective property to standardSQL. Something like - query_request.use_legacy_sql = False — Mikhail Berlyant
– Mikhail Berlyant, Commented Feb 2, 2018 at 16:53

Guillem Xercavins · Accepted Answer · 2018-02-02 17:51:19Z

2

Working snippet based on Mikhail's advice using 'useLegacySql': False:

from apiclient.discovery import build

def explicit():
    bigquery_service = build('bigquery', 'v2')

    query_request = bigquery_service.jobs()

    query_data = {
        'query': ('SELECT * FROM `dataset.table`'),
        'useLegacySql': False
    }

    query_response = query_request.query(
        projectId='PROJECT_ID',
        body=query_data).execute()
    print(query_response)

explicit()

Alternatively, you can use the idiomatic client:

from google.cloud import bigquery

client = bigquery.Client()

QUERY = ("""
    SELECT * FROM `project.dataset.table`
    LIMIT 10""")

query_job = client.query(QUERY)

results = query_job.result()
rows = list(results)

for row in rows:
    print row

edited Feb 2, 2018 at 17:51

answered Feb 2, 2018 at 17:35

Guillem Xercavins

7,0781 gold badge18 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BigQuery API returns "No query found"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related