Problem Description:


Export Job to BigQuery fails with the below error in the job log.


[ERROR] 2019-10-03 10:31:29,238 [main] infoworks.discovery.export.Driver:189 :: java.util.concurrent.ExecutionException: com.google.cloud.bigquery.BigQueryException: Request had insufficient authentication scopes.


Root Cause:


This issue occurs if the permissions required to write to Bigquery is not provided while creating the Infoworks edge node in GCP.


Solution:


a) Stop the Infoworks edge node.
b) Provide the permissions required to the Default Service Account. Look for the section "Permissions for the BigQuery Data Load"
https://docs.infoworks.io/datafoundry-2.8.0/bigquery-export

c) Sart the Infoworkks edge node from GCP.
d) Run the Export job again.


Applicable Infoworks Versions:


v2.7.x,v2.8.x