Creating a Compute Engine instance for managing BigQuery in Google Cloud

1
votes

I need a VM to load data into an existing BigQuery table.

I create a new Compute Engine with:

  1. The scope having access to all Cloud APIs
  2. Default service account (auto-generated name [email protected])
  3. This service account having "Editor" permissions in the project

This VM allows me to read BQ with bq ls, but when I try editing with bq rm <dataset>, it says

[email protected] does not have permission to delete dataset

What is wrong? Is it possible to give the full access to BQ to the instance, like the one Cloud Shell has?

Or the VM should authenticate as described here: How to auth into BigQuery on Google Compute Engine??

1
google-bigquerygoogle-compute-enginegoogle-cloud-platform

1 Answers

1
votes

To delete a dataset, you need "Owner" permissions on the dataset or the containing project.

More info about access control can be found here:

https://cloud.google.com/bigquery/access-control