Hi
Currently it is only possible to use a personal google account to use to authenticat for a connection to Bigquery.
https://windsor.ai/documentation/how-to-integrate-data-into-google-bigquery/
Such connections and transfers should not be done on behalf of a user. It would be better to have a service account (key file) instead.
Cheers Davide