search

CityOfLosAngeles / civis-gcp-transition

Transition Civis jobs to Google Cloud Platform
Apache License 2.0
0 stars 0 forks source link

Get ibis query working #1

Closed tiffanychu90 closed 3 years ago

tiffanychu90 commented 3 years ago

@alexistome09 Can you look at this notebook: https://github.com/CityOfLosAngeles/civis-gcp-transition/blob/311-workflow/bigquery-credential.ipynb

I was able to correctly compile an ibis expression, but not to execute it.

I'm using a credentials.json that I didn't check into the repo.

tiffanychu90 commented 3 years ago

@alexistome09 I get this error when I try to execute the query (now that the ibis error is fixed: PermissionDenied: 403 request failed: the user does not have 'bigquery.readsessions.create' permission for 'projects/ita-datalakepoc'

atome09 commented 3 years ago

@tiffanychu90, I added that access to the service account, can you please try again?

tiffanychu90 commented 3 years ago

Also add the bigquery.readsessions.getData permission