无法查询外部 BigQuery 表格。

huangapple go评论95阅读模式
英文:

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.

huangapple
  • 本文由 发表于 2021年7月17日 04:27:04
  • 转载请务必保留本文链接:https://go.coder-hub.com/68414915.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定