Get a Service Account Key to interact with BigQuery

Login to GCP Console. 

From the left navigation bar -> IAM & Admin -> Service Accounts

 

It takes you to the Service accounts page, click on ‘Create service account’ button. 

 

Give service account name, and description. ID is auto populated from the service account name.   

 

Click on ‘Create and continue’ button.

 

Upon successful creation of the service account, select a role, I give the role as Editor. 

 

Click on continue button.

 

Skip the section’ Grant users access to this service account’, click on Done button.

 

You will be taken to the service accounts listing page. Go to Actions column associated with given service account -> Manage keys.

 

You will be taken to Keys page. Here Add key -> Create new key.

 

Choose key type as JSON.

 

Click on Create button.

 

Json file be downloaded to your system, keep this key with you. You need to this going forward to interact with BigQuery using Python, Java SDKs.

 

You must store this key in a secure location such as Vault or Akeyless. If the key is exposed, unauthorized users could access data from your BigQuery project.

 

Previous                                                    Next                                                    Home