1904
78%

Ran 11 Jul 2017 10:18PM UTC

Jobs 1

Files 74

Run time 4s

Badge

Embed ▾

pending completion

Build # 1904

Build Type

Pull #456

travis-ci

Committed by

web-flow

Commit Message

CREDENTIAL_SCOPES: Add /auth/drive for bigquery tables backed by sheets

- Allow service accounts to query bq tables backed by sheets
- Without this scope you get the following 403 error from bq, where
  "globbing file pattern" appears to come from gdrive:
```
datalab.utils._http.RequestException: HTTP request failed (status 403): Access Denied: BigQuery BigQuery: Permission denied while globbing file pattern.
```
- Repro'ing is a bit complicated:
  - In gcp, make a "service account"
  - In gcp, create a "client id" for the service account
  - In gsuite, enable "domain-wide delegation" for the client id
  - Make a sheet
  - Share the sheet with the service account id (maybe not required?)
  - Make a bq table backed by the sheet
  - Query the table using the service account creds
- Here's the most helpful reference I found:
  - https://stackoverflow.com/a/41676921/397334

Pull Request Pull Request #456: CREDENTIAL_SCOPES: Add /auth/drive for bigquery tables backed by sheets

Run Details

3697 of 4937 relevant lines covered (74.88%)

0.75 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
4	100.0		.tox/coveralls/lib/python2.7/site-packages/google/datalab/utils/_utils.py

Jobs

ID	Job ID	Ran	Files	Coverage
4	1904.4 (TOX_ENV=coveralls)	11 Jul 2017 10:18PM UTC	0	74.88	Travis Job 1904.4

Source Files on build 1904

Detailed source file information is not available for this build.

googledatalab / pydatalab / 1904
78%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 1904

googledatalab / pydatalab / 1904 78%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 1904

googledatalab / pydatalab / 1904
78%

README BADGES
x