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 ONE Support launchpad (Login required).

Search for additional results

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