SAP Knowledge Base Article - Preview

3471192 - Error: "Error reading BigQuery table data from Google API Server" occurs when using Google BigQuery table as source in SQL transformation - SAP Data Services

Symptom

  • When using Google BigQuery table as source in SQL transformation, error occurs
  • Error messages: "Data Services is unable to generate the schema information from the following SQL: 'SELECT * FROM xxx' Error details: Error reading BigQuery table data from Google API Server<xxx>; HTTP Error code:<400>, HTTP Error string:<Bad Request>, Application error:<Invalid table name>...(BODI-1130199)"

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 Data Services
  • Google BigQuery

Product

SAP Data Services 4.2 ; SAP Data Services 4.3

Keywords

Google BigQuery, GBQ, SQL, source, schema, invalid, Google API Server, HTTP, 400, Bad request, BODI-1130199, GBQ ODBC , KBA , EIM-DS-CON , Connectivity , 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.