'UsageError: Line magic function `%%bigquery` not found

I am very new to Big query. I am trying to load data from a Big query table to pandas dataframe. I followed the syntax given in the documentation here. Unfortunately, I am getting below error.

enter image description here

I read a stackoverflow solution here, and followed its solution but I got this.

enter image description here

Then, I tried separating the code lines, but I get a new error UsageError: Line magic function %%bigquery not found.

enter image description here

I have been trying for a couple of hours to resolve this. Even restarting the kernel is not working. This works the very first time you run it but not if you run it twice. I have no clue what's going on. Any thoughts?

pythonsqlgoogle-bigquery


Solution 1:[1]

This can be solved by removing the comments

#-----------------------
#Loading the bigquery ..
#-----------------------

and just retaining the %%bigquery magic syntax as shown below

%%bigquery personas_raw
SELECT * FROM `project-id.dataset.table`

Here is the screenshot of my testing using a sample public dataset WITH COMMENTS and got the same error message as your post. enter image description here

And here is the screenshot of the same syntax when the comment is removed. enter image description here

Solution 2:[2]

Make sure you have run:

%load_ext google.cloud.bigquery

in a separate cell. (And don't put comments before the magic line, as the other answer says.)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2

Related Questions