Connection to Big Query issue

  • 27Views
  • Last Post 02 September 2022
0
votes
Mohamed Nagy posted this 01 September 2022

I schedule a Data Flow package that use Big Query Connection and the connection work. but when the schedule start to run in time the package stop and give this error

Package failed: Error while retrieving an access token occurred. Error type: invalid_grant. Error description: Token has been expired or revoked..

How can i stop this error and get a stable connection that i can depend on?

schedule connection bigquery
0
votes
Serhii Muzyka posted this 02 September 2022

Hello Mohamed,

Thank you for contacting Skyvia Support.

 

Most likely that your BigQuery token got expired after some period of time, which caused the failure of the package.

We recommend you to use this guide https://stackoverflow.com/questions/35462126/how-to-get-a-long-duration-of-the-bigquery-apis-token to find out how to get a long-term “refresh token”.

Also see more information about Authorizing API requests here: https://cloud.google.com/bigquery/docs/authorization.

Should you have other questions, don't hesitate to reach out.

 

Best regards,

Serhii

Technical Support Engineer

 

New Ticket
Categories
Popular Tags
Close