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.
SAP Knowledge Base Article - Preview