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.
Running a query:
.. literalinclude:: ./samples/magics/query.py :dedent: 4 :start-after: [START bigquery_jupyter_query] :end-before: [END bigquery_jupyter_query]
Running a parameterized query:
.. literalinclude:: ./samples/magics/query_params_scalars.py :dedent: 4 :start-after: [START bigquery_jupyter_query_params_scalars] :end-before: [END bigquery_jupyter_query_params_scalars]
.. automodule:: google.cloud.bigquery.magics.magics :members: