英文:
Unable to Query External BigQuery Tables
问题
当尝试查询访问由Google Sheets支持的外部表的视图时，我遇到了这个错误：googleapi: Error 403: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials., accessDenied。
我已经请求了Drive的范围，还有其他我错过的东西吗？
client, err := bigquery.NewClient(ctx, "projectID", option.WithScopes("https://www.googleapis.com/auth/drive"))
if err != nil {
return nil, err
}
英文:
When trying to query a view that access an external table backed by Google Sheets, I am getting this error. googleapi: Error 403: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials., accessDenied
I have requested the scope for Drive, is there anything else I missed?
client, err := bigquery.NewClient(ctx, "projectID", option.WithScopes("https://www.googleapis.com/auth/drive"))
if err != nil {
return nil, err
}
答案1
得分: 2
确保运行查询的用户或服务帐号已被授予足够的权限来读取Google表格。
英文:
Make certain that the user, or service account, which is running the query, has been granted sufficient permissions to read the Google Sheet.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论