IPython Magics for BigQuery

To use these magics, you must first register them. Run the %load_ext magic in a Jupyter notebook cell.

%load_ext google.cloud.bigquery

This makes the %%bigquery magic available.

Code Samples

Running a query:

%%bigquery
SELECT name
, SUM(number) as count
FROM
`bigquery-public-data.usa_names.usa_1910_current`
GROUP BY name
ORDER BY count DESC
LIMIT
3

Running a parameterized query:

%%bigquery --params {"corpus_name": "hamlet", "limit": 10}
SELECT word
, SUM(word_count) as count
FROM
`bigquery-public-data.samples.shakespeare`
WHERE corpus
= @corpus_name
GROUP BY word
ORDER BY count DESC
LIMIT
@limit

API Reference