This error occurs when the credentials used to access the Google Cloud Platform project data source do not have the bigquery.datasets.create permission, resulting in the following error:
Error: The credentials for this Data Source targetGCPProjectID do not have the required permissions. Please ensure the credentials have the necessary permissions and try again.
How to resolve this error
Go to required Google Cloud Platform project
Search for ‘IAM' and navigate to that page
Press 'Grant access' and grant one or more of the roles described below.
For a data source with a service account access
Grant the service account permission by adding the user with at least the roles of:
BigQuery data editor + BigQuery job user
BigQuery admin
For a data source with a user credentials access
Grant the user credentials permission by adding the user to the GCP project with the following permissions:
BigQuery data owner + BigQuery job user
BigQuery admin
If you encounter any further issues or need additional assistance, please don't hesitate to reach out to the Alvie support team.