Issue

You cannot delete datasets and tables in BigQuery.

Environment

Destination: BigQuery

Resolution

Set the bigquery.dataOwner role for your user in order to delete any dataset/tables for your BigQuery project.

You can visit this comprehensive role guide for more details.

Cause

Permissions issue/Incorrect or insufficient permissions.