Error: Access to the custom source BigQuery table was denied. Verify that the required permissions are granted on the table, or check if the table still exists.
What happened
The attribution model encountered an access issue while trying to read data from your custom source BigQuery table. This error occurs when the system either lacks the necessary permissions to access the table or the table cannot be found.
Common causes
This error typically occurs due to one of the following reasons:
Missing Permissions: The service account doesn't have the BigQuery Data Viewer permission on the specified table.
Table Not Found: The table was deleted or renamed after the custom source was configured.
Permission Changes: Dataset or project-level permissions were modified, removing access.
Configuration Error: The project, dataset, or table name specified in the configuration is incorrect.
How to Fix
Follow these steps to resolve the access issue:
1. Verify the Table Exists
Log into the Google Cloud Console.
Navigate to BigQuery.
Confirm the table exists at the location specified in your configuration: `project.dataset.table`.
2. Grant Necessary Permissions
Go to the BigQuery table in the Google Cloud Console.
Click on "Share" or "Permissions".
Add the service account with the BigQuery Data Viewer role.
You can grant permissions at the table, dataset, or project level.
3. Re-configure if Needed
If the table was moved or renamed, update your custom source configuration with the correct table details.
Ensure the format follows: `project_id.dataset_id.table_id`.
Need More Help?
If you've followed these steps and still encounter this error, please reach out to alvie support.