1

BigQuery data transfer job failed with following error message.

"Error code 7 : Invalid account; The issue may be resolved by verifying that the user has sufficient permissions and updating the credentials for this transfer config; error: "invalid_grant" error_description: "Invalid account""

As mentioned in https://cloud.google.com/bigquery-transfer/docs/cloud-storage-transfer, required permissions are given to the service account used for the transfer. Still getting this error.

SKumar
  • 43
  • 6
  • 1
    Updated the user credentials and the issue resolved – SKumar Jun 10 '21 at 06:32
  • Glad you found a solution. Could you please add the steps you followed as an answer for this post and accept it so other users with a similar issue can use your solution? – Kevin Quinzel Jul 08 '21 at 21:53
  • I changed the user credentials with a new service account having necessary permission to the job – SKumar Aug 12 '21 at 15:37

1 Answers1

0

The issue was resolved by OP by updating the user credentials with a new service account having the necessary permissions for the job, according to [1]

Felix L.
  • 222
  • 1
  • 11
  • @SKumar How did you refresh the credentials to a service account? For me its taking me to google sign in page – Sam Mar 16 '22 at 09:42
  • how to add service account from console? – Sam Mar 16 '22 at 09:43
  • @Sam at present we cannot refresh the credential from Console. We need to use Cloud Shell. [link](https://cloud.google.com/bigquery/docs/scheduling-queries#update_scheduled_query_credentials) `code`bq update --transfer_config --update_credentials --service_account_name= – SKumar Feb 24 '23 at 05:43
  • I ended up tainting the resource in terraform so that its recreated with the correct credentials – Sam Mar 09 '23 at 12:54