What is happening? Alvie is unable to create the necessary datasets or execute jobs in your Google Cloud Project because the connected account lacks the specific administrative permissions required.
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.
Cause Why did this happen? This error typically occurs when the user or service account connected to Alvie does not have the bigquery.datasets.create permission. Common causes include:
Insufficient IAM Roles: The account has "Viewer" access but lacks the "Editor" or "Admin" rights needed to modify the project.
Service Account Restrictions: If using a service account, it may not have been granted the proper BigQuery roles at the project level.
Solution Follow these steps to resolve the issue:
Navigate to External Platform: Log in to the Google Cloud Console and select your project: [targetGCPProjectID].
Locate the Section: Search for "IAM" in the top search bar and navigate to the IAM & Admin page.
Action: Click the Grant Access button and add the email address of the account used in Alvie. Assign the appropriate roles based on your connection type:
For Service Account Access: Grant BigQuery Data Editor AND BigQuery Job User (or simply BigQuery Admin).
For User Credential Access: Grant BigQuery Data Owner AND BigQuery Job User (or simply BigQuery Admin).
External Steps (If applicable): Ensure the changes are saved. Permission updates in Google Cloud are usually near-instant but can occasionally take a few minutes to propagate.
Verify: Return to Alvie and trigger a manual rerun of the affected connector. Wait 2–5 minutes for the status to turn Healthy (Green).
Prevention & Tips To avoid seeing this error again:
Role Principle: We recommend using the BigQuery Admin role for the simplest setup, as it encompasses all necessary permissions for Alvie to manage datasets and jobs.
Audit IAM: If you have strict security policies, ensure any new user responsible for the Alvie integration is added to the IAM list with these specific roles immediately.
If you encounter any further issues or need additional assistance, please don't hesitate to reach out to the Alvie support team.