After a few minutes, the Vertex AI console will have your instance name followed by Open Jupyterlab. Click Open Jupyterlab.

A new tab will open in your browser with the JupyterLab environment. Select Python 3 under Notebook.

Enter the following query in the first cell of the notebook:

CODE...

The command makes use of the magic function %%bigquery. Magic functions in notebooks provide an alias for a system command. %%bigquery runs the query in the cell in BigQuery and stores the output in a Pandas DataFrame object named df.

Run the cell by hitting Shift + Enter, when the cursor is in the cell. Alternatively, if you navigate to the Run tab you can click on Run Selected Cells. Note the keyboard shortcut for this action

View the first five rows of the query's output by executing the following code in a new cell:

CODE...

Run the cell by hitting Shift + Enter, when the cursor is in the cell. Alternatively, if yo