How to use Vanna with BigQuery¶
In [ ]:
import vanna as vn
When Running on GCP¶
If you're running on a machine hosted on GCP, you likely already have credentials so you just have to specify the project
In [ ]:
vn.connect_to_bigquery(
project_id="myprojectid"
)
When Running on Google Colab¶
Use colab auth to authenticate with your google account and then specify the project
In [ ]:
from google.colab import auth
auth.authenticate_user()
vn.connect_to_bigquery(
project_id="myprojectid"
)
Using a Credentials File¶
You should only do this if you're running on a local machine and not on GCP or Colab
In [ ]:
vn.connect_to_bigquery(
project_id="myprojectid",
cred_file_path="path/to/credentials.json",
)