Python idiomatic client for Google BigQuery
Quick Start
$ pip install --upgrade google-cloud-bigqueryFor more information on setting up your Python development environment, such as installing pip and virtualenv on your system, please refer to Python Development Environment Setup Guide for Google Cloud Platform.
Authentication
With google-cloud-python we try to make authentication as painless as possible. Check out the Authentication section in our documentation to learn more. You may also find the authentication document shared by all the google-cloud-* libraries to be helpful.
Using the API
Querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. Google BigQuery (BigQuery API docs) solves this problem by enabling super-fast, SQL queries against append-mostly tables, using the processing power of Google’s infrastructure.
Create a dataset
from google.cloud import bigquery
from google.cloud.bigquery import Dataset
client = bigquery.Client()
dataset_ref = client.dataset('dataset_name')
dataset = Dataset(dataset_ref)
dataset.description = 'my dataset'
dataset = client.create_dataset(dataset) # API requestLoad data from CSV
import csv
from google.cloud import bigquery
from google.cloud.bigquery import LoadJobConfig
from google.cloud.bigquery import SchemaField
client = bigquery.Client()
SCHEMA = [
SchemaField('full_name', 'STRING', mode='required'),
SchemaField('age', 'INTEGER', mode='required'),
]
table_ref = client.dataset('dataset_name').table('table_name')
load_config = LoadJobConfig()
load_config.skip_leading_rows = 1
load_config.schema = SCHEMA
# Contents of csv_file.csv:
# Name,Age
# Tim,99
with open('csv_file.csv', 'rb') as readable:
client.load_table_from_file(
readable, table_ref, job_config=load_config) # API requestPerform a query
# Perform a query.
QUERY = (
'SELECT name FROM `bigquery-public-data.usa_names.usa_1910_2013` '
'WHERE state = "TX" '
'LIMIT 100')
query_job = client.query(QUERY) # API request
rows = query_job.result() # Waits for query to finish
for row in rows:
print(row.name)See the google-cloud-python API BigQuery documentation to learn how to connect to BigQuery using this Client Library.
3 maintainers
Metadata
3 maintainers
Release files for google-cloud-bigquery 0.32.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| google-cloud-bigquery-0.32.0.tar.gz | 134.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| google_cloud_bigquery-0.32.0-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 207.9 kB
Release files / google-cloud-bigquery-0.32.0.tar.gz
| Download URL | google-cloud-bigquery-0.32.0.tar.gz |
|---|---|
| Size | 134.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f1c274342a364904de0656eeee519ba6c2cf165204b824ccb39370b72f242894
|
|
BLAKE2b-256 checksum How to use checksums |
33f58bb2645bdd9a58ddbe33b34f07a8a1a9fd9b943927bda03eb23feb685ceb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / google_cloud_bigquery-0.32.0-py2.py3-none-any.whl
| Download URL | google_cloud_bigquery-0.32.0-py2.py3-none-any.whl |
|---|---|
| Size | 73.4 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
0681c20dbc663ba382397fd4fc45bd6dba92339408ff399365e47303753f3084
|
|
BLAKE2b-256 checksum How to use checksums |
159302f7e554d2d6da037edad04e9f5586914f1d40217d8d6f0abe523a6907cb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
