Can't delete BigQuery dataset that was created via the Python API

Question

I can create and delete a BigQuery dataset from the Web UI just fine. But, when I use the Python API to create a dataset, I am not able to delete it. I get an error message that I don't have the "bigquery.datasets.delete" permission for that dataset which is not true because I have the editor role in this project. And, if I can create and delete a dataset from the UI, then I should be able to create and delete a dataset using the API as well, correct?

I don't have any tables in this dataset btw. And, I am using the Python API (https://googlecloudplatform.github.io/google-cloud-python/stable/bigquery-usage.html) to create a dataset by dataset.create()

Answer 1

The editor role is not able to delete datasets in BigQuery - link.

With that in mind, I'm assuming that you also the project owner, so when you log in to the web UI, you are able to do anything you want. When you are interacting with the Python API, are you using your personal credentials or a service account? If the later, you should ensure that you have given the service account proper access levels to delete.

Hope that helps!