When I tried to create a external table via google sheet, I end up with the following error?
Error: googleapi: Error 403: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials., accessDenied
Steps done:
-
Enabled drive api in the project
-
Given the service account in the google sheet