SAP Knowledge Base Article - Public

3508438 - Replication flow from Datasphere to BigQuery is failing with accessDenied error - SAP Datasphere

Symptom

Replication flow from Datasphere to BigQuery is failing with accessDenied error:

An error occurred. Replication runs will restart on <timestamp>. Error: error checking existence of table <table name>: googleapi: Error 403: Access Denied: Table <my project name>:<my dataset name>.INFORMATION_SCHEMA.TABLES: User does not have permission to query table <my project name>:<my dataset name>.INFORMATION_SCHEMA.TABLES, or perhaps it does not exist., accessDenied

Environment

SAP Datasphere

Cause

This is a permission missing.

Resolution

  • Check if the required permissions to query the INFORMATION_SCHEMA.TABLES view have been assigned as per the link: https://cloud.google.com/bigquery/docs/information-schema-tables
    • Required permissions
      • To query the INFORMATION_SCHEMA.TABLES view, you need the following Identity and Access Management (IAM) permissions:
        • bigquery.tables.get
        • bigquery.tables.list
        • bigquery.routines.get
        • bigquery.routines.list

      • Each of the following predefined IAM roles includes the preceding permissions:
        • roles/bigquery.admin
        • roles/bigquery.dataViewer
        • roles/bigquery.metadataViewer

See Also

https://cloud.google.com/bigquery/docs/information-schema-tables

Keywords

BigQuery, Replication Flow, RF, Replicationflow, Error 403, Access Denied, INFORMATION_SCHEMA.TABLES , KBA , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere all versions