install be_helper on datalab

Question

I knew that BigQuery module is already installed on datalab. I just wanna to use bq_helper module because I learned it on Kaggle.

I did !pip install -e git+https://github.com/SohierDane/BigQuery_Helper#egg=bq_helper and it worked.

but I can't import the bq_helper. The pic is shown below.

Please help. Thanks!

I used python2 on Datalab.

Answer 1

I am not familiar with the BigQuery Helper library you shared, but in general, in Datalab, it may happen that you need to restart the kernel in order for the libraries to be properly loaded.

I reproduced the scenario you proposed: installing the library with the command !pip install -e git+https://github.com/SohierDane/BigQuery_Helper#egg=bq_helper and then trying to import it in the notebook using:

from bq_helper import BigQueryHelper

bq_assistant = BigQueryHelper("bigquery-public-data", "github_repos")
bq_assistant.project_name

At first, it did not work and I obtained the same error as you; then I clicked on the Reset Session button and the library was loaded properly.

Some other details that may be relevant if this does not work for you are:

• I am also running on Python2 (although the GitHub page of the library suggests that it was only tested in Python3.6+).
• The Custom metadata parameters in the Datalab GCE instance are: created-with-datalab-version: 20180503 and created-with-sdk-version: 208.0.2.