Client Secrets file in the gbq.py

[snamburi3]

https://github.com/pydata/pandas/blob/master/pandas/io/gbq.py#L102
Why is this in the gbq.py? can we set this as an environmental Variable?

[TomAugspurger]

cc @jacobschaer

[snamburi3]

Thanks. I think the best way would be to set GOOGLE_APPLICATION_CREDENTIALS in the script overriding the gbq.py defaults...
https://developers.google.com/identity/protocols/application-default-credentials

[snamburi3]

Or, can we switch to gcloud-python bigquery. We need to just set GOOGLE_APPLICATION_CREDENTIALS and then we are done. Thanks you all.

[jacobschaer]

I believe those credentials were to simplify the authentication flow. We created a Pandas GBQ google account so when the authentication flow pops a browser for credentials it can give a customized description of what the credentials are needed for (in case the user is unsure). It also lets us get a sense of how popular the module is in the sense of people actually authenticating with it.

Also, I think that non-application tokens had a rather restrictive expiration time.

@sean-schaefer - Sound right?

[parthea]

I've committed a change to the authentication flow in #11141. The authentication worked without modifying client_secret.

[parthea]

@jreback @snamburi3 Can this be closed? Pandas supports application default credentials with PR #13608