SAP Knowledge Base Article - Preview

3810615 - Data preview of BigQuery virtual table via SDA fails with HTTP 403 permission denied (SAP HANA Cloud)

Symptom

  • When opening data from a virtual object/table connected to Google BigQuery via Smart Data Access, an error occurs and no data is displayed.
  • The issue persists after creating and configuring a new Google Cloud service account for the connection.
  • HTTP 403 Forbidden is returned by Google BigQuery during requestType=BigQuery_ExecuteQuery.
  • Error body contains: "error": {
        "code": 403,
        "message": "Access Denied: Project meli-bi-data: User does not have bigquery.jobs.create permission in project meli-bi-data.",
        "errors": [
          {
            "message": "Access Denied: Project meli-bi-data: User does not have bigquery.jobs.create permission in project meli-bi-data.",
            "domain": "global",
            "reason": "accessDenied"
          }
        ],
        "status": "PERMISSION_DENIED"
      }

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA Cloud, client utilities
  • SAP HANA Smart Data Access

Product

SAP HANA Cloud 1.0

Keywords

BigQuery, SDA, Smart Data Access, HTTP 403, PERMISSION_DENIED, bigquery.jobs.create, roles/bigquery.jobUser, Data Preview, virtual table, remote source, HANA Database Explorer, REST API, access denied, IAM, billing project , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.