Symptom
The following error is generated when validating Google BigQuery connection in Datasphere :
- Connection "XXX" is valid, but not all features are available.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.
- Remote tables are enabled.
Data Flows: Cause: Open request could not be performed due to error: ODBC call <SQLDriverConnect> for data source <> failed: <SQL submitted to database <> resulted in error <[Simba][BigQuery] (100) Error interacting with REST API: >. The SQL submitted is <SELECT 1>.>.
Replication Flows: Cause: Open request could not be performed due to error: ODBC call <SQLDriverConnect> for data source <> failed: <SQL submitted to database <> resulted in error <[Simba][BigQuery] (100) Error interacting with REST API: >. The SQL submitted is <SELECT 1>.>.
Read more...
Environment
- SAP Datasphere
Product
SAP Datasphere all versions
Keywords
GCP, Simba, BigQuery, Datasphere, Connection, SQLDriverConnect, Google , KBA , DS-DI-RF , Replication Flow Runtime , 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