Python 2.7 : Python and BigQuery service object.

Here’s another tutorial about python and google. I thought it would be useful for the beginning of 2018.

The goole team tell us:

What is BigQuery?

This tutorial it follows more precisely the steps from here .

First of all, you must create an authentication file by using the Create service account from your google project.

Go to Google Console , navigate to the Create service account key page.

From the Service account dropdown, select New service account.

Input a name into the form field.

From the Role dropdown, select Project and Owner .

The result is a JSON file type (this is for authentificate with google) download it rename and put into your project folder .

Like into the next image:

Now, select from left area the Library do add the BigQuery API, try this link .

Search for BigQuery API and the use the button ENABLE to use it.

The next step is to install this python modules: pyopenssl and google-cloud-bigquery .

C:Python27Scripts>pip install -U pyopenssl
C:Python27Scripts>pip install --upgrade google-cloud-bigquery

Add this JSON file to windows path from my test folder:


Because my json file is named python_doc.json then this is the name I will use with my python script.

Let’s see the script:

import google
from import bigquery

def query_shakespeare():
    client = bigquery.Client()
    client = client.from_service_account_json('python_doc.json')
    query_job = client.query("""
        SELECT corpus AS title, COUNT(*) AS unique_words
        FROM `bigquery-public-data.samples.shakespeare`
        GROUP BY title
        ORDER BY unique_words DESC
        LIMIT 10""")

    results = query_job.result()  # Waits for job to complete.

    for row in results:
        print("{}: {}".format(row.title, row.unique_words))

if __name__ == '__main__':

The result is:

hamlet: 5318
kinghenryv: 5104
cymbeline: 4875
troilusandcressida: 4795
kinglear: 4784
kingrichardiii: 4713
2kinghenryvi: 4683
coriolanus: 4653
2kinghenryiv: 4605
antonyandcleopatra: 4582

NOTE: Take care of the json file because it gives access to your google account and tries to use the restrictions according to the application’s requirements.

python-catalin责编内容来自:python-catalin (源链) | 更多关于

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 综合编程 » Python 2.7 : Python and BigQuery service object.

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录