SAP Knowledge Base Article - Preview

2913551 - Unable to select data from Google BigQuery SQL transform - Data Services

Symptom

  • Jobs using Google BigQuery tables imported using a non-USA Region dataset will fail with the following error.
  • Error "Error getting Bigquery table metadata from Google API server. HTTP Error code <404>. 
  • HTTP Error string: <Not Found>, application error <[ "error:{ "code": 404, "message": "Not found: Job tsl-datalake: job <>".  "domain": "global", "reason": "not found" } ], "status":"NOT_FOUND"}}> (BODI-1130199)
  • Change the dateset location to USA region and the error will not occur.


Read more...

Environment

  • SAP Data Services 14.2
  • Google BigQuery

Product

SAP Data Services 4.2

Keywords

DS, Data Services, Google BigQuery, ODBC, non-USA Region, USA Region , KBA , EIM-DS-EXE , Job Execution , EIM-DS-DEP , Deployment, Installation, Upgrade , Problem

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.