{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas-gbq/issues/202","repository_url":"https://api.github.com/repos/pydata/pandas-gbq","labels_url":"https://api.github.com/repos/pydata/pandas-gbq/issues/202/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas-gbq/issues/202/comments","events_url":"https://api.github.com/repos/pydata/pandas-gbq/issues/202/events","html_url":"https://github.com/pydata/pandas-gbq/issues/202","id":354834838,"node_id":"MDU6SXNzdWUzNTQ4MzQ4Mzg=","number":202,"title":"_try_credentials requires read permissions","user":{"login":"telenieko","id":10505,"node_id":"MDQ6VXNlcjEwNTA1","avatar_url":"https://avatars2.githubusercontent.com/u/10505?v=4","gravatar_id":"","url":"https://api.github.com/users/telenieko","html_url":"https://github.com/telenieko","followers_url":"https://api.github.com/users/telenieko/followers","following_url":"https://api.github.com/users/telenieko/following{/other_user}","gists_url":"https://api.github.com/users/telenieko/gists{/gist_id}","starred_url":"https://api.github.com/users/telenieko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telenieko/subscriptions","organizations_url":"https://api.github.com/users/telenieko/orgs","repos_url":"https://api.github.com/users/telenieko/repos","events_url":"https://api.github.com/users/telenieko/events{/privacy}","received_events_url":"https://api.github.com/users/telenieko/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-08-28T17:43:20Z","updated_at":"2018-08-28T20:39:34Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI am trying out pandas-gbq as part of a data loading process (we load lots of stuff into DataFrame's for cleanup and processing, and the final result is loaded into BigQuery).\r\n\r\nOn that use case, the account used needs only write access to BigQuery but _try_credentials issues a SELECT which makes it fail.\r\n\r\nMoreover, this is run on GCP so google.auth.default() succeeds but as the SELECT fails, the library tries interactive authentication which fails.\r\n\r\nEither _try_credentials should not require read permissions (unless on a read operation) or the method should be optional.\r\n\r\nRelated to  #198 "},"comment":{"url":"https://api.github.com/repos/pydata/pandas-gbq/issues/comments/416732585","html_url":"https://github.com/pydata/pandas-gbq/issues/202#issuecomment-416732585","issue_url":"https://api.github.com/repos/pydata/pandas-gbq/issues/202","id":416732585,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNjczMjU4NQ==","user":{"login":"tswast","id":247555,"node_id":"MDQ6VXNlcjI0NzU1NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/247555?v=4","gravatar_id":"","url":"https://api.github.com/users/tswast","html_url":"https://github.com/tswast","followers_url":"https://api.github.com/users/tswast/followers","following_url":"https://api.github.com/users/tswast/following{/other_user}","gists_url":"https://api.github.com/users/tswast/gists{/gist_id}","starred_url":"https://api.github.com/users/tswast/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tswast/subscriptions","organizations_url":"https://api.github.com/users/tswast/orgs","repos_url":"https://api.github.com/users/tswast/repos","events_url":"https://api.github.com/users/tswast/events{/privacy}","received_events_url":"https://api.github.com/users/tswast/received_events","type":"User","site_admin":false},"created_at":"2018-08-28T20:39:34Z","updated_at":"2018-08-28T20:39:34Z","author_association":"COLLABORATOR","body":"A short-term solution could be to only run `_try_credentials` for `read_gbq` and not `to_gbq`. I'd welcome a PR that does that."}}
{"actor":{"display_login":"tswast"}}