Jupyter on BigQuery

Panoply on Big Query

1. Install pandas-gbq in your Python environment.
   
   Install latest release version via conda

conda install pandas-gbq --channel conda-forge

Install latest release version via pip

pip install pandas-gbq

2. Import the packages as below:
   

from pandas.io import gbq

3. Run the below command in your Python environment:

df=gbq.read_gbq("<Your query>",  project_id="<Your project name>")

4. Click the highlighted link to generate an authorization code for your Google BigQuery account. You will be asked to choose your BigQuery account.
   
   

5. Click Allow.
   

6. An authorization code will be generated. Copy and paste as shown below:
   

You have successfully connected Jupyter Notebook to your BigQuery data warehouse.