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:

  1. Contact your Google Cloud administrator.

  2. Request that your account be granted the bigquery.jobs.create permission 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.

  3. After permissions are updated, retry deploying the functions in Adobe Experience Platform.

  4. 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.
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f