BigQuery permissions error when deploying functions in AEP federated database
When connecting Google BigQuery to Adobe Experience Platform using federated databases, the connection test succeeds, but deploying functions fails due to insufficient permissions. Granting the required BigQuery permissions resolves this issue.
Description description
Environment
- Product: Adobe Experience Platform
- Constraints: Integration with Google BigQuery using federated databases
Issue/Symptoms
The connection to BigQuery completes successfully, and the IP address is configured. However, when you attempt to deploy functions, an error states that functions cannot be installed. The underlying error indicates that access is denied because the bigquery.jobs.create permission is missing.
Resolution resolution
To fix this issue, follow these steps:
-
Contact your Google Cloud administrator.
-
Request that your account be granted the
bigquery.jobs.createpermission on the relevant Google Cloud project.Note: The permission can be assigned directly or by adding your account to a role such as BigQuery User.
-
After permissions are updated, retry deploying the functions in Adobe Experience Platform.
-
Verify that function deployment completes without errors.
Note
- If issues continue after updating permissions, raise a support ticket, as this may require checking network logs or performing additional troubleshooting.
- Information about the bigquery.jobs.create permission is available in the BigQuery IAM roles and permissions documentation.
Related reading
- Federated Audience Composition overview in Experience Platform Federated Audience Composition documentation
- Connect Google BigQuery to Experience Platform using the UI in AEP Source Connectors Guide