Setting environment variable in python for google bigquery in Mac

Question

Before calling the Jupyter Notebook, i run the below code in Terminal for Google Application Credentials :

export GOOGLE_APPLICATION_CREDENTIALS="/Users/mac/Desktop/Bigquery-Key.json"

Then set the below configuration in Jupyter Notebook :

%load_ext google.cloud.bigquery
# Imports the Google Cloud Client Library 
from google.cloud import bigquery

# Instantiates a Client for Bigquery Service
bigquery_client = bigquery.Client()

Now, i wanted to write a Python script(.py file) which will do both the tasks instead of using Terminal.

How can it be done ? Kindly advise ? Thanks

DYZ · Accepted Answer · 2019-05-05 06:05:58Z

2

You can change the environment within a Python script. The environment is stored in the dictionary os.environ:

import os
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "/Users/mac/Desktop/Bigquery-Key.json"

answered May 5, 2019 at 6:05

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting environment variable in python for google bigquery in Mac

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related