You might encounter the following authorization error when you use the OAuth out-of-band (OOB) flow with SAS/ACCESS Interface to Google BigQuery:
Error 400: invalid_request
SAS/ACCESS Interface to Google BigQuery provides a utility that generates the refresh token needed for OAuth authentication. Currently, the getRefreshToken uses the OOB flow. Google has announced that they are deprecating the use of OOB and will block all clients and users starting on October 3, 2022.
The following client IDs are impacted by this deprecation:
- IDs that previously generated a refresh token
- IDs that try to get the refresh token from Google for the first time when attempting to connect via the provided URL
For first attempts, an authorization error appears, as shown in the following image:
The utility was updated on 13OCT2022. The process has changed slightly with this update. Opening a browser with the URL provided results in an error that states that you cannot access the site. However, you can copy the necessary access token from the resulting URL. Copy the value after the ?code parameter (the value ends just before the &scope parameter). This is the access token that is provided to the utility to obtain the generated refresh token.