doujiongqin0687 2018-05-13 21:40
浏览 63
已采纳

googleapi:错误400:数据集myProject:myDataset仍在使用中,resourceInUse

I am trying to remove dataset using BigQuery API.

I have no problem removing the dataset in question manually using BigQuery UI, however when I am using the API I am seeing the following error:

googleapi: Error 400: Dataset myProject:myDataset is still in use, resourceInUse

I have checked that there are no open connections using the dataset.

Here is the code used to remove dataset:

package main

import (
    "log"
    "context"
    "golang.org/x/oauth2"
    "golang.org/x/oauth2/jwt"
    "google.golang.org/api/bigquery/v2"
)



func main() {
    var authConfig *jwt.Config
    var projectID = "myProject"
    var datasetID = "myDataset"
    ctx := context.Background()
    oauthClient := oauth2.NewClient(ctx, authConfig.TokenSource(ctx))
    service, err := bigquery.New(oauthClient)
    if err != nil {
        log.Fatal(err)
    }
    err = service.Datasets.Delete(projectID , datasetID).Context(ctx).Do()
    if err != nil {
        log.Fatal(err)
    }
}
  • 写回答

1条回答 默认 最新

  • doushuo8677 2018-05-14 04:48
    关注

    For a dataset that contains tables and/or views, you have two options:

    • Delete each table and view, then delete the dataset.
    • Delete the dataset directly, passing true for the deleteContents option. This will delete all tables and views in the dataset.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#Mybatis#的问题:怎么办重复数据如下"KSDM":37,"KSMC":"呼吸内科门诊","ksdm":37,"ksmc":"呼吸内科门诊"xml文件填写
  • ¥40 servlet的web程序部署出错
  • ¥50 activiti 新建流程系列问题
  • ¥50 为什么我版本升级之后运行速度变慢5倍??
  • ¥15 如何在gazebo中加载机械臂和机械手
  • ¥15 纯运放实现隔离采样方案设计
  • ¥20 easyconnect无法连接后缀带.com的网站,一直显示找不到服务器ip地址,但是带有数字的网站又是可以连接上的,如何解决
  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!